[Cosmo-dev] cosmo data model schema

[Vinubalaji Gopal]

On Fri, 2006-10-06 at 15:51 +0200, Daniel Gradecak wrote:
> Hello,
> 
> as we are looking for the possibility to develop a cosmo DAO layer using 
> Alfresco CMS I would like to know if I could get a model schema of the 
> cosmo actual database schema (jpeg or whatever ...).
> This would help me in doing the model in alfresco. So, please provide me 
> informations where to find that or if you could send it to me directly.


JCR follows a hierarchical model and thus I don't think it would be of
much use to have a model view of the new relational data model in
Cosmo. 


You should be looking at 
http://wiki.osafoundation.org/bin/view/Projects/CosmoJackrabbit
and browse the previous versions of Cosmo which was based on JCR. 

If I am wrong and Alfresco can use something other than JCR then yes as
randy pointed out the data model diagram can be found at that link and
can be understood by following the mapping files at
COSMO_SOURCE/src/main/resources/org/osaf/cosmo/model/*.hbm.xml. A
slightly less complete and an ASCII view of the model can be found at 
http://wiki.osafoundation.org/bin/view/Journal/CosmoHibernate


You can even dump the entire database and have a view of the table
structures:
http://wiki.osafoundation.org/bin/view/Projects/CosmoDerby 
(there is a section on Hibernate)
 

--
Vinu