Piwik database - clickpath, where to find?

Dear Community,

we’re trying to analyze the Piwik database with R to get Information about the clickpath of our visitors.

We already worked with the database schema of Piwik, and analyzed different tables ( as log_visit , log_link_visit_action, log_action ), but we couldn’t find it.

What we need are the information about the visited pages of the individual visit.

Maybe someone already knows where we can find the information?

Thanks for your support!