Schema Analysis of Jama Contour - Columns

Contour Data Schema

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

Tips

1.1 Boolean Values

Boolean Values are always represented by a T for true and F for false.

1.2 RefID & Scope Columns

You 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:

  1. System
  2. Organization Level
  3. Project
  4. Document Group (Not currently used)
  5. Item (Not currently used)
  6. User (Not currently used)

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 Conventions

Tables 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
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

contour contains 1284 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
aclobject createdBy int 10  √  null
aclobject createdDate datetime 19  √  null
aclobject id int 10  √ 
aclpermission.aclObjectId FKAF999D96BDCCF66
aclobject modifiedBy int 10  √  null
aclobject modifiedDate datetime 19  √  null
aclobject objectIdentity varchar 100  √  null
aclobject organizationId int 10  √  null
aclobject parentAclObjectId int 10  √  null
aclobject subObject longtext 2147483647  √  null
aclpermission aclObjectId int 10  √  null
aclobject.id FKAF999D96BDCCF66
aclpermission createdBy int 10  √  null
aclpermission createdDate datetime 19  √  null
aclpermission id int 10  √ 
aclpermission mask int 10
aclpermission modifiedBy int 10  √  null
aclpermission modifiedDate datetime 19  √  null
aclpermission organizationId int 10  √  null
aclpermission roleId int 10  √  null
role.id FKAF999D91403590E
aclpermission userId int 10  √  null
userbase.id FKAF999D91958AE78
aclpermissionentry createdBy int 10  √  null
aclpermissionentry createdDate datetime 19  √  null
aclpermissionentry id int 10  √ 
aclpermissionentry mask bigint 19  √  null
aclpermissionentry modifiedBy int 10  √  null
aclpermissionentry modifiedDate datetime 19  √  null
aclpermissionentry objectId int 10  √  null
aclpermissionentry objectType int 10  √  null
aclpermissionentry organizationId int 10  √  null
aclpermissionentry permissionType int 10  √  null
aclpermissionentry sid int 10  √  null
aclpermissionentry sidType int 10  √  null
attachment attachmentTypeId int 10  √  null
attachment createdBy int 10  √  null
attachment createdDate datetime 19  √  null
attachment description longtext 2147483647  √  null
attachment fileName varchar 255  √  null
attachment fileSize int 10  √  null
attachment id int 10  √ 
document_attachment.attachmentId FKFEB8AEC756B0D1E8
report.attachmentId FKC84C553456B0D1E8
report.previewAttachmentId FKC84C55347CDA49B0
userbase.avatarId FK_USER_AVATAR
attachment mimeType longtext 2147483647  √  null
attachment modifiedBy int 10  √  null
attachment modifiedDate datetime 19  √  null
attachment organizationId int 10  √  null
organization.id FK8AF75923B2808048
attachment projectId int 10  √  null
project.id FK8AF7592362A5139B
attachment system char 1  √  null
baseline active char 1  √  null
baseline createdBy int 10  √  null
baseline createdDate datetime 19  √  null
baseline description longtext 2147483647  √  null
baseline id int 10  √ 
baseline_version.baselineId FK5F1F94DE674BC58C
documentnode.baseLineId FK_DOCUMENTNODE_BASELINE
revision.baselineId FKF074B7DB674BC58C
signature.baseLineId FK3FFD98B8674BC58C
baseline modifiedBy int 10  √  null
baseline modifiedDate datetime 19  √  null
baseline name varchar 255  √  null
baseline organizationId int 10  √  null
baseline projectId int 10
project.id FK996EE64562A5139B
baseline refId int 10  √  null
baseline scopeId int 10  √  null
baseline_version baselineId int 10
baseline.id FK5F1F94DE674BC58C
baseline_version versionId int 10
version.id FK5F1F94DE4C133EE4
c3p0_connection_test_table a char 1  √  null
changerequestassociation associatedItemId int 10
document.id FK8C59242EC05EE9A
changerequestassociation changeRequestComment longtext 2147483647  √  null
changerequestassociation changeRequestItemId int 10
document.id FK8C59242A9096BB3
changerequestassociation createdBy int 10  √  null
changerequestassociation createdDate datetime 19  √  null
changerequestassociation id int 10  √ 
changerequestassociation modifiedBy int 10  √  null
changerequestassociation modifiedDate datetime 19  √  null
changerequestassociation organizationId int 10  √  null
changerequestassociation versionEndId int 10  √  null
version.id FK8C592429A27E04F
changerequestassociation versionStartId int 10  √  null
version.id FK8C59242D32E6C16
commentstatus id int 10  √ 
jamacomment.status FKECA112F440920E7C
commentstatus name varchar 255  √  null
commentstatus organizationId int 10  √  null
commenttype id int 10  √ 
jamacomment.commenttype FKECA112F417F9EB
commenttype name varchar 255  √  null
commenttype organizationId int 10  √  null
dashboard createdBy int 10  √  null
dashboard createdDate datetime 19  √  null
dashboard id int 10  √ 
portletinstance.dashboardId FK_PORTLETINSTANCE_DASHBOARD
dashboard layoutId int 10
dashboardlayout.id FK_DASHBOARD_LAYOUT
dashboard modifiedBy int 10  √  null
dashboard modifiedDate datetime 19  √  null
dashboard organizationId int 10  √  null
dashboard refId int 10  √  null
dashboard scopeId int 10  √  null
dashboardlayout description varchar 255  √  null
dashboardlayout id int 10  √ 
dashboard.layoutId FK_DASHBOARD_LAYOUT
dashboardlayout image varchar 255  √  null
dashboardlayout layoutXtype varchar 255
dashboardlayout organizationId int 10  √  null
distributiongroup createdBy int 10  √  null User ID
distributiongroup createdDate datetime 19  √  null
distributiongroup description longtext 2147483647  √  null Text description
distributiongroup id int 10  √ 
distributiongroup_user.distributionGroupId FKC89CDF0F573B620A
System generated unique ID
distributiongroup modifiedBy int 10  √  null User ID
distributiongroup modifiedDate datetime 19  √  null
distributiongroup name varchar 255  √  null Label for the distribution group
distributiongroup organizationId int 10  √  null
organization.id FK3C591A7BB2808048
Associated organization ID
distributiongroup projectId int 10
project.id FK3C591A7B62A5139B
Associated project ID
distributiongroup_user distributionGroupId int 10
distributiongroup.id FKC89CDF0F573B620A
distributiongroup_user userId int 10
userbase.id FKC89CDF0F1958AE78
document active char 1  √  null Indicator if the item is currently active. This is an important field and most queries will include an active = 'Y' clause. Deleted items are set to inactive as well as old versions.
document actualResults longtext 2147483647  √  null
document archived char 1  √  null
document assignedToId int 10  √  null
userbase.id FK_TESTRUN_USER
Associated User ID
document attachment int 10  √  null
document childDocumentTypeId int 10  √  null
documenttype.id FK335CD11B9E94C348
document createdBy int 10  √  null
document createdDate datetime 19  √  null
document date1 datetime 19  √  null
document date2 datetime 19  √  null
document date3 datetime 19  √  null
document date4 datetime 19  √  null
document date5 datetime 19  √  null
document description longtext 2147483647  √  null
document detail longtext 2147483647  √  null
document documentGroup int 10  √  null
documentgroup.id FK335CD11B884663C1
Related group ID
document documentKey varchar 255  √  null Configurable unique identifier that includes a prefix and numerical suffix. REQ-101 for example.
document documentTypeId int 10  √  null
documenttype.id FK335CD11BE181EF2C
document duration int 10  √  null
document entitytype varchar 31  √  Document
document flag1 char 1  √  null User defined field - Boolean
document flag2 char 1  √  null User defined field - Boolean
document flag3 char 1  √  null User defined field - Boolean
document flag4 char 1  √  null User defined field - Boolean
document flag5 char 1  √  null User defined field - Boolean
document globalSortOrder int 10  √  null
document hibVersion int 10  √  null
document id int 10  √ 
changerequestassociation.associatedItemId FK8C59242EC05EE9A
changerequestassociation.changeRequestItemId FK8C59242A9096BB3
document.testCaseId FK_TESTRUN_TESTCASE
document.testPlanId FK_TESTCYCLE_TESTPLAN
document_attachment.documentId FKFEB8AEC7DA506A1C
document_docattach.docattachId FKD8310F5993BB117A
document_docattach.documentId FKD8310F59DA506A1C
document_document.fromDocument FKC5FF3FBFA9DB056B
document_document.toDocument FKC5FF3FBF39339B3C
document_tag.document FKA835BA763E4037C1
document_url.documentId FKA835C04BDA506A1C
documentcustomfieldvalue.documentId FKE13A6A03DA506A1C
evententry.document FK3AFE26183E4037C1
integrationcomponentmapping.documentId FKBCFD2305D766C998
integrationcomponentmapping.targetDocumentId FKBCFD230525D539E9
jamacomment.documentId FKECA112F4DA506A1C
stepitem.testCaseId FK_TESTCASESTEP_TESTCASE
stepitem.testRunId FK_TESTRUNSTEP_TESTRUN
testresult.testCaseId FK9B0ED72F8C20F203
testrunset.testCycleId FK_TESTRUNSET_TESTCYCLE
testset.testPlanId FK_TESTSET_TESTPLAN
testsetcase.testCaseId FK_TESTSETCASE_TESTCASE
version.documentId FK14F51CD8DA506A1C
version.originDocumentId FK14F51CD86915E1C2
System generated unique ID
document indent int 10  √  null Calculated value to represent the indentation level when representing data in an outline structure
document isFolder char 1  √  null Indicator that the item is a folder
document legacyKey varchar 255  √  null
document locked char 1  √  null
document lockedBy int 10  √  null
userbase.id FK335CD11BBD032133
document lockedDate datetime 19  √  null
document lookup10Id int 10  √  null
lookup.id FK335CD11B739D9835
document lookup1Id int 10  √  null
lookup.id FK335CD11B6AC02593
document lookup2Id int 10  √  null
lookup.id FK335CD11B6AC02954
document lookup3Id int 10  √  null
lookup.id FK335CD11B6AC02D15
document lookup4Id int 10  √  null
lookup.id FK335CD11B6AC030D6
document lookup5Id int 10  √  null
lookup.id FK335CD11B6AC03497
document lookup6Id int 10  √  null
lookup.id FK335CD11B6AC03858
document lookup7Id int 10  √  null
lookup.id FK335CD11B6AC03C19
document lookup8Id int 10  √  null
lookup.id FK335CD11B6AC03FDA
document lookup9Id int 10  √  null
lookup.id FK335CD11B6AC0439B
document modifiedBy int 10  √  null
document modifiedDate datetime 19  √  null
document name varchar 255  √  null
document organizationId int 10  √  null
document originalEstimate int 10  √  null Original estimate for an item - typically in hours
document parentId int 10  √  null ID of the parent item as configured in the tree view
document priorityId int 10  √  null
lookup.id FK335CD11B6080E200
Associated Priority ID
document projectId int 10
project.id FK335CD11B62A5139B
related Project ID
document release1Id int 10  √  null
projectrelease.id FK335CD11B718FC1C5
document release2Id int 10  √  null
projectrelease.id FK335CD11B718FC586
document releaseId int 10  √  null
projectrelease.id FK335CD11BD1554582
Associated release ID
document remainingEstimate int 10  √  null Units remaining - typically in hours
document sequence varchar 255  √  null
document setKey varchar 255  √  null
document sortOrder int 10  √  null Used by internal routine called prior to a report being run to sort amongst all items within a group based on the explorer view
document statusId int 10  √  null
lookup.id FK335CD11B74C9DCCE
Associated status ID
document string1 varchar 255  √  null
document string10 varchar 255  √  null
document string11 varchar 255  √  null
document string12 varchar 255  √  null
document string13 varchar 255  √  null
document string14 varchar 255  √  null
document string15 varchar 255  √  null
document string2 varchar 255  √  null
document string3 varchar 255  √  null
document string4 varchar 255  √  null
document string5 varchar 255  √  null
document string6 varchar 255  √  null
document string7 varchar 255  √  null
document string8 varchar 255  √  null
document string9 varchar 255  √  null
document testCaseId int 10  √  null
document.id FK_TESTRUN_TESTCASE
document testCaseStatusId int 10  √  null
testcasestatus.id FK_TESTCASE_TCSTATUS
document testCaseVersionNumber varchar 255  √  null
document testPlanId int 10  √  null
document.id FK_TESTCYCLE_TESTPLAN
document testRunSetId int 10  √  null
testrunset.id FK_TESTRUN_TESTRUNSET
document testRunStatusId int 10  √  null
testrunstatus.id FK_TESTRUN_TESTRUNSTATUS
document text1 longtext 2147483647  √  null
document text10 longtext 2147483647  √  null
document text2 longtext 2147483647  √  null
document text3 longtext 2147483647  √  null
document text4 longtext 2147483647  √  null
document text5 longtext 2147483647  √  null
document text6 longtext 2147483647  √  null
document text7 longtext 2147483647  √  null
document text8 longtext 2147483647  √  null
document text9 longtext 2147483647  √  null
document timeSpent int 10  √  null Actual time spent - typically in hours
document user1Id int 10  √  null
userbase.id FK335CD11B4267BDB3
document user2Id int 10  √  null
userbase.id FK335CD11B4267C174
document xprojectLinkId int 10  √  null Reference to a linked item from another project.
document_attachment attachmentId int 10  √  null
attachment.id FKFEB8AEC756B0D1E8
attachment ID
document_attachment createdBy int 10  √  null
document_attachment createdDate datetime 19  √  null
document_attachment documentId int 10  √  null
document.id FKFEB8AEC7DA506A1C
document ID
document_attachment id int 10  √  System generated unique ID
document_attachment modifiedBy int 10  √  null
document_attachment modifiedDate datetime 19  √  null
document_attachment note longtext 2147483647  √  null User entered text to describe the attachment
document_attachment organizationId int 10  √  null
document_attachment url longtext 2147483647  √  null URL to the item
document_docattach createdBy int 10  √  null
document_docattach createdDate datetime 19  √  null
document_docattach docattachId int 10  √  null
document.id FKD8310F5993BB117A
document_docattach documentId int 10  √  null
document.id FKD8310F59DA506A1C
document_docattach id int 10  √ 
document_docattach modifiedBy int 10  √  null
document_docattach modifiedDate datetime 19  √  null
document_docattach note longtext 2147483647  √  null
document_docattach organizationId int 10  √  null
document_document associationType int 10  √  null
lookup.id FKC5FF3FBFA07B777C
lookup ID
document_document createdBy int 10  √  null
document_document createdDate datetime 19  √  null
document_document description longtext 2147483647  √  null
document_document fromDocument int 10  √  null
document.id FKC5FF3FBFA9DB056B
ID of the item the link is coming from.
document_document id int 10  √  System generated unique ID
document_document itemSyncStatus int 10  √  null
itemsyncstatus.id FK_DOCDOC_ITEMSYNCSTATUS
document_document modifiedBy int 10  √  null
document_document modifiedDate datetime 19  √  null
document_document organizationId int 10  √  null
document_document relationshipType int 10  √  null
relationshiptype.id FKC5FF3FBF45B2C50B
document_document status int 10  √  null
lookup.id FKC5FF3FBFF0FE0433
document_document suspect char 1  √  null Suspect link flag
document_document toDocument int 10  √  null
document.id FKC5FF3FBF39339B3C
ID of the item the link is pointing to
document_tag createdBy int 10  √  null
document_tag createdDate datetime 19  √  null
document_tag document int 10  √  null
document.id FKA835BA763E4037C1
item ID
document_tag id int 10  √  System generated unique ID
document_tag modifiedBy int 10  √  null
document_tag modifiedDate datetime 19  √  null
document_tag organizationId int 10  √  null
document_tag tag int 10  √  null
tag.id FKA835BA76868B9321
tag ID
document_url createdBy int 10  √  null
document_url createdDate datetime 19  √  null
document_url description longtext 2147483647  √  null
document_url documentId int 10  √  null
document.id FKA835C04BDA506A1C
document_url id int 10  √ 
document_url modifiedBy int 10  √  null
document_url modifiedDate datetime 19  √  null
document_url organizationId int 10  √  null
document_url url longtext 2147483647  √  null
documentcustomfieldvalue createdBy int 10  √  null
documentcustomfieldvalue createdDate datetime 19  √  null
documentcustomfieldvalue documentId int 10  √  null
document.id FKE13A6A03DA506A1C
documentcustomfieldvalue fieldId int 10  √  null
documentcustomfieldvalue id int 10  √ 
documentcustomfieldvalue modifiedBy int 10  √  null
documentcustomfieldvalue modifiedDate datetime 19  √  null
documentcustomfieldvalue organizationId int 10  √  null
documentcustomfieldvalue textValue longtext 2147483647  √  null
documentfield category int 10  √  null
documentfield createdBy int 10  √  null User ID
documentfield createdDate datetime 19  √  null
documentfield customField char 1  √  null
documentfield dataTypeId int 10  √  null Field data type lookup
documentfield description longtext 2147483647  √  null Label
documentfield editxtype varchar 255  √  null
documentfield fieldType int 10  √  null
documentfield formxtype varchar 255  √  null
documentfield gridxtype varchar 255  √  null
documentfield id int 10  √ 
documenttypefielddefinition.documentFieldId FK9F2566584D729212
integrationfieldmapping.fieldId FK7FB5A268F5ECC78D
System generated unique ID
documentfield isDerived char 1  √  null
documentfield modifiedBy int 10  √  null
documentfield modifiedDate datetime 19  √  null User ID
documentfield name varchar 255  √  null Internal name of field
documentfield organizationId int 10  √  null
documentfield readOnly char 1  √  null
documentfield refId int 10  √  null
documentfield scope int 10  √  null 1 = Organization
documentfield userConfigurable char 1  √  null
documentgroup active char 1  √  null Active flag
documentgroup createdBy int 10  √  null User ID
documentgroup createdDate datetime 19  √  null
documentgroup description longtext 2147483647  √  null User entered description of group
documentgroup display varchar 255  √  null Singular label to display
documentgroup displayInReleaseTree char 1  √  null Flag that determines if the items should be included in the default display of the milestones tree
documentgroup displayPlural varchar 255  √  null Plural label to display
documentgroup documentTypeId int 10  √  null
documenttype.id FK5EF19E44E181EF2C
documentgroup id int 10  √ 
document.documentGroup FK335CD11B884663C1
evententry.documentGroup FK3AFE2618884663C1
filter.documentGroup FKB408CB78884663C1
System generated unique ID
documentgroup image varchar 255  √  null Path to icon
documentgroup keySeperator varchar 255  √  null
documentgroup modifiedBy int 10  √  null User ID
documentgroup modifiedDate datetime 19  √  null
documentgroup organizationId int 10  √  null
documentgroup prefix varchar 255  √  null Prefix for item Key such as 'REQ'
documentgroup projectId int 10  √  null
project.id FK5EF19E4462A5139B
documentgroup sequenceNumber int 10  √  null Numerical value to start with when generating unique item keys
documentgroup sortOrder int 10  √  null Order relative to peers
documentkeylookup documentTypeId int 10  √  null
documenttype.id FK_dockeylookup_doctype
documentkeylookup id int 10  √ 
documentkeylookup organizationId int 10  √  null
documentkeylookup projectId int 10  √  null
project.id FK_dockeylookup_project
documentkeylookup projectKey varchar 255  √  null
documentkeylookup sequence int 10  √  null
documentkeylookup setKey varchar 255  √  null
documentnode active char 1  √  null
documentnode baseLineId int 10  √  null
baseline.id FK_DOCUMENTNODE_BASELINE
documentnode globalSortOrder int 10
documentnode id int 10  √ 
documentnode.parentNodeId FK_DOCUMENTNODE_PARENT
documentnode isPermissionNode char 1
documentnode organizationId int 10  √  null
documentnode parentNodeId int 10  √  null
documentnode.id FK_DOCUMENTNODE_PARENT
documentnode refId int 10
documentnode scopeId int 10
documentnode sequence varchar 255
documentnode sortOrder int 10
documenttype active char 1  √  null
documenttype category int 10  √  null
documenttype components longtext 2147483647  √  null
documenttype createdBy int 10  √  null
documenttype createdDate datetime 19  √  null
documenttype defaultDisplay varchar 255  √  null
documenttype defaultDisplayPlural varchar 255  √  null
documenttype defaultPrefix varchar 255  √  null
documenttype description longtext 2147483647  √  null
documenttype display varchar 255  √  null
documenttype displayPlural varchar 255  √  null
documenttype documentTypeCategoryId int 10  √  null
documenttypecategory.id FKA83F5AD5672FE4C8
documenttype documentTypeKey varchar 255  √  null
documenttype id int 10  √ 
document.childDocumentTypeId FK335CD11B9E94C348
document.documentTypeId FK335CD11BE181EF2C
documentgroup.documentTypeId FK5EF19E44E181EF2C
documentkeylookup.documentTypeId FK_dockeylookup_doctype
documenttypefielddefinition.documentTypeId FK9F256658E181EF2C
evententry.documentType FK3AFE2618F3ED4351
fieldlayout.documentTypeId FK3F0778A4E181EF2C
filter.documentType FKB408CB78F3ED4351
documenttype image varchar 255  √  null
documenttype modifiedBy int 10  √  null
documenttype modifiedDate datetime 19  √  null
documenttype name varchar 255  √  null
documenttype organizationId int 10  √  null
documenttype refId int 10  √  null
documenttype scope int 10  √  null
documenttypecategory id int 10  √ 
documenttype.documentTypeCategoryId FKA83F5AD5672FE4C8
documenttypecategory name varchar 255  √  null
documenttypecategory organizationId int 10  √  null
documenttypefielddefinition controlStyle longtext 2147483647  √  null
documenttypefielddefinition controlTypeId int 10  √  null
documenttypefielddefinition createdBy int 10  √  null
documenttypefielddefinition createdDate datetime 19  √  null
documenttypefielddefinition description longtext 2147483647  √  null
documenttypefielddefinition documentFieldId int 10
documentfield.id FK9F2566584D729212
documenttypefielddefinition documentTypeId int 10  √  null
documenttype.id FK9F256658E181EF2C
documenttypefielddefinition groupName varchar 255  √  null
documenttypefielddefinition id int 10  √ 
fieldlayoutentry.documentTypeFieldId FKF081564E7C13C8FE
documenttypefielddefinition isSynchronizeField char 1  √  null
documenttypefielddefinition label varchar 255  √  null
documenttypefielddefinition lookupTypeId int 10  √  null
documenttypefielddefinition modifiedBy int 10  √  null
documenttypefielddefinition modifiedDate datetime 19  √  null
documenttypefielddefinition name varchar 255  √  null
documenttypefielddefinition organizationId int 10  √  null
documenttypefielddefinition readOnly char 1  √  null
documenttypefielddefinition required char 1  √  null
documenttypefielddefinition script longtext 2147483647  √  null
documenttypefielddefinition showInFolder char 1  √  null
documenttypefielddefinition showInList char 1  √  null
documenttypefielddefinition sortOrder int 10  √  null
documenttypefielddefinition sortOrderInList int 10  √  null
documenttypefielddefinition triggerSuspect char 1  √  null
documenttypefielddefinition validation longtext 2147483647  √  null
email attempts int 10  √  null
email createdBy int 10  √  null
email createdDate datetime 19  √  null
email emailBody longtext 2147483647  √  null
email fromAddress varchar 255  √  null
email fromName varchar 511  √  null
email id int 10  √ 
email modifiedBy int 10  √  null
email modifiedDate datetime 19  √  null
email organizationId int 10  √  null
email replyToAddress varchar 255  √  null
email status varchar 255  √  null
email subject varchar 255  √  null
email toAddress varchar 255  √  null
email userId int 10  √  null
userbase.id FK5C24B9C1958AE78
estimate createdBy int 10  √  null
estimate createdDate datetime 19  √  null
estimate estimate int 10  √  null
estimate estimatedBy varchar 255  √  null
estimate id int 10  √ 
estimate lookupId int 10  √  null
lookup.id FK8B302528AC877456
estimate modifiedBy int 10  √  null
estimate modifiedDate datetime 19  √  null
estimate organizationId int 10  √  null
eventactiontype active char 1  √  null
eventactiontype description longtext 2147483647  √  null
eventactiontype eventTypeId int 10  √  null
eventactiontype id int 10  √ 
eventactiontype name varchar 255  √  null
eventactiontype objectTypeId int 10  √  null
eventactiontype organizationId int 10  √  null
eventactiontype sortOrder int 10  √  null
evententry action varchar 255  √  null
evententry comments longtext 2147483647  √  null
evententry createdBy int 10  √  null
evententry createdDate datetime 19  √  null
evententry document int 10  √  null
document.id FK3AFE26183E4037C1
Associated item ID
evententry documentGroup int 10  √  null
documentgroup.id FK3AFE2618884663C1
evententry documentType int 10  √  null
documenttype.id FK3AFE2618F3ED4351
evententry eventDate datetime 19  √  null
evententry EventType int 10  √  null
evententry eventUser int 10  √  null
userbase.id FK3AFE26184D1BFDB7
Associated user ID
evententry id int 10  √ 
evententry modifiedBy int 10  √  null
evententry modifiedDate datetime 19  √  null
evententry objectId int 10  √  null
evententry objectType int 10  √  null
evententry organization int 10  √  null
organization.id FK3AFE26183006F3ED
evententry parentEventEntryId int 10  √  null
evententry project int 10  √  null
project.id FK3AFE2618858B68C0
Associated Project ID
evententry userComment longtext 2147483647  √  null
eventtype active char 1  √  null
eventtype createdBy int 10  √  null
eventtype createdDate datetime 19  √  null
eventtype description longtext 2147483647  √  null
eventtype id int 10  √ 
eventtype modifiedBy int 10  √  null
eventtype modifiedDate datetime 19  √  null
eventtype name varchar 255  √  null
eventtype organizationId int 10  √  null
eventtype sortOrder int 10  √  null
fieldlayout createdBy int 10  √  null
fieldlayout createdDate datetime 19  √  null
fieldlayout documentTypeId int 10  √  null
documenttype.id FK3F0778A4E181EF2C
fieldlayout fieldLayoutTypeId int 10  √  null
fieldlayouttype.id FK_fieldlayout_type
fieldlayout id int 10  √ 
fieldlayoutentry.fieldLayoutId FKF081564EA8BE6B1C
fieldlayout modifiedBy int 10  √  null
fieldlayout modifiedDate datetime 19  √  null
fieldlayout organizationId int 10  √  null
fieldlayout refId int 10  √  null
fieldlayout scope int 10  √  null
fieldlayout viewId int 10  √  null
jamaview.id FK3F0778A41A80FDAC
fieldlayoutentry active char 1  √  null
fieldlayoutentry createdBy int 10  √  null
fieldlayoutentry createdDate datetime 19  √  null
fieldlayoutentry documentTypeFieldId int 10
documenttypefielddefinition.id FKF081564E7C13C8FE
fieldlayoutentry fieldLayoutId int 10
fieldlayout.id FKF081564EA8BE6B1C
fieldlayoutentry id int 10  √ 
fieldlayoutentry layoutPosition int 10  √  null
fieldlayoutentry modifiedBy int 10  √  null
fieldlayoutentry modifiedDate datetime 19  √  null
fieldlayoutentry organizationId int 10  √  null
fieldlayouttype code varchar 31  √  null
fieldlayouttype createdBy int 10  √  null
fieldlayouttype createdDate datetime 19  √  null
fieldlayouttype description varchar 255  √  null
fieldlayouttype id int 10  √ 
fieldlayout.fieldLayoutTypeId FK_fieldlayout_type
fieldlayouttype modifiedBy int 10  √  null
fieldlayouttype modifiedDate datetime 19  √  null
fieldlayouttype name varchar 127  √  null
fieldlayouttype organizationId int 10  √  null
filter createdBy int 10  √  null
filter createdDate datetime 19  √  null
filter description longtext 2147483647  √  null
filter documentGroup int 10  √  null
documentgroup.id FKB408CB78884663C1
filter documentType int 10  √  null
documenttype.id FKB408CB78F3ED4351
filter id int 10  √ 
filter isHidden char 1  √  null
filter modifiedBy int 10  √  null
filter modifiedDate datetime 19  √  null
filter name varchar 255  √  null
filter organizationId int 10  √  null
filter refId int 10  √  null
filter scope int 10  √  null
filter xmlString longtext 2147483647  √  null
glossaryitem createdBy int 10  √  null
glossaryitem createdDate datetime 19  √  null
glossaryitem definition longtext 2147483647  √  null
glossaryitem id int 10  √ 
glossaryitem modifiedBy int 10  √  null
glossaryitem modifiedDate datetime 19  √  null
glossaryitem organizationId int 10  √  null
glossaryitem projectId int 10
project.id FKEE51863162A5139B
glossaryitem term varchar 255  √  null
integrationcomponentmapping active char 1
integrationcomponentmapping commentsDirectionTypeId int 10  √  null
integrationdirectiontype.id FKBCFD23059A05EA8C
integrationcomponentmapping createdBy int 10  √  null
integrationcomponentmapping createdDate datetime 19  √  null
integrationcomponentmapping documentId int 10  √  null
document.id FKBCFD2305D766C998
integrationcomponentmapping id int 10  √ 
integrationfieldmapping.setMappingId FK7FB5A268BF0C02E5
integrationcomponentmapping integrationTrigger varchar 255  √  null
integrationcomponentmapping integrationTypeId int 10
integrationtype.id FKBCFD23057EF490F0
integrationcomponentmapping mappedId varchar 255  √  null
integrationcomponentmapping mappedName varchar 255  √  null
integrationcomponentmapping modifiedBy int 10  √  null
integrationcomponentmapping modifiedDate datetime 19  √  null
integrationcomponentmapping organizationId int 10  √  null
integrationcomponentmapping projectId int 10  √  null
integrationcomponentmapping pullIntoContourFilter int 10  √  null
integrationcomponentmapping pullIntoContourFlag char 1  √  null
integrationcomponentmapping pushFromContourFlag char 1  √  null
integrationcomponentmapping refId int 10
integrationcomponentmapping scope int 10
integrationcomponentmapping targetDocumentId int 10  √  null
document.id FKBCFD230525D539E9
integrationconnection active char 1
integrationconnection createdBy int 10  √  null
integrationconnection createdDate datetime 19  √  null
integrationconnection cronString varchar 255  √  null
integrationconnection defaultContourUserId int 10  √  null
userbase.id FKB2C6BBB2845B1931
integrationconnection id int 10  √ 
integrationconnection integrationTypeId int 10
integrationtype.id FKB2C6BBB27EF490F0
integrationconnection intervalMinutes int 10  √  null
integrationconnection modifiedBy int 10  √  null
integrationconnection modifiedDate datetime 19  √  null
integrationconnection organizationId int 10  √  null
integrationconnection password varchar 255  √  null
integrationconnection refId int 10
integrationconnection scope int 10
integrationconnection url varchar 255  √  null
integrationconnection useAdvancedScheduling char 1  √  null
integrationconnection userName varchar 255  √  null
integrationdirectiontype createdBy int 10  √  null
integrationdirectiontype createdDate datetime 19  √  null
integrationdirectiontype id int 10  √ 
integrationcomponentmapping.commentsDirectionTypeId FKBCFD23059A05EA8C
integrationfieldmapping.updateDirectionTypeId FK7FB5A268917BEB17
integrationdirectiontype modifiedBy int 10  √  null
integrationdirectiontype modifiedDate datetime 19  √  null
integrationdirectiontype name varchar 255
integrationdirectiontype organizationId int 10  √  null
integrationfieldmapping active char 1
integrationfieldmapping createdBy int 10  √  null
integrationfieldmapping createdDate datetime 19  √  null
integrationfieldmapping fieldId int 10
documentfield.id FK7FB5A268F5ECC78D
integrationfieldmapping id int 10  √ 
integrationfieldmapping integrationTypeId int 10
integrationtype.id FK7FB5A2687EF490F0
integrationfieldmapping mappedId varchar 255  √  null
integrationfieldmapping mappedName varchar 255  √  null
integrationfieldmapping modifiedBy int 10  √  null
integrationfieldmapping modifiedDate datetime 19  √  null
integrationfieldmapping organizationId int 10  √  null
integrationfieldmapping setMappingId int 10
integrationcomponentmapping.id FK7FB5A268BF0C02E5
integrationfieldmapping updateDirectionTypeId int 10  √  null
integrationdirectiontype.id FK7FB5A268917BEB17
integrationfieldmapping useContourOnConflict char 1  √  null
integrationtype createdBy int 10  √  null
integrationtype createdDate datetime 19  √  null
integrationtype id int 10  √ 
integrationcomponentmapping.integrationTypeId FKBCFD23057EF490F0
integrationconnection.integrationTypeId FKB2C6BBB27EF490F0
integrationfieldmapping.integrationTypeId FK7FB5A2687EF490F0
integrationtype modifiedBy int 10  √  null
integrationtype modifiedDate datetime 19  √  null
integrationtype name varchar 255
integrationtype organizationId int 10  √  null
itemsyncstatus createdBy int 10  √  null
itemsyncstatus createdDate datetime 19  √  null
itemsyncstatus id int 10
document_document.itemSyncStatus FK_DOCDOC_ITEMSYNCSTATUS
itemsyncstatus modifiedBy int 10  √  null
itemsyncstatus modifiedDate datetime 19  √  null
itemsyncstatus name varchar 255  √  null
itemsyncstatus organizationId int 10  √  null
itemsyncstatus sortOrder int 10  √  null
itemtemplate active char 1  √  null
itemtemplate content longtext 2147483647  √  null
itemtemplate createdBy int 10  √  null
itemtemplate createdDate datetime 19  √  null
itemtemplate description longtext 2147483647  √  null
itemtemplate id int 10  √ 
itemtemplate isSystem char 1  √  null
itemtemplate modifiedBy int 10  √  null
itemtemplate modifiedDate datetime 19  √  null
itemtemplate name varchar 255  √  null
itemtemplate organizationId int 10  √  null
itemtemplate refId int 10  √  null
itemtemplate scopeId int 10  √  null
jamaauthprovider baseDn longtext 2147483647  √  null
jamaauthprovider bindDn longtext 2147483647  √  null
jamaauthprovider bindPassword longtext 2147483647  √  null
jamaauthprovider createdBy int 10  √  null
jamaauthprovider createdDate datetime 19  √  null
jamaauthprovider description longtext 2147483647  √  null
jamaauthprovider emailAttribute longtext 2147483647  √  null
jamaauthprovider enableJndiReferrals char 1  √  null
jamaauthprovider id int 10  √ 
jamaauthprovider modifiedBy int 10  √  null
jamaauthprovider modifiedDate datetime 19  √  null
jamaauthprovider name varchar 255  √  null
jamaauthprovider nameAttribute longtext 2147483647  √  null
jamaauthprovider organizationId int 10  √  null
jamaauthprovider type varchar 255  √  null
jamaauthprovider url longtext 2147483647  √  null
jamaauthprovider userNameAttribute longtext 2147483647  √  null
jamacomment active char 1  √  null
jamacomment commentText longtext 2147483647  √  null Comment text
jamacomment commenttype int 10  √  null
commenttype.id FKECA112F417F9EB
jamacomment createdBy int 10  √  null User ID
jamacomment createdDate datetime 19  √  null
jamacomment documentId int 10  √  null
document.id FKECA112F4DA506A1C
Associated artifact
jamacomment entryDate datetime 19  √  null Date comment was created
jamacomment highlightQuote longtext 2147483647  √  null
jamacomment hightlightField varchar 255  √  null
jamacomment hightlightRange longtext 2147483647  √  null
jamacomment id int 10  √ 
jamacomment_userlikes.commentId FK121CEB466A869C32
System generated unique Id
jamacomment important char 1  √  null
jamacomment isPrivate char 1  √  null
jamacomment modifiedBy int 10  √  null User ID
jamacomment modifiedDate datetime 19  √  null
jamacomment organizationId int 10  √  null
jamacomment parentId int 10  √  null
jamacomment refId int 10  √  null
jamacomment scopeId int 10  √  null
jamacomment status int 10  √  null
commentstatus.id FKECA112F440920E7C
jamacomment threadId int 10  √  null
jamacomment threadUpdatedDate datetime 19  √  null
jamacomment userId int 10  √  null
userbase.id FKECA112F41958AE78
User Id
jamacomment_userlikes commentId int 10
jamacomment.id FK121CEB466A869C32
jamacomment_userlikes userId int 10
userbase.id FK121CEB461958AE78
jamatoken createdBy int 10  √  null
jamatoken createdDate datetime 19  √  null
jamatoken expirationDate datetime 19  √  null
jamatoken id int 10  √ 
tokenattributes.tokenId FK_ATTRIBUTE_TOKEN
jamatoken modifiedBy int 10  √  null
jamatoken modifiedDate datetime 19  √  null
jamatoken organizationId int 10  √  null
jamatoken tokenstring varchar 255  √  null
jamatoken tokenType int 10  √  null
jamaview active char 1  √  null
jamaview createdBy int 10  √  null
jamaview createdDate datetime 19  √  null
jamaview description longtext 2147483647  √  null
jamaview id int 10  √ 
fieldlayout.viewId FK3F0778A41A80FDAC
jamaview.stereotypeId FKCE07663057893EF9
perspective_view.viewId FK4FA3BEC81A80FDAC
view_itemtype.viewId FKB04369271A80FDAC
viewconfig.viewId FKAC076E271A80FDAC
jamaview modifiedBy int 10  √  null
jamaview modifiedDate datetime 19  √  null
jamaview name varchar 255  √  null
jamaview organizationId int 10  √  null
jamaview refId int 10  √  null
jamaview scope int 10  √  null
jamaview stereotypeId int 10  √  null
jamaview.id FKCE07663057893EF9
jamaview viewConfig longtext 2147483647  √  null
jamaview viewIcon varchar 255  √  null
jamaview viewTypeId int 10
viewtype.id FKCE076630E57BF940
jamaview xtype varchar 255  √  null
jobschedule active char 1  √  null
jobschedule createdBy int 10  √  null
jobschedule createdDate datetime 19  √  null
jobschedule cronExpression varchar 255  √  null
jobschedule description longtext 2147483647  √  null
jobschedule id int 10  √ 
user_job.job FKF022D94934453ACA
jobschedule jobClass varchar 255  √  null
jobschedule jobGroup varchar 255  √  null
jobschedule jobName varchar 255  √  null
jobschedule lastExecuteTime datetime 19  √  null
jobschedule modifiedBy int 10  √  null
jobschedule modifiedDate datetime 19  √  null
jobschedule organizationId int 10  √  null
jobschedule params varchar 255  √  null
lookup active char 1  √  null
lookup color varchar 255  √  null
lookup createdBy int 10  √  null
lookup createdDate datetime 19  √  null
lookup dataValue varchar 255  √  null
lookup description longtext 2147483647  √  null User entered description
lookup id int 10  √ 
document.lookup10Id FK335CD11B739D9835
document.lookup1Id FK335CD11B6AC02593
document.lookup2Id FK335CD11B6AC02954
document.lookup3Id FK335CD11B6AC02D15
document.lookup4Id FK335CD11B6AC030D6
document.lookup5Id FK335CD11B6AC03497
document.lookup6Id FK335CD11B6AC03858
document.lookup7Id FK335CD11B6AC03C19
document.lookup8Id FK335CD11B6AC03FDA
document.lookup9Id FK335CD11B6AC0439B
document.priorityId FK335CD11B6080E200
document.statusId FK335CD11B74C9DCCE
document_document.associationType FKC5FF3FBFA07B777C
document_document.status FKC5FF3FBFF0FE0433
estimate.lookupId FK8B302528AC877456
project.lookup1Id FKED904B196AC02593
project.lookup2Id FKED904B196AC02954
project.lookup3Id FKED904B196AC02D15
project.lookup4Id FKED904B196AC030D6
project.projectGroupLookupId FKED904B19C82FC15C
project.statusId FKED904B1974C9DCCE
testresult.testConfiguration FK9B0ED72FDAF8E1E5
lookup image varchar 255  √  null Path to image
lookup isDefault char 1  √  null
lookup lookupTypeId int 10
lookuptype.id FKBE9BA97A8CB30AEA
Associated lookup list
lookup modifiedBy int 10  √  null
lookup modifiedDate datetime 19  √  null
lookup name varchar 255  √  null name of lookup
lookup organizationId int 10  √  null
lookup sortOrder int 10  √  null list order
lookuptype active char 1  √  null
lookuptype category int 10  √  null
lookuptype createdBy int 10  √  null
lookuptype createdDate datetime 19  √  null
lookuptype defaultValue int 10  √  null
lookuptype description longtext 2147483647  √  null
lookuptype id int 10  √ 
lookup.lookupTypeId FKBE9BA97A8CB30AEA
lookuptype modifiedBy int 10  √  null
lookuptype modifiedDate datetime 19  √  null
lookuptype name varchar 255  √  null
lookuptype organizationId int 10  √  null
lookuptype refId int 10  √  null
lookuptype scope int 10  √  null
lookuptype type int 10  √  null
mutedsubscription createdBy int 10  √  null
mutedsubscription createdDate datetime 19  √  null
mutedsubscription id int 10  √ 
mutedsubscription modifiedBy int 10  √  null
mutedsubscription modifiedDate datetime 19  √  null
mutedsubscription organizationId int 10  √  null
mutedsubscription subscriberId int 10
userbase.id FK_MUTEDSUB_USER
mutedsubscription subscriptionId int 10
subscription.id FK_MUTEDSUB_SUBSCRIPTION
objecttype active char 1  √  null
objecttype createdBy int 10  √  null
objecttype createdDate datetime 19  √  null
objecttype description longtext 2147483647  √  null
objecttype id int 10  √ 
objecttype modifiedBy int 10  √  null
objecttype modifiedDate datetime 19  √  null
objecttype name varchar 255  √  null
objecttype organizationId int 10  √  null
objecttype sortOrder int 10  √  null
organization baseUrl varchar 255  √  null
organization closed char 1  √  null
organization createdBy int 10  √  null
organization createdDate datetime 19  √  null
organization description longtext 2147483647  √  null
organization id int 10  √ 
attachment.organizationId FK8AF75923B2808048
distributiongroup.organizationId FK3C591A7BB2808048
evententry.organization FK3AFE26183006F3ED
project.organizationId FKED904B19B2808048
user_organization.organizationId FK3622D27B2808048
userbase.organization FKF024151C3006F3ED
organization licenseMessage int 10  √  null
organization modifiedBy int 10  √  null
organization modifiedDate datetime 19  √  null
organization name varchar 255
organization redirectUrl varchar 255  √  null
organization returnEmail varchar 255  √  null
organization subdomain varchar 255  √  null
perspective active char 1  √  null
perspective canOverride char 1  √  null
perspective createdBy int 10  √  null
perspective createdDate datetime 19  √  null
perspective description longtext 2147483647  √  null
perspective headerConfig varchar 255  √  null
perspective icon varchar 255  √  null
perspective id int 10  √ 
perspective.stereotypeId FKC653A3C1E06C7A2
perspective_role.perspectiveId FK4FA2049999AAFC2C
perspective_view.perspectiveId FK4FA3BEC899AAFC2C
perspectiveconfig.perspectiveId FKAB47207E99AAFC2C
perspective modifiedBy int 10  √  null
perspective modifiedDate datetime 19  √  null
perspective name varchar 255  √  null
perspective navConfig varchar 255  √  null
perspective organizationId int 10  √  null
perspective perspectiveTypeId int 10
perspectivetype.id FKC653A3CAA82B7C0
perspective refId int 10  √  null
perspective scope int 10  √  null
perspective stereotypeId int 10  √  null
perspective.id FKC653A3C1E06C7A2
perspective viewConfig varchar 255  √  null
perspective xtype varchar 255  √  null
perspective_role createdBy int 10  √  null
perspective_role createdDate datetime 19  √  null
perspective_role id int 10  √ 
perspective_role modifiedBy int 10  √  null
perspective_role modifiedDate datetime 19  √  null
perspective_role organizationId int 10  √  null
perspective_role perspectiveId int 10
perspective.id FK4FA2049999AAFC2C
perspective_role roleId int 10  √  null
role.id FK4FA204991403590E
perspective_role sortOrder int 10  √  null
perspective_view createdBy int 10  √  null
perspective_view createdDate datetime 19  √  null
perspective_view id int 10  √ 
perspective_view location varchar 255  √  null
perspective_view modifiedBy int 10  √  null
perspective_view modifiedDate datetime 19  √  null
perspective_view organizationId int 10  √  null
perspective_view perspectiveId int 10
perspective.id FK4FA3BEC899AAFC2C
perspective_view sortOrder int 10  √  null
perspective_view viewId int 10
jamaview.id FK4FA3BEC81A80FDAC
perspectiveconfig config longtext 2147483647  √  null
perspectiveconfig createdBy int 10  √  null
perspectiveconfig createdDate datetime 19  √  null
perspectiveconfig id int 10  √ 
perspectiveconfig modifiedBy int 10  √  null
perspectiveconfig modifiedDate datetime 19  √  null
perspectiveconfig organizationId int 10  √  null
perspectiveconfig overridable char 1  √  null
perspectiveconfig perspectiveId int 10
perspective.id FKAB47207E99AAFC2C
perspectiveconfig projectId int 10  √  null
project.id FKAB47207E62A5139B
perspectiveconfig refId int 10  √  null
perspectiveconfig scope int 10  √  null
perspectivetype createdBy int 10  √  null
perspectivetype createdDate datetime 19  √  null
perspectivetype id int 10  √ 
perspective.perspectiveTypeId FKC653A3CAA82B7C0
perspectivetype modifiedBy int 10  √  null
perspectivetype modifiedDate datetime 19  √  null
perspectivetype name varchar 255  √  null
perspectivetype organizationId int 10  √  null
pluginentry active char 1  √  null
pluginentry createdBy int 10  √  null
pluginentry createdDate datetime 19  √  null
pluginentry id int 10  √ 
pluginentry modifiedBy int 10  √  null
pluginentry modifiedDate datetime 19  √  null
pluginentry name varchar 255  √  null
pluginentry notes longtext 2147483647  √  null
pluginentry organizationId int 10  √  null
pluginentry pluginClass longtext 2147483647  √  null
pluginentry pluginParams longtext 2147483647  √  null
pluginentry pluginType int 10  √  null
pluginentry refId int 10  √  null
pluginentry scope int 10  √  null
portlet description longtext 2147483647  √  null
portlet id int 10  √ 
portletinstance.portletId FK_PORTLETINSTANCE_PORTLET
portlet image varchar 255  √  null
portlet limittooneinstance char 1  √  null
portlet name varchar 255
portlet organizationId int 10  √  null
portlet portletXtype varchar 255
portletinstance dashboardId int 10
dashboard.id FK_PORTLETINSTANCE_DASHBOARD
portletinstance id int 10  √ 
portletinstanceproperties.portletInstanceId FK_PROPERTY_PORTLETINSTANCE
portletinstance location varchar 255
portletinstance organizationId int 10  √  null
portletinstance portletId int 10
portlet.id FK_PORTLETINSTANCE_PORTLET
portletinstanceproperties portletInstanceId int 10
portletinstance.id FK_PROPERTY_PORTLETINSTANCE
portletinstanceproperties propertyname varchar 255
portletinstanceproperties propertyvalue longtext 2147483647  √  null
project active char 1  √  null
project createdBy int 10  √  null
project createdDate datetime 19  √  null
project date1 datetime 19  √  null
project date2 datetime 19  √  null
project description longtext 2147483647  √  null
project flag1 char 1  √  null
project flag2 char 1  √  null
project id int 10  √ 
attachment.projectId FK8AF7592362A5139B
baseline.projectId FK996EE64562A5139B
distributiongroup.projectId FK3C591A7B62A5139B
document.projectId FK335CD11B62A5139B
documentgroup.projectId FK5EF19E4462A5139B
documentkeylookup.projectId FK_dockeylookup_project
evententry.project FK3AFE2618858B68C0
glossaryitem.projectId FKEE51863162A5139B
perspectiveconfig.projectId FKAB47207E62A5139B
review.projectId FKC84EF75862A5139B
viewconfig.projectId FKAC076E2762A5139B
project isFolder char 1  √  null
project lookup1Id int 10  √  null
lookup.id FKED904B196AC02593
project lookup2Id int 10  √  null
lookup.id FKED904B196AC02954
project lookup3Id int 10  √  null
lookup.id FKED904B196AC02D15
project lookup4Id int 10  √  null
lookup.id FKED904B196AC030D6
project modifiedBy int 10  √  null
project modifiedDate datetime 19  √  null
project name varchar 255  √  null
project organizationId int 10
organization.id FKED904B19B2808048
Associated organization
project parentId int 10  √  null
project projectGroupLookupId int 10  √  null
lookup.id FKED904B19C82FC15C
Associated project group
project projectKey varchar 255  √  null
project projectManager int 10  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
project projectTypeId int 10  √  null
projecttype.id FKED904B19B0B57FAF
project statusId int 10  √  null
lookup.id FKED904B1974C9DCCE
Status lookup
project string1 varchar 255  √  null
project string2 varchar 255  √  null
project string3 varchar 255  √  null
project string4 varchar 255  √  null
project text1 longtext 2147483647  √  null
project text2 longtext 2147483647  √  null
project text3 longtext 2147483647  √  null
project user1Id int 10  √  null
userbase.id FKED904B194267BDB3
project user2Id int 10  √  null
userbase.id FKED904B194267C174
projectfield category int 10  √  null
projectfield createdBy int 10  √  null
projectfield createdDate datetime 19  √  null
projectfield dataTypeId int 10  √  null
projectfield description longtext 2147483647  √  null
projectfield id int 10  √ 
projecttypefield.projectFieldId FKD312A70764B111EF
projectfield modifiedBy int 10  √  null
projectfield modifiedDate datetime 19  √  null
projectfield name varchar 255  √  null
projectfield organizationId int 10  √  null
projectfield refId int 10  √  null
projectfield scope int 10  √  null
projectrelease active char 1  √  null
projectrelease archived char 1  √  null
projectrelease createdBy int 10  √  null
projectrelease createdDate datetime 19  √  null
projectrelease description longtext 2147483647  √  null Description of release
projectrelease id int 10  √ 
document.release1Id FK335CD11B718FC1C5
document.release2Id FK335CD11B718FC586
document.releaseId FK335CD11BD1554582
System generated unique ID
projectrelease image varchar 255  √  null Path to icon
projectrelease modifiedBy int 10  √  null
projectrelease modifiedDate datetime 19  √  null
projectrelease name varchar 255  √  null Name of release
projectrelease organizationId int 10  √  null
projectrelease releaseDate datetime 19  √  null
projectrelease releaseTypeId int 10
releasetype.id FKE93DECE69C6616
Associated release type lookup
projectrelease sortOrder int 10  √  null Order of item
projecttype components longtext 2147483647  √  null
projecttype createdBy int 10  √  null
projecttype createdDate datetime 19  √  null
projecttype defaultDisplay varchar 255  √  null
projecttype defaultDisplayPlural varchar 255  √  null
projecttype defaultPrefix varchar 255  √  null
projecttype description longtext 2147483647  √  null
projecttype id int 10  √ 
project.projectTypeId FKED904B19B0B57FAF
projecttypefield.projectTypeId FKD312A707B0B57FAF
projecttype modifiedBy int 10  √  null
projecttype modifiedDate datetime 19  √  null
projecttype name varchar 255  √  null
projecttype organizationId int 10  √  null
projecttype refId int 10  √  null
projecttype scope int 10  √  null
projecttypefield controlStyle longtext 2147483647  √  null
projecttypefield controlTypeId int 10  √  null
projecttypefield createdBy int 10  √  null
projecttypefield createdDate datetime 19  √  null
projecttypefield description longtext 2147483647  √  null
projecttypefield groupName varchar 255  √  null
projecttypefield id int 10  √ 
projecttypefield label varchar 255  √  null
projecttypefield lookupTypeId int 10  √  null
projecttypefield modifiedBy int 10  √  null
projecttypefield modifiedDate datetime 19  √  null
projecttypefield name varchar 255  √  null
projecttypefield organizationId int 10  √  null
projecttypefield projectFieldId int 10
projectfield.id FKD312A70764B111EF
projecttypefield projectTypeId int 10  √  null
projecttype.id FKD312A707B0B57FAF
projecttypefield readOnly char 1  √  null
projecttypefield required char 1  √  null
projecttypefield script longtext 2147483647  √  null
projecttypefield showInFolder char 1  √  null
projecttypefield showInList char 1  √  null
projecttypefield sortOrder int 10  √  null
projecttypefield sortOrderInList int 10  √  null
projecttypefield validation longtext 2147483647  √  null
propertyentry createdBy int 10  √  null
propertyentry createdDate datetime 19  √  null
propertyentry id int 10  √ 
propertyentry modifiedBy int 10  √  null
propertyentry modifiedDate datetime 19  √  null