Event category and event action missing from log_link_visit_action table description

[heurteph-ei]

Related page / section: https://developer.matomo.org/guides/database-schema#visit-actions idaction_event_category and idaction_event_action are missing from this section (whereas they are mentioned in Action Types > Referencing action types section)

idaction_name: the ID of the page title action type for this action in case of page view, of the event name in case of custom event, of the search keyword in case of search event search_cat: the search category in case of search event search_count: the number of search results in case of search event idaction_event_category: the ID of the event category action type for this action (in case of custom event) idaction_event_action: the ID of the event action action type for this action (in case of custom event)

Without this, it is not easy to understand the data model especially that idaction_name can be used for different types of events...

[heurteph-ei]

Hi @sgiehl No news about this very easy ticket after almost 3 month?

[sgiehl]

Hey @heurteph-ei. Sorry, I'm currently not able to handle that and not sure when someone else will be. If you have some time, feel free to apply the changes yourself and create PR here: https://github.com/matomo-org/developer-documentation/blob/live/docs/5.x/database-schema.md