Database Schema

[mehul1511]

Hi,

Is there a database schema other then alfresco core table PNG!! I am having hard time understanding the jbpm and avm tables. If there is a way I can access that schema, please let me know..

Thanks in advance..

[mikeh]

There are some tools that can do this.

If you're on a Mac: http://www.malcolmhardie.com/sqleditor/
Otherwise: http://code.google.com/p/database-diagram/

Mike

[mehul1511]

Thank you for the reply, but I was not able to dump the sql schema as there there is many confusing DML in .sql files of alfresco. Please let me know if there is just a default image of the whole database schema other then alfresco core tables offcourse.

Thank you

[viron82]

Here are the database schema that I received. I created a database dump and import it into Power Disagner. Version 3.4.d (win32).
   I propose to begin a discussion about the purpose of the tables. Any thoughts please?

I do not know how to attach a file, so I posted it in filehosting

[Admin: I've deleted that URL - my virus detection objected ]

[mrogers]

Alfresco does not publish database schema information since the implementation is considered to be private to the implementation of Alfresco.     

Also the implementation details change frequently so as and when you upgrade your applications will break.

What you should be doing is accessing Alfresco via one of the many public APIs.

[viron82]

Ok. Could you tell me links that describe the API or links that will help me understand how to use API for working with database Alfresco. I need to create a table and work with it. Where do I start using the database?

[mrogers]

It may help if you say what you are trying to achieve before worrying about implementation.

[viron82]

I want to implement functionality digital signature. I think the store digital signature and a link to the signed document (file) in the database. And by clicking on the "verify a digital signature for the current document (file) to receive from a database appropriate scientific digital signature.

[mrogers]

The "normal" place to store information relating to documents is as properties of the node.   You should probably be storing the signature in a property of a node.     How its persisted is up to alfresco.

[viron82]

Yes in the properties I will specify that the file (document) has a digital signature, but it is a digital signature (to be more precise information about the digital signature, digital signature, ie, content) is stored separately, I think to put it into the database. So what I need to store information about how many people signed the document at what time and from which IP address. I decided to keep it in a database table.