Improve audit system to be able to fetch ( log) at a parent level events on its direct children

When I check the history of a document ( folder, workspace) for example I want to be able to see in the logs information related to its direct children ( creation, modification, security updated, etc).
Currently this is not possible without logging all these infos on the parent itself and this means duplicate log entries and to store more data in the audit tables.