I looked through the wiki and searched in these forums, but could not find any documentation that describes the structure of the database and the definitions of the columns/relationships. What's the best document to look at to better understand the database structure that Alfresco uses behind the scenes.
What I was trying to do is build up some simple reports using Jasper(a dashboard I suppose) that could show me some statistics on how people are using alfresco. A lot of the relationships are fairly simple, but then I saw some other things and wondered what their purpose was, for example the alf_audit_*** tables.
Any pointers would be appreciated.
