Alfresco database

[notherien]

can you help me to find a description of the Alfresco database tables?

thank you in advance

[rliu]

What exactly are you looking for in the database?

[notherien]

I like to know the meaning of various tables and fields, and what it serves each tables

thank you in advance

[charlyrpc]

HI,

I'm new user of Alfresco, but I need know, what is the values recommended for tablespaces for my DB Oracle 10G. I don't know how can we configure the tablespaces for alfresco?? if you have some document or something like that..  I'll appreciate so much..!!

[jamaica]

I need the ERD for Alfreco AVM. Please can anyone help?

[mviswam]

Hi

I would like to know the table which is holding the name/ ids of contents/files in Alfresco. I am trying to get a list of contents by the type.

[tbedford]

Well, this depends a bit on your installation, but one thing you could try is to use a tool like Navicat to reverse engineer the database tables. Depending on your tool it will give you a nice graphical representation (ERD) showing all the database tables. We don't document this currently as I don't believe you should need to know this information for most Alfresco deployments, and remember the database schemata do change!

[samudaya]

Hi  notherien,

I also tried to understand database structure around years back. However finally I realized it is useless and there are enough APIs we can use for most of the requires queries.

Best Regards
SAMU

[mrogers]

Useless is a bit strong.

However it is considered to be private (as in the java keyword sense) to alfresco and the schema changes from time to time.     And you certainly should be very cautions about writing directly to the D.B.

Yes you should use one of the many alfresco provided APIs instead.

[samudaya]

Hi all,

Sorry for the word "Useless". Actually I wanted to say API is more useful than direct call to the Alfresco DB.

Thanks
SAMU