Alfresco Database Diagram

[why1525]

Hello,
I need a database diagram of Alfresco. Is there any softcopy available for me to download. This is because i need to more understand the Alfresco Database structure.

Thank you.
Edison

[fdesrosiers]

Edison,

Maybe this will help

http://wiki.alfresco.com/wiki/Data_Dictionary_Guide

[why1525]

Hi,

Thanks for helping me here…Really appreciate it.

Thanks you.

[damodar]

Hi
I wanted to prepare reports like

Details of new registered users
Details of new uploaded documents
List of pending documents
List of approved documents
Maximum downloaded documents per day

I would want to have the details of the related table/s so as i could query the same and build a jasper reports.


Thanks in advance..
Damodar

[andy]

Hi

Your best plan will be to get this via auditing.

See http://wiki.alfresco.com/wiki/Audit

Andy

[piercgg]

Well this still is not what I am looking for.

Can anyone tell me where to find:

1.  A description of each table and its purpose.
2.  A description of each field in each table and their purpose.
3.  A graphic of the relational links between each table.

TIA
GINGER

[kayan]

http://wiki.alfresco.com/w/images/7/71/Alfresco-Core-DB-Tables.jpg

Kayan

[yuvaraj]

Hi all,

    Can somebody tell me what are the different databases supported with Alfresco 3.1 enterprise edition? I am trying to use sybase anywhere database. Is that possible?

Thanks in advance,

Yuvaraj.T

[nirvanvjain]

Can any one guide me how all tables interconnected ?

I am able to see all the tables but unable to understand the relationship in between them?   

(Alfresco developers have better idea about this….please guide)


-Nirvan V. Jain

[darryl_staflund]

Hi there,

If you're working with a < 3.4.x instance of Alfresco, download the source code from the repository and study its Hibernate files.  If you're working with a >= 3.4.x instance, look at its iBatis files.

Darryl