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