topic Alfresco Database Diagram in Alfresco Archive

Alfresco Database Diagram

why1525 — Mon, 30 Oct 2006 10:59:08 GMT

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

Re: Alfresco Database Diagram

fdesrosiers — Thu, 23 Nov 2006 13:26:16 GMT

Edison,

Maybe this will help

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

Re: Alfresco Database Diagram

why1525 — Wed, 29 Nov 2006 07:52:36 GMT

Hi,

Thanks for helping me here…Really appreciate it.

Thanks you.

Re: Alfresco Database Diagram

damodar — Fri, 09 Mar 2007 09:53:13 GMT

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

Re: Alfresco Database Diagram

andy — Fri, 09 Mar 2007 12:01:34 GMT

Hi

Your best plan will be to get this via auditing.

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

Andy

Re: Alfresco Database Diagram

piercgg — Fri, 06 Apr 2007 13:37:55 GMT

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

Re: Alfresco Database Diagram

kayan — Thu, 13 Aug 2009 18:58:05 GMT

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

Kayan

Re: Alfresco Database Diagram

yuvaraj — Tue, 22 Sep 2009 07:32:45 GMT

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

Re: Alfresco Database Diagram

nirvanvjain — Thu, 03 Feb 2011 10:03:59 GMT

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

Re: Alfresco Database Diagram

darryl_staflund — Fri, 04 Feb 2011 17:49:38 GMT

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