topic Re: Alfresco database in Alfresco Archive

Alfresco database

notherien — Tue, 20 Oct 2009 14:27:34 GMT

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

Re: Alfresco database

rliu — Tue, 20 Oct 2009 18:38:12 GMT

What exactly are you looking for in the database?

Re: Alfresco database

notherien — Tue, 20 Oct 2009 22:09:28 GMT

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

thank you in advance

Re: Alfresco database

charlyrpc — Fri, 05 Nov 2010 20:54:28 GMT

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..!!

Re: Alfresco database

jamaica — Sat, 14 Jan 2012 09:50:24 GMT

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

Re: Alfresco database

mviswam — Sat, 19 May 2012 10:32:52 GMT

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.

Re: Alfresco database

tbedford — Fri, 01 Jun 2012 15:05:51 GMT

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!

Re: Alfresco database

samudaya — Mon, 09 Jul 2012 06:25:04 GMT

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

Re: Alfresco database

mrogers — Mon, 09 Jul 2012 09:20:07 GMT

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.

Re: Alfresco database

samudaya — Tue, 10 Jul 2012 03:52:36 GMT

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

Re: Alfresco database

somaye — Wed, 05 Sep 2012 09:54:03 GMT

Hi,
How can I see files`s version in alfresco database ?
Thanks