AnsweredAssumed Answered

Database Definition/Description

Question asked by beren on Sep 29, 2009
Latest reply on Sep 29, 2009 by zaizi
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.