cancel
Showing results for 
Search instead for 
Did you mean: 

Database Schema

mehul1511
Champ in-the-making
Champ in-the-making
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..
13 REPLIES 13

mikeh
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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
Star Contributor
Star Contributor
It may help if you say what you are trying to achieve before worrying about implementation.

viron82
Champ in-the-making
Champ in-the-making
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
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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.