Schema Analysis of Jama Contour
Contour Data SchemaThis document outlines the data type conventions and tables in the Contour database schema.Some information like column indexes and foreign keys are omitted.Data types may differ slightly depending on which database is being used. Tips1.1 Boolean ValuesBoolean Values are always represented by a T for true and F for false. 1.2 RefID & Scope ColumnsYou will notice that several columns include a RefId and Scope column. For certain tables the records can be configured to correspond to the project, organization or system. The scope field may have the following values:
When writing queries, keep the scope in mind as this will indicate which table to join the ID to obtain the information.For example,if a lookup type has a scope of 2 that means the lookup is used across the entire organization. If the lookup type has a scope of 3 it's unique to each project. 1.3 Naming ConventionsTables with an underscore such as are link tables that join data together. |
Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Jan 18 17:22 PST 2012 | |
| Database Type: MySQL - 5.1.58-community |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
112 Tables:
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| aclobject | 1 | 9 | 0 | ||
| aclpermission | 3 | 10 | 0 | Security permissions | |
| aclpermissionentry | 12 | 7 | |||
| attachment | 4 | 2 | 13 | 33 | File attachment information |
| baseline | 4 | 1 | 12 | 1 | Baselines |
| baseline_version | 2 | 2 | 16 | List of artifacts included in each baseline | |
| c3p0_connection_test_table | 1 | 0 | |||
| changerequestassociation | 4 | 11 | 3 | ||
| commentstatus | 1 | 3 | 3 | ||
| commenttype | 1 | 3 | 6 | ||
| dashboard | 1 | 1 | 9 | 5 | |
| dashboardlayout | 1 | 5 | 5 | ||
| distributiongroup | 1 | 2 | 9 | 0 | Email distribution groups for outbound email notification |
| distributiongroup_user | 2 | 2 | 0 | Users associated with distribution groups | |
| document | 24 | 28 | 95 | 182 | Artifacts such as requirements, use cases etc |
| document_attachment | 2 | 10 | 0 | File attachments | |
| document_docattach | 2 | 9 | 0 | ||
| document_document | 6 | 14 | 61 | Relationships between artifacts | |
| document_tag | 2 | 8 | 26 | Tags | |
| document_url | 1 | 9 | 0 | ||
| documentcustomfieldvalue | 1 | 9 | 0 | ||
| documentfield | 2 | 20 | 90 | Configuration table that | |
| documentgroup | 3 | 2 | 18 | 38 | Primary groups table |
| documentkeylookup | 2 | 7 | 22 | ||
| documentnode | 1 | 2 | 11 | 265 | |
| documenttype | 8 | 1 | 21 | 26 | Indicates the type of artifact such as a requirement |
| documenttypecategory | 1 | 3 | 10 | ||
| documenttypefielddefinition | 1 | 2 | 25 | 102 | Configuration of the fields for each artifact |
| 1 | 15 | 0 | |||
| estimate | 1 | 9 | 0 | NO LONGER USED | |
| eventactiontype | 8 | 54 | |||
| evententry | 6 | 19 | 475 | Event log - populates What's New | |
| eventtype | 10 | 10 | |||
| fieldlayout | 1 | 3 | 11 | 59 | |
| fieldlayoutentry | 2 | 10 | 275 | ||
| fieldlayouttype | 1 | 9 | 3 | ||
| filter | 2 | 14 | 9 | Filters | |
| glossaryitem | 1 | 9 | 0 | NO LONGER USED | |
| integrationcomponentmapping | 1 | 4 | 20 | 0 | |
| integrationconnection | 2 | 17 | 0 | ||
| integrationdirectiontype | 2 | 7 | 4 | ||
| integrationfieldmapping | 4 | 14 | 0 | ||
| integrationtype | 3 | 7 | 1 | ||
| itemsyncstatus | 1 | 8 | 4 | ||
| itemtemplate | 13 | 5 | |||
| jamaauthprovider | 17 | 0 | |||
| jamacomment | 1 | 4 | 23 | 1 | Comments |
| jamacomment_userlikes | 2 | 2 | 0 | ||
| jamatoken | 1 | 9 | 0 | ||
| jamaview | 5 | 2 | 16 | 34 | |
| jobschedule | 1 | 14 | 6 | ||
| lookup | 22 | 1 | 15 | 33 | |
| lookuptype | 1 | 14 | 22 | ||
| mutedsubscription | 2 | 8 | 0 | ||
| objecttype | 10 | 17 | |||
| organization | 6 | 13 | 1 | Organization - typically the company information | |
| perspective | 4 | 2 | 19 | 2 | |
| perspective_role | 2 | 9 | 1 | ||
| perspective_view | 2 | 10 | 27 | ||
| perspectiveconfig | 2 | 12 | 1 | ||
| perspectivetype | 1 | 7 | 3 | ||
| pluginentry | 14 | 0 | |||
| portlet | 1 | 7 | 8 | ||
| portletinstance | 1 | 2 | 5 | 15 | |
| portletinstanceproperties | 1 | 3 | 17 | ||
| project | 11 | 11 | 33 | 5 | Project attributes |
| projectfield | 1 | 12 | 28 | ||
| projectrelease | 3 | 1 | 14 | 8 | Releases per project |
| projecttype | 2 | 14 | 1 | ||
| projecttypefield | 2 | 23 | 10 | ||
| propertyentry | 11 | 35 | Table that stored system properties used by Contour | ||
| relationshiptype | 1 | 16 | 4 | ||
| releasetype | 1 | 12 | 5 | Drop down list values specific to reases | |
| report | 3 | 3 | 20 | 15 | Reports |
| report_criterion | 1 | 2 | 0 | Criteria for each report | |
| report_reportformat | 2 | 2 | 35 | ||
| reportcriteria | 1 | 10 | 16 | ||
| reportformat | 1 | 10 | 5 | ||
| reporttype | 1 | 7 | 4 | ||
| review | 2 | 1 | 11 | 0 | |
| review_author | 2 | 2 | 0 | ||
| revision | 3 | 3 | 19 | 0 | |
| revision_item | 1 | 2 | 8 | 0 | |
| revision_user | 1 | 2 | 15 | 0 | |
| revision_user_item | 3 | 10 | 0 | ||
| revisionpropertyentry | 1 | 10 | 0 | ||
| revisionstatus | 1 | 3 | 5 | ||
| revisionuseritemstatus | 1 | 3 | 4 | ||
| role | 4 | 10 | 8 | Roles or user groups defined by administrators | |
| signature | 2 | 14 | 1 | ||
| smartfilter | 14 | 10 | |||
| stepitem | 3 | 10 | 68 | ||
| subscription | 1 | 3 | 13 | 0 | |
| tag | 1 | 9 | 4 | Tags | |
| testcasestatus | 1 | 4 | 5 | ||
| testresult | 2 | 11 | 4 | Test results | |
| testrunset | 1 | 2 | 8 | 2 | |
| testrunstatus | 2 | 4 | 5 | ||
| testset | 1 | 2 | 6 | 2 | |
| testsetcase | 2 | 5 | 5 | ||
| tokenattributes | 1 | 3 | 0 | ||
| user_job | 2 | 9 | 3 | ||
| user_organization | 2 | 8 | 0 | ||
| user_role | 2 | 2 | 2 | User assignments to roles by project | |
| userbase | 28 | 2 | 28 | 3 | Users |
| userfavorite | 1 | 9 | 4 | ||
| useritemviewhistory | 1 | 11 | 11 | ||
| userlogentry | 1 | 10 | 17 | ||
| version | 4 | 2 | 11 | 286 | Master versioning table that associates an item with its versions |
| view_itemtype | 1 | 12 | 2 | ||
| viewconfig | 2 | 12 | 6 | ||
| viewtype | 1 | 7 | 11 |
Columns: 1,284 Rows: 2,627