r2 - 03 Oct 2006 - 13:47:18 - VinubalajiGopalYou are here: OSAF >  Journal Web  > CosmoHibernate

All the mapping can be found in COSMO_SOURCE/src/main/resources/org/osaf/cosmo/model/*.hbm.xml. This ASCII diagram represents a part of the schema obtained by either following the mapping or creating a dump of the database.



 ______________
| User         |    
|______________|
| id           |       
| username     |
| password     |
| firstname    |    <--------
| lastname     |             |
| email        |             |
| admin        |             |
| dateCreated  |             |
| dateModified |             | 
|______________|             |
                             |
     ^                       |     
     |                       |
     
 ______________        ______________ 
| item         |      |   tickets    |
|______________|      |______________|  
| id           |      |    id        |
| itemtype     | <--> |  ticketkey   |
| parentid     |      | tickettimeout|
| uid          |      | creationdate |                      
| itemname     |      |______________|
| dateCreated  |       _______________
| dateModified |      |   attribute   |  
| ownerId      | <--> |_______________|
|              |      |     id        | 
|______________|      | attributename |   
    |     |           | attributetype |
    |     |           |  binvalue     |
    --->---           | stringvalue   |
                      | datevalue     |
                      | intvalue      |
                      |_______________|


-- VinubalajiGopal - 26 Sep 2006

Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r2 < r1 | More topic actions
 
Open Source Applications Foundation
Except where otherwise noted, this site and its content are licensed by OSAF under an Creative Commons License, Attribution Only 3.0.
See list of page contributors for attributions.