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

[viron82]

And where are stored property finally?

[mrogers]

So have another content node containing the signature and create an assoc between the document and the signature.

There's no need for you to touch the DB.

[viron82]

Is it true that the properties file is stored in the database?
Whether correct to store a digital signature signed file directly to the property of the current file? Is there a limit on the size of the contents of the field properties?
And a few more questions: do I need to pass a digital signature from the client (for that would not transfer the private key on the network) which API I can use to work with properties. How do I write the value of a property from a client? Please answer.

[mrogers]

->Is it true that the properties file is stored in the database?
Yes
->Whether correct to store a digital signature signed file directly to the property of the current file?
Depends upon your requirements.
-> Is there a limit on the size of the contents of the field properties?
Depends upon the type of your property and the DB.   MySql is 64K for a string.
->And a few more questions: do I need to pass a digital signature from the client (for that would not transfer the private key on the network) which API I can use to work with properties. 
Depends upon the architecture of your solution.   I would not reccomend transfer of a PK.  
->How do I write the value of a property from a client? Please answer.
Depends on where you are accessing alfresco from.   The primary ways are the Java or JavaScript APIs for local access or web scripts for remote access.   For example if there is a "sign" action within alfresco then use the NodeService.