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 Mon Jun 14 17:03 PDT 2010
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

contour contains 880 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
aclobject createdBy int 11  √  null
aclobject createdDate datetime 19  √  null
aclobject id int 11  √ 
aclpermission.aclObjectId FKAF999D96BDCCF66
aclobject modifiedBy int 11  √  null
aclobject modifiedDate datetime 19  √  null
aclobject objectIdentity varchar 100  √  null
aclobject parentAclObjectId int 11  √  null
aclobject subObject longtext 2147483647  √  null
aclpermission aclObjectId int 11  √  null
aclobject.id FKAF999D96BDCCF66
aclpermission createdBy int 11  √  null
aclpermission createdDate datetime 19  √  null
aclpermission id int 11  √ 
aclpermission mask int 11
aclpermission modifiedBy int 11  √  null
aclpermission modifiedDate datetime 19  √  null
aclpermission roleId int 11  √  null
role.id FKAF999D91403590E
aclpermission userId int 11  √  null
userbase.id FKAF999D91958AE78
aclpermissionentry createdBy int 11  √  null
aclpermissionentry createdDate datetime 19  √  null
aclpermissionentry id int 11  √ 
aclpermissionentry mask bigint 20  √  null
aclpermissionentry modifiedBy int 11  √  null
aclpermissionentry modifiedDate datetime 19  √  null
aclpermissionentry objectId int 11  √  null
aclpermissionentry objectType int 11  √  null
aclpermissionentry permissionType int 11  √  null
aclpermissionentry sid int 11  √  null
aclpermissionentry sidType int 11  √  null
attachment attachmentTypeId int 11  √  null
attachment createdBy int 11  √  null
attachment createdDate datetime 19  √  null
attachment description longtext 2147483647  √  null
attachment fileName varchar 255  √  null
attachment fileSize int 11  √  null
attachment id int 11  √ 
document_attachment.attachmentId FKFEB8AEC756B0D1E8
report.attachmentId FKC84C553456B0D1E8
report.previewAttachmentId FKC84C55347CDA49B0
userbase.avatarId FK_USER_AVATAR
attachment mimeType longtext 2147483647  √  null
attachment modifiedBy int 11  √  null
attachment modifiedDate datetime 19  √  null
attachment organizationId int 11  √  null
organization.id FK8AF75923B2808048
attachment projectId int 11  √  null
project.id FK8AF7592343370F26
attachment system char 1  √  null
baseline active char 1  √  null
baseline createdBy int 11  √  null
baseline createdDate datetime 19  √  null
baseline description longtext 2147483647  √  null
baseline id int 11  √ 
baseline_version.baselineId FK5F1F94DE674BC58C
signature.baseLineId FK3FFD98B8674BC58C
baseline modifiedBy int 11  √  null
baseline modifiedDate datetime 19  √  null
baseline name varchar 255  √  null
baseline projectId int 11
project.id FK996EE64543370F26
baseline refId int 11  √  null
baseline scopeId int 11  √  null
baseline_version baselineId int 11
baseline.id FK5F1F94DE674BC58C
baseline_version versionId int 11
version.id FK5F1F94DE4C133EE4
changerequestassociation associatedItemId int 11
document.id FK8C59242E91C4E16
changerequestassociation changeRequestComment longtext 2147483647  √  null
changerequestassociation changeRequestItemId int 11
document.id FK8C59242A61FCB2F
changerequestassociation createdBy int 11  √  null
changerequestassociation createdDate datetime 19  √  null
changerequestassociation id int 11  √ 
changerequestassociation modifiedBy int 11  √  null
changerequestassociation modifiedDate datetime 19  √  null
changerequestassociation versionEndId int 11  √  null
version.id FK8C592429A27E04F
changerequestassociation versionStartId int 11  √  null
version.id FK8C59242D32E6C16
distributiongroup createdBy int 11  √  null User ID
distributiongroup createdDate datetime 19  √  null
distributiongroup description longtext 2147483647  √  null Text description
distributiongroup id int 11  √ 
distributiongroup_user.distributionGroupId FKC89CDF0F573B620A
System generated unique ID
distributiongroup modifiedBy int 11  √  null User ID
distributiongroup modifiedDate datetime 19  √  null
distributiongroup name varchar 255  √  null Label for the distribution group
distributiongroup organizationId int 11  √  null
organization.id FK3C591A7BB2808048
Associated organization ID
distributiongroup projectId int 11
project.id FK3C591A7B43370F26
Associated project ID
distributiongroup_user distributionGroupId int 11
distributiongroup.id FKC89CDF0F573B620A
distributiongroup_user userId int 11
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 assignedToId int 11  √  null
userbase.id FK335CD11BDDE05BF6
Associated User ID
document attachment int 11  √  null
document createdBy int 11  √  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 11  √  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 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 11  √  null
document hibVersion int 11  √  null
document id int 11  √ 
changerequestassociation.associatedItemId FK8C59242E91C4E16
changerequestassociation.changeRequestItemId FK8C59242A61FCB2F
document_attachment.documentId FKFEB8AEC7D766C998
document_docattach.docattachId FKD8310F5993BB117A
document_docattach.documentId FKD8310F59D766C998
document_document.fromDocument FKC5FF3FBFA6F164E7
document_document.toDocument FKC5FF3FBF3649FAB8
document_tag.document FKA835BA763B56973D
document_url.documentId FKA835C04BD766C998
documentcustomfieldvalue.documentId FKE13A6A03D766C998
evententry.document FK3AFE26183B56973D
jamacomment.documentId FKECA112F4D766C998
testresult.testCaseId FK9B0ED72F8937517F
version.documentId FK14F51CD8D766C998
version.originDocumentId FK14F51CD8662C413E
System generated unique ID
document indent int 11  √  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 locked char 1  √  null
document lockedBy int 11  √  null
userbase.id FK335CD11BBD032133
document lockedDate datetime 19  √  null
document lookup10Id int 11  √  null
lookup.id FK335CD11B739D9835
document lookup1Id int 11  √  null
lookup.id FK335CD11B6AC02593
document lookup2Id int 11  √  null
lookup.id FK335CD11B6AC02954
document lookup3Id int 11  √  null
lookup.id FK335CD11B6AC02D15
document lookup4Id int 11  √  null
lookup.id FK335CD11B6AC030D6
document lookup5Id int 11  √  null
lookup.id FK335CD11B6AC03497
document lookup6Id int 11  √  null
lookup.id FK335CD11B6AC03858
document lookup7Id int 11  √  null
lookup.id FK335CD11B6AC03C19
document lookup8Id int 11  √  null
lookup.id FK335CD11B6AC03FDA
document lookup9Id int 11  √  null
lookup.id FK335CD11B6AC0439B
document modifiedBy int 11  √  null
document modifiedDate datetime 19  √  null
document name varchar 255  √  null
document originalEstimate int 11  √  null Original estimate for an item - typically in hours
document parentId int 11  √  null ID of the parent item as configured in the tree view
document priorityId int 11  √  null
lookup.id FK335CD11B6080E200
Associated Priority ID
document projectId int 11
project.id FK335CD11B43370F26
related Project ID
document release1Id int 11  √  null
projectrelease.id FK335CD11B718FC1C5
document release2Id int 11  √  null
projectrelease.id FK335CD11B718FC586
document releaseId int 11  √  null
projectrelease.id FK335CD11BD1554582
Associated release ID
document remainingEstimate int 11  √  null Units remaining - typically in hours
document sequence varchar 255  √  null
document sortOrder int 11  √  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 11  √  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 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 11  √  null Actual time spent - typically in hours
document user1Id int 11  √  null
userbase.id FK335CD11B4267BDB3
document user2Id int 11  √  null
userbase.id FK335CD11B4267C174
document xprojectLinkId int 11  √  null Reference to a linked item from another project.
document_attachment attachmentId int 11  √  null
attachment.id FKFEB8AEC756B0D1E8
attachment ID
document_attachment createdBy int 11  √  null
document_attachment createdDate datetime 19  √  null
document_attachment documentId int 11  √  null
document.id FKFEB8AEC7D766C998
document ID
document_attachment id int 11  √  System generated unique ID
document_attachment modifiedBy int 11  √  null
document_attachment modifiedDate datetime 19  √  null
document_attachment note longtext 2147483647  √  null User entered text to describe the attachment
document_attachment url longtext 2147483647  √  null URL to the item
document_docattach createdBy int 11  √  null
document_docattach createdDate datetime 19  √  null
document_docattach docattachId int 11  √  null
document.id FKD8310F5993BB117A
document_docattach documentId int 11  √  null
document.id FKD8310F59D766C998
document_docattach id int 11  √ 
document_docattach modifiedBy int 11  √  null
document_docattach modifiedDate datetime 19  √  null
document_docattach note longtext 2147483647  √  null
document_document associationType int 11  √  null
lookup.id FKC5FF3FBFA07B777C
lookup ID
document_document createdBy int 11  √  null
document_document createdDate datetime 19  √  null
document_document description longtext 2147483647  √  null
document_document fromDocument int 11  √  null
document.id FKC5FF3FBFA6F164E7
ID of the item the link is coming from.
document_document id int 11  √  System generated unique ID
document_document modifiedBy int 11  √  null
document_document modifiedDate datetime 19  √  null
document_document relationshipType int 11  √  null
relationshiptype.id FKC5FF3FBF45B2C50B
document_document status int 11  √  null
lookup.id FKC5FF3FBFF0FE0433
document_document suspect char 1  √  null Suspect link flag
document_document toDocument int 11  √  null
document.id FKC5FF3FBF3649FAB8
ID of the item the link is pointing to
document_tag createdBy int 11  √  null
document_tag createdDate datetime 19  √  null
document_tag document int 11  √  null
document.id FKA835BA763B56973D
item ID
document_tag id int 11  √  System generated unique ID
document_tag modifiedBy int 11  √  null
document_tag modifiedDate datetime 19  √  null
document_tag tag int 11  √  null
tag.id FKA835BA765D4541CD
tag ID
document_url createdBy int 11  √  null
document_url createdDate datetime 19  √  null
document_url description longtext 2147483647  √  null
document_url documentId int 11  √  null
document.id FKA835C04BD766C998
document_url id int 11  √ 
document_url modifiedBy int 11  √  null
document_url modifiedDate datetime 19  √  null
document_url url longtext 2147483647  √  null
documentcustomfieldvalue createdBy int 11  √  null
documentcustomfieldvalue createdDate datetime 19  √  null
documentcustomfieldvalue documentId int 11  √  null
document.id FKE13A6A03D766C998
documentcustomfieldvalue fieldId int 11  √  null
documentcustomfieldvalue id int 11  √ 
documentcustomfieldvalue modifiedBy int 11  √  null
documentcustomfieldvalue modifiedDate datetime 19  √  null
documentcustomfieldvalue textValue longtext 2147483647  √  null
documentfield category int 11  √  null
documentfield createdBy int 11  √  null User ID
documentfield createdDate datetime 19  √  null
documentfield customField char 1  √  null
documentfield dataTypeId int 11  √  null Field data type lookup
documentfield description longtext 2147483647  √  null Label
documentfield editxtype varchar 255  √  null
documentfield fieldType int 11  √  null
documentfield formxtype varchar 255  √  null
documentfield gridxtype varchar 255  √  null
documentfield id int 11  √ 
documenttypefielddefinition.documentFieldId FK9F2566584D729212
integrationfieldmapping.fieldId FK7FB5A268F5ECC78D
System generated unique ID
documentfield isDerived char 1  √  null
documentfield modifiedBy int 11  √  null
documentfield modifiedDate datetime 19  √  null User ID
documentfield name varchar 255  √  null Internal name of field
documentfield readOnly char 1  √  null
documentfield refId int 11  √  null
documentfield scope int 11  √  null 1 = Organization
documentgroup active char 1  √  null Active flag
documentgroup createdBy int 11  √  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 11  √  null
documenttype.id FK5EF19E44E181EF2C
documentgroup id int 11  √ 
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 11  √  null User ID
documentgroup modifiedDate datetime 19  √  null
documentgroup prefix varchar 255  √  null Prefix for item Key such as 'REQ'
documentgroup projectId int 11  √  null
project.id FK5EF19E4443370F26
documentgroup sequenceNumber int 11  √  null Numerical value to start with when generating unique item keys
documentgroup sortOrder int 11  √  null Order relative to peers
documenttype active char 1  √  null
documenttype category int 11  √  null
documenttype components longtext 2147483647  √  null
documenttype createdBy int 11  √  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 id int 11  √ 
documentgroup.documentTypeId FK5EF19E44E181EF2C
documenttypefielddefinition.documentTypeId FK9F256658E181EF2C
filter.documentType FKB408CB78F3ED4351
documenttype modifiedBy int 11  √  null
documenttype modifiedDate datetime 19  √  null
documenttype name varchar 255  √  null
documenttype refId int 11  √  null
documenttype scope int 11  √  null
documenttypefielddefinition controlStyle longtext 2147483647  √  null
documenttypefielddefinition controlTypeId int 11  √  null
documenttypefielddefinition createdBy int 11  √  null
documenttypefielddefinition createdDate datetime 19  √  null
documenttypefielddefinition description longtext 2147483647  √  null
documenttypefielddefinition documentFieldId int 11
documentfield.id FK9F2566584D729212
documenttypefielddefinition documentTypeId int 11  √  null
documenttype.id FK9F256658E181EF2C
documenttypefielddefinition groupName varchar 255  √  null
documenttypefielddefinition id int 11  √ 
documenttypefielddefinition label varchar 255  √  null
documenttypefielddefinition lookupTypeId int 11  √  null
documenttypefielddefinition modifiedBy int 11  √  null
documenttypefielddefinition modifiedDate datetime 19  √  null
documenttypefielddefinition name varchar 255  √  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 11  √  null
documenttypefielddefinition sortOrderInList int 11  √  null
documenttypefielddefinition triggerSuspect char 1  √  null
documenttypefielddefinition validation longtext 2147483647  √  null
email attempts int 11  √  null
email createdBy int 11  √  null
email createdDate datetime 19  √  null
email emailBody longtext 2147483647  √  null
email fromAddress varchar 255  √  null
email id int 11  √ 
email modifiedBy int 11  √  null
email modifiedDate datetime 19  √  null
email status varchar 255  √  null
email subject varchar 255  √  null
email toAddress varchar 255  √  null
email userId int 11
userbase.id FK5C24B9C1958AE78
estimate createdBy int 11  √  null
estimate createdDate datetime 19  √  null
estimate estimate int 11  √  null
estimate estimatedBy varchar 255  √  null
estimate id int 11  √ 
estimate lookupId int 11  √  null
lookup.id FK8B302528AC877456
estimate modifiedBy int 11  √  null
estimate modifiedDate datetime 19  √  null
eventactiontype active char 1  √  null
eventactiontype description longtext 2147483647  √  null
eventactiontype eventTypeId int 11  √  null
eventactiontype id int 11  √ 
eventactiontype name varchar 255  √  null
eventactiontype objectTypeId int 11  √  null
eventactiontype sortOrder int 11  √  null
evententry action varchar 255  √  null
evententry comments longtext 2147483647  √  null
evententry createdBy int 11  √  null
evententry createdDate datetime 19  √  null
evententry document int 11  √  null
document.id FK3AFE26183B56973D
Associated item ID
evententry documentGroup int 11  √  null
documentgroup.id FK3AFE2618884663C1
evententry eventDate datetime 19  √  null
evententry EventType int 11  √  null
evententry eventUser int 11  √  null
userbase.id FK3AFE26184D1BFDB7
Associated user ID
evententry id int 11  √ 
evententry modifiedBy int 11  √  null
evententry modifiedDate datetime 19  √  null
evententry objectId int 11  √  null
evententry objectType int 11  √  null
evententry organization int 11  √  null
organization.id FK3AFE26183006F3ED
evententry parentEventEntryId int 11  √  null
evententry project int 11  √  null
project.id FK3AFE2618661D644B
Associated Project ID
evententry userComment longtext 2147483647  √  null
eventtype active char 1  √  null
eventtype createdBy int 11  √  null
eventtype createdDate datetime 19  √  null
eventtype description longtext 2147483647  √  null
eventtype id int 11  √ 
eventtype modifiedBy int 11  √  null
eventtype modifiedDate datetime 19  √  null
eventtype name varchar 255  √  null
eventtype sortOrder int 11  √  null
filter createdBy int 11  √  null
filter createdDate datetime 19  √  null
filter description longtext 2147483647  √  null
filter documentGroup int 11  √  null
documentgroup.id FKB408CB78884663C1
filter documentType int 11  √  null
documenttype.id FKB408CB78F3ED4351
filter id int 11  √ 
filter isHidden char 1  √  null
filter modifiedBy int 11  √  null
filter modifiedDate datetime 19  √  null
filter name varchar 255  √  null
filter refId int 11  √  null
filter scope int 11  √  null
filter xmlString longtext 2147483647  √  null
glossaryitem createdBy int 11  √  null
glossaryitem createdDate datetime 19  √  null
glossaryitem definition longtext 2147483647  √  null
glossaryitem id int 11  √ 
glossaryitem modifiedBy int 11  √  null
glossaryitem modifiedDate datetime 19  √  null
glossaryitem projectId int 11
project.id FKEE51863143370F26
glossaryitem term varchar 255  √  null
integrationcomponentmapping active char 1
integrationcomponentmapping commentsDirectionTypeId int 11  √  null
integrationdirectiontype.id FKBCFD23059A05EA8C
integrationcomponentmapping contourSyncRule int 11  √  null
integrationcomponentmapping createdBy int 11  √  null
integrationcomponentmapping createdDate datetime 19  √  null
integrationcomponentmapping id int 11  √ 
integrationfieldmapping.setMappingId FK7FB5A268BF0C02E5
integrationcomponentmapping integrationFilter int 11  √  null
integrationcomponentmapping integrationSyncRule int 11  √  null
integrationcomponentmapping integrationTrigger varchar 255  √  null
integrationcomponentmapping integrationTypeId int 11
integrationtype.id FKBCFD23057EF490F0
integrationcomponentmapping mappedId varchar 255  √  null
integrationcomponentmapping mappedName varchar 255  √  null
integrationcomponentmapping modifiedBy int 11  √  null
integrationcomponentmapping modifiedDate datetime 19  √  null
integrationcomponentmapping pullIntoContourFilter int 11  √  null
integrationcomponentmapping pullIntoContourFlag char 1  √  null
integrationcomponentmapping pushFromContourFlag char 1  √  null
integrationcomponentmapping refId int 11
integrationcomponentmapping scope int 11
integrationconnection active char 1
integrationconnection createdBy int 11  √  null
integrationconnection createdDate datetime 19  √  null
integrationconnection cronString varchar 255  √  null
integrationconnection defaultContourUserId int 11  √  null
userbase.id FKB2C6BBB2845B1931
integrationconnection id int 11  √ 
integrationconnection integrationTypeId int 11
integrationtype.id FKB2C6BBB27EF490F0
integrationconnection intervalMinutes int 11  √  null
integrationconnection modifiedBy int 11  √  null
integrationconnection modifiedDate datetime 19  √  null
integrationconnection password varchar 255  √  null
integrationconnection refId int 11
integrationconnection scope int 11
integrationconnection url varchar 255  √  null
integrationconnection useAdvancedScheduling char 1  √  null
integrationconnection userName varchar 255  √  null
integrationdirectiontype createdBy int 11  √  null
integrationdirectiontype createdDate datetime 19  √  null
integrationdirectiontype id int 11  √ 
integrationcomponentmapping.commentsDirectionTypeId FKBCFD23059A05EA8C
integrationfieldmapping.updateDirectionTypeId FK7FB5A268917BEB17
integrationdirectiontype modifiedBy int 11  √  null
integrationdirectiontype modifiedDate datetime 19  √  null
integrationdirectiontype name varchar 255
integrationfieldmapping active char 1
integrationfieldmapping createdBy int 11  √  null
integrationfieldmapping createdDate datetime 19  √  null
integrationfieldmapping fieldId int 11
documentfield.id FK7FB5A268F5ECC78D
integrationfieldmapping id int 11  √ 
integrationfieldmapping integrationTypeId int 11
integrationtype.id FK7FB5A2687EF490F0
integrationfieldmapping mappedId varchar 255  √  null
integrationfieldmapping mappedName varchar 255  √  null
integrationfieldmapping modifiedBy int 11  √  null
integrationfieldmapping modifiedDate datetime 19  √  null
integrationfieldmapping setMappingId int 11
integrationcomponentmapping.id FK7FB5A268BF0C02E5
integrationfieldmapping updateDirectionTypeId int 11  √  null
integrationdirectiontype.id FK7FB5A268917BEB17
integrationfieldmapping useContourOnConflict char 1  √  null
integrationtype createdBy int 11  √  null
integrationtype createdDate datetime 19  √  null
integrationtype id int 11  √ 
integrationcomponentmapping.integrationTypeId FKBCFD23057EF490F0
integrationconnection.integrationTypeId FKB2C6BBB27EF490F0
integrationfieldmapping.integrationTypeId FK7FB5A2687EF490F0
integrationtype modifiedBy int 11  √  null
integrationtype modifiedDate datetime 19  √  null
integrationtype name varchar 255
jamaauthprovider baseDn longtext 2147483647  √  null
jamaauthprovider bindDn longtext 2147483647  √  null
jamaauthprovider bindPassword longtext 2147483647  √  null
jamaauthprovider createdBy int 11  √  null
jamaauthprovider createdDate datetime 19  √  null
jamaauthprovider description longtext 2147483647  √  null
jamaauthprovider emailAttribute longtext 2147483647  √  null
jamaauthprovider id int 11  √ 
jamaauthprovider modifiedBy int 11  √  null
jamaauthprovider modifiedDate datetime 19  √  null
jamaauthprovider name varchar 255  √  null
jamaauthprovider nameAttribute longtext 2147483647  √  null
jamaauthprovider type varchar 255  √  null
jamaauthprovider url longtext 2147483647  √  null
jamaauthprovider userNameAttribute longtext 2147483647  √  null
jamacomment commentText longtext 2147483647  √  null Comment text
jamacomment createdBy int 11  √  null User ID
jamacomment createdDate datetime 19  √  null
jamacomment documentId int 11  √  null
document.id FKECA112F4D766C998
Associated artifact
jamacomment entryDate datetime 19  √  null Date comment was created
jamacomment id int 11  √  System generated unique Id
jamacomment modifiedBy int 11  √  null User ID
jamacomment modifiedDate datetime 19  √  null
jamacomment userId int 11  √  null
userbase.id FKECA112F41958AE78
User Id
jamaview active char 1  √  null
jamaview createdBy int 11  √  null
jamaview createdDate datetime 19  √  null
jamaview description longtext 2147483647  √  null
jamaview id int 11  √ 
jamaview.stereotypeId FKCE07663057893EF9
perspective_view.viewId FK4FA3BEC81A80FDAC
view_itemtype.viewId FKB04369271A80FDAC
viewconfig.viewId FKAC076E271A80FDAC
jamaview modifiedBy int 11  √  null
jamaview modifiedDate datetime 19  √  null
jamaview name varchar 255  √  null
jamaview refId int 11  √  null
jamaview scope int 11  √  null
jamaview stereotypeId int 11  √  null
jamaview.id FKCE07663057893EF9
jamaview viewConfig longtext 2147483647  √  null
jamaview viewIcon varchar 255  √  null
jamaview viewTypeId int 11
viewtype.id FKCE076630E57BF940
jamaview xtype varchar 255  √  null
jobschedule active char 1  √  null
jobschedule createdBy int 11  √  null
jobschedule createdDate datetime 19  √  null
jobschedule cronExpression varchar 255  √  null
jobschedule description longtext 2147483647  √  null
jobschedule id int 11  √ 
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 11  √  null
jobschedule modifiedDate datetime 19  √  null
jobschedule params varchar 255  √  null
lookup active char 1  √  null
lookup createdBy int 11  √  null
lookup createdDate datetime 19  √  null
lookup dataValue varchar 255  √  null
lookup description longtext 2147483647  √  null User entered description
lookup id int 11  √ 
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 11
lookuptype.id FKBE9BA97A8CB30AEA
Associated lookup list
lookup modifiedBy int 11  √  null
lookup modifiedDate datetime 19  √  null
lookup name varchar 255  √  null name of lookup
lookup sortOrder int 11  √  null list order
lookuptype active char 1  √  null
lookuptype category int 11  √  null
lookuptype createdBy int 11  √  null
lookuptype createdDate datetime 19  √  null
lookuptype defaultValue int 11  √  null
lookuptype description longtext 2147483647  √  null
lookuptype id int 11  √ 
lookup.lookupTypeId FKBE9BA97A8CB30AEA
lookuptype modifiedBy int 11  √  null
lookuptype modifiedDate datetime 19  √  null
lookuptype name varchar 255  √  null
lookuptype refId int 11  √  null
lookuptype scope int 11  √  null
lookuptype type int 11  √  null
objecttype active char 1  √  null
objecttype createdBy int 11  √  null
objecttype createdDate datetime 19  √  null
objecttype description longtext 2147483647  √  null
objecttype id int 11  √ 
objecttype modifiedBy int 11  √  null
objecttype modifiedDate datetime 19  √  null
objecttype name varchar 255  √  null
objecttype sortOrder int 11  √  null
organization baseUrl varchar 255  √  null
organization createdBy int 11  √  null
organization createdDate datetime 19  √  null
organization description longtext 2147483647  √  null
organization id int 11  √ 
attachment.organizationId FK8AF75923B2808048
distributiongroup.organizationId FK3C591A7BB2808048
evententry.organization FK3AFE26183006F3ED
project.organizationId FKED904B19B2808048
user_organization.organizationId FK3622D27B2808048
userbase.organization FKF024151C3006F3ED
organization licenseMessage int 11  √  null
organization modifiedBy int 11  √  null
organization modifiedDate datetime 19  √  null
organization name varchar 255
organization returnEmail varchar 255  √  null
organization subdomain varchar 255  √  null
perspective active char 1  √  null
perspective canOverride char 1  √  null
perspective createdBy int 11  √  null
perspective createdDate datetime 19  √  null
perspective description longtext 2147483647  √  null
perspective headerConfig varchar 255  √  null
perspective icon varchar 255  √  null
perspective id int 11  √ 
perspective.stereotypeId FKC653A3C1E06C7A2
perspective_role.perspectiveId FK4FA2049999AAFC2C
perspective_view.perspectiveId FK4FA3BEC899AAFC2C
perspectiveconfig.perspectiveId FKAB47207E99AAFC2C
perspective modifiedBy int 11  √  null
perspective modifiedDate datetime 19  √  null
perspective name varchar 255  √  null
perspective navConfig varchar 255  √  null
perspective perspectiveTypeId int 11
perspectivetype.id FKC653A3CAA82B7C0
perspective refId int 11  √  null
perspective scope int 11  √  null
perspective stereotypeId int 11  √  null
perspective.id FKC653A3C1E06C7A2
perspective viewConfig varchar 255  √  null
perspective xtype varchar 255  √  null
perspective_role createdBy int 11  √  null
perspective_role createdDate datetime 19  √  null
perspective_role id int 11  √ 
perspective_role modifiedBy int 11  √  null
perspective_role modifiedDate datetime 19  √  null
perspective_role perspectiveId int 11
perspective.id FK4FA2049999AAFC2C
perspective_role roleId int 11  √  null
role.id FK4FA204991403590E
perspective_role sortOrder int 11  √  null
perspective_view createdBy int 11  √  null
perspective_view createdDate datetime 19  √  null
perspective_view id int 11  √ 
perspective_view location varchar 255  √  null
perspective_view modifiedBy int 11  √  null
perspective_view modifiedDate datetime 19  √  null
perspective_view perspectiveId int 11
perspective.id FK4FA3BEC899AAFC2C
perspective_view sortOrder int 11  √  null
perspective_view viewId int 11
jamaview.id FK4FA3BEC81A80FDAC
perspectiveconfig config longtext 2147483647  √  null
perspectiveconfig createdBy int 11  √  null
perspectiveconfig createdDate datetime 19  √  null
perspectiveconfig id int 11  √ 
perspectiveconfig modifiedBy int 11  √  null
perspectiveconfig modifiedDate datetime 19  √  null
perspectiveconfig overridable char 1  √  null
perspectiveconfig perspectiveId int 11
perspective.id FKAB47207E99AAFC2C
perspectiveconfig projectId int 11  √  null
project.id FKAB47207E43370F26
perspectiveconfig refId int 11  √  null
perspectiveconfig scope int 11  √  null
perspectivetype createdBy int 11  √  null
perspectivetype createdDate datetime 19  √  null
perspectivetype id int 11  √ 
perspective.perspectiveTypeId FKC653A3CAA82B7C0
perspectivetype modifiedBy int 11  √  null
perspectivetype modifiedDate datetime 19  √  null
perspectivetype name varchar 255  √  null
pluginentry active char 1  √  null
pluginentry createdBy int 11  √  null
pluginentry createdDate datetime 19  √  null
pluginentry id int 11  √ 
pluginentry modifiedBy int 11  √  null
pluginentry modifiedDate datetime 19  √  null
pluginentry name varchar 255  √  null
pluginentry notes longtext 2147483647  √  null
pluginentry pluginClass longtext 2147483647  √  null
pluginentry pluginParams longtext 2147483647  √  null
pluginentry pluginType int 11  √  null
pluginentry refId int 11  √  null
pluginentry scope int 11  √  null
project active char 1  √  null
project createdBy int 11  √  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 11  √ 
attachment.projectId FK8AF7592343370F26
baseline.projectId FK996EE64543370F26
distributiongroup.projectId FK3C591A7B43370F26
document.projectId FK335CD11B43370F26
documentgroup.projectId FK5EF19E4443370F26
evententry.project FK3AFE2618661D644B
glossaryitem.projectId FKEE51863143370F26
perspectiveconfig.projectId FKAB47207E43370F26
viewconfig.projectId FKAC076E2743370F26
project isFolder char 1  √  null
project lookup1Id int 11  √  null
lookup.id FKED904B196AC02593
project lookup2Id int 11  √  null
lookup.id FKED904B196AC02954
project lookup3Id int 11  √  null
lookup.id FKED904B196AC02D15
project lookup4Id int 11  √  null
lookup.id FKED904B196AC030D6
project modifiedBy int 11  √  null
project modifiedDate datetime 19  √  null
project name varchar 255  √  null
project organizationId int 11
organization.id FKED904B19B2808048
Associated organization
project parentId int 11  √  null
project projectGroupLookupId int 11  √  null
lookup.id FKED904B19C82FC15C
Associated project group
project projectManager int 11  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
project projectTypeId int 11  √  null
projecttype.id FKED904B19B978BDBA
project statusId int 11  √  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 11  √  null
userbase.id FKED904B194267BDB3
project user2Id int 11  √  null
userbase.id FKED904B194267C174
projectfield category int 11  √  null
projectfield createdBy int 11  √  null
projectfield createdDate datetime 19  √  null
projectfield dataTypeId int 11  √  null
projectfield description longtext 2147483647  √  null
projectfield id int 11  √ 
projecttypefield.projectFieldId FKD312A70774559544
projectfield modifiedBy int 11  √  null
projectfield modifiedDate datetime 19  √  null
projectfield name varchar 255  √  null
projectfield refId int 11  √  null
projectfield scope int 11  √  null
projectrelease active char 1  √  null
projectrelease createdBy int 11  √  null
projectrelease createdDate datetime 19  √  null
projectrelease description longtext 2147483647  √  null Description of release
projectrelease id int 11  √ 
document.release1Id FK335CD11B718FC1C5
document.release2Id FK335CD11B718FC586
document.releaseId FK335CD11BD1554582
System generated unique ID
projectrelease image varchar 255  √  null Path to icon
projectrelease modifiedBy int 11  √  null
projectrelease modifiedDate datetime 19  √  null
projectrelease name varchar 255  √  null Name of release
projectrelease releaseDate datetime 19  √  null
projectrelease releaseTypeId int 11
releasetype.id FKE93DECE69C6616
Associated release type lookup
projectrelease sortOrder int 11  √  null Order of item
projecttype components longtext 2147483647  √  null
projecttype createdBy int 11  √  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 11  √ 
project.projectTypeId FKED904B19B978BDBA
projecttypefield.projectTypeId FKD312A707B978BDBA
projecttype modifiedBy int 11  √  null
projecttype modifiedDate datetime 19  √  null
projecttype name varchar 255  √  null
projecttype refId int 11  √  null
projecttype scope int 11  √  null
projecttypefield controlStyle longtext 2147483647  √  null
projecttypefield controlTypeId int 11  √  null
projecttypefield createdBy int 11  √  null
projecttypefield createdDate datetime 19  √  null
projecttypefield description longtext 2147483647  √  null
projecttypefield groupName varchar 255  √  null
projecttypefield id int 11  √ 
projecttypefield label varchar 255  √  null
projecttypefield lookupTypeId int 11  √  null
projecttypefield modifiedBy int 11  √  null
projecttypefield modifiedDate datetime 19  √  null
projecttypefield name varchar 255  √  null
projecttypefield projectFieldId int 11
projectfield.id FKD312A70774559544
projecttypefield projectTypeId int 11  √  null
projecttype.id FKD312A707B978BDBA
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 11  √  null
projecttypefield sortOrderInList int 11  √  null
projecttypefield validation longtext 2147483647  √  null
propertyentry createdBy int 11  √  null
propertyentry createdDate datetime 19  √  null
propertyentry id int 11  √ 
propertyentry modifiedBy int 11  √  null
propertyentry modifiedDate datetime 19  √  null
propertyentry propertyName varchar 255  √  null
propertyentry propertyType int 11  √  null
propertyentry propertyValue longtext 2147483647  √  null
propertyentry refId int 11  √  null
propertyentry scope int 11  √  null
relationshiptype active char 1  √  null
relationshiptype createdBy int 11  √  null
relationshiptype createdDate datetime 19  √  null
relationshiptype description longtext 2147483647  √  null
relationshiptype id int 11  √ 
document_document.relationshipType FKC5FF3FBF45B2C50B
relationshiptype image varchar 255  √  null
relationshiptype isDefault char 1  √  null
relationshiptype modifiedBy int 11  √  null
relationshiptype modifiedDate datetime 19  √  null
relationshiptype name varchar 255  √  null
relationshiptype refId int 11  √  null
relationshiptype scope int 11  √  null
relationshiptype showNote char 1  √  null
relationshiptype showStatus char 1  √  null
relationshiptype sortOrder int 11  √  null
releasetype category int 11  √  null
releasetype createdBy int 11  √  null
releasetype createdDate datetime 19  √  null
releasetype defaultValue int 11  √  null
releasetype description longtext 2147483647  √  null
releasetype id int 11  √ 
projectrelease.releaseTypeId FKE93DECE69C6616
releasetype modifiedBy int 11  √  null
releasetype modifiedDate datetime 19  √  null
releasetype name varchar 255  √  null Drop down list item
releasetype refId int 11  √  null
releasetype scope int 11  √  null
report attachmentId int 11  √  null
attachment.id FKC84C553456B0D1E8
ID of report file
report contextSensitive char 1  √  null
report createdBy int 11  √  null
report createdDate datetime 19  √  null
report description longtext 2147483647  √  null Admin entered description of report
report display varchar 255  √  null Display name of report
report excelStartDataTest varchar 255  √  null
report id int 11  √ 
report_criterion.reportId FKC53D6D56166CC54A
report_reportformat.reportId FK5EEEBF56166CC54A
reportcriteria.reportId FK767C093166CC54A
System generated unique ID
report modifiedBy int 11  √  null
report modifiedDate datetime 19  √  null
report name varchar 255  √  null Internal name of report (Duplicate)
report previewAttachmentId int 11  √  null
attachment.id FKC84C55347CDA49B0
report refId int 11  √  null
report reportClass varchar 1024  √  null
report reportParams longtext 2147483647  √  null
report reportTypeId int 11  √  null
reporttype.id FKC84C5534F0DEC1DE
report scope int 11  √  null
report showJamaFields char 1  √  null
report sortItems char 1  √  null
report system char 1  √  null
report visible char 1  √  null Flag to indicate the report is visible to users
report_criterion name varchar 255 Criteria to display to user when running a report
report_criterion reportId int 11
report.id FKC53D6D56166CC54A
report_reportformat reportFormatId int 11
reportformat.id FK5EEEBF56604E6058
report_reportformat reportId int 11
report.id FK5EEEBF56166CC54A
reportcriteria createdBy int 11  √  null
reportcriteria createdDate datetime 19  √  null
reportcriteria datatype varchar 255  √  null
reportcriteria displayName varchar 255  √  null
reportcriteria id int 11  √ 
reportcriteria modifiedBy int 11  √  null
reportcriteria modifiedDate datetime 19  √  null
reportcriteria name varchar 255  √  null
reportcriteria reportId int 11  √  null
report.id FK767C093166CC54A
reportformat contentType varchar 255  √  null
reportformat createdBy int 11  √  null
reportformat createdDate datetime 19  √  null
reportformat display varchar 255  √  null
reportformat extention varchar 255  √  null
reportformat id int 11  √ 
report_reportformat.reportFormatId FK5EEEBF56604E6058
reportformat modifiedBy int 11  √  null
reportformat modifiedDate datetime 19  √  null
reportformat name varchar 255  √  null
reporttype createdBy int 11  √  null
reporttype createdDate datetime 19  √  null
reporttype id int 11  √ 
report.reportTypeId FKC84C5534F0DEC1DE
reporttype modifiedBy int 11  √  null
reporttype modifiedDate datetime 19  √  null
reporttype name varchar 255  √  null
role createdBy int 11  √  null
role createdDate datetime 19  √  null
role description longtext 2147483647  √  null
role display varchar 255  √  null
role id int 11  √ 
aclpermission.roleId FKAF999D91403590E
perspective_role.roleId FK4FA204991403590E
user_role.roleId FK143BF46A1403590E
role modifiedBy int 11  √  null
role modifiedDate datetime 19  √  null
role name varchar 255  √  null
role organizationId int 11  √  null Associated Organization
role projectId int 11  √  null
signature baseLineId int 11
baseline.id FK3FFD98B8674BC58C
signature comments longtext 2147483647  √  null
signature createdBy int 11  √  null
signature createdDate datetime 19  √  null
signature id int 11  √ 
signature isRevoked char 1  √  null
signature modifiedBy int 11  √  null
signature modifiedDate datetime 19  √  null
signature revokeComments varchar 255  √  null
signature revokeDate datetime 19  √  null
signature userId int 11
userbase.id FK3FFD98B81958AE78
subscription createdBy int 11  √  null
subscription createdDate datetime 19  √  null
subscription id int 11  √ 
subscription modifiedBy int 11  √  null
subscription modifiedDate datetime 19  √  null
subscription refId int 11  √  null
subscription scope int 11  √  null
subscription userId int 11
userbase.id FK1456591D1958AE78
tag createdBy int 11  √  null
tag createdDate datetime 19  √  null
tag id int 11  √ 
document_tag.tag FKA835BA765D4541CD
tag modifiedBy int 11  √  null
tag modifiedDate datetime 19  √  null
tag refId int 11  √  null ID related to scope
tag scope int 11  √  null
tag tagName varchar 255  √  null Tag Name
testresult createdBy int 11  √  null User ID
testresult createdDate datetime 19  √  null
testresult id int 11  √  System generated unique ID
testresult modifiedBy int 11  √  null User ID
testresult modifiedDate datetime 19  √  null
testresult notes longtext 2147483647  √  null User entered notes about the executing the test case
testresult passStatus char 1  √  null Flag - 'Y' or 'N'
testresult testCaseDetails longtext 2147483647  √  null
testresult testCaseId int 11  √  null
document.id FK9B0ED72F8937517F
Associated test case ID
testresult testConfiguration int 11  √  null
lookup.id FK9B0ED72FDAF8E1E5
Associated lookup list
user_job createdBy int 11  √  null
user_job createdDate datetime 19  √  null
user_job id int 11  √ 
user_job job int 11  √  null
jobschedule.id FKF022D94934453ACA
user_job lastGenerated datetime 19  √  null
user_job modifiedBy int 11  √  null
user_job modifiedDate datetime 19  √  null
user_job userId int 11  √  null
userbase.id FKF022D9491958AE78
user_organization createdBy int 11  √  null
user_organization createdDate datetime 19  √  null
user_organization id int 11  √ 
user_organization licenseType varchar 255  √  null
user_organization modifiedBy int 11  √  null
user_organization modifiedDate datetime 19  √  null
user_organization organizationId int 11
organization.id FK3622D27B2808048
user_organization userId int 11
userbase.id FK3622D271958AE78
user_role roleId int 11
role.id FK143BF46A1403590E
Role ID
user_role userId int 11
userbase.id FK143BF46A1958AE78
User ID
userbase avatarId int 11  √  null
attachment.id FK_USER_AVATAR
userbase createdBy int 11  √  null
userbase createdDate datetime 19  √  null
userbase disabled char 1  √  null
userbase email varchar 255 User email
userbase firstName varchar 255  √  null User first name
userbase id int 11  √ 
aclpermission.userId FKAF999D91958AE78
distributiongroup_user.userId FKC89CDF0F1958AE78
document.assignedToId FK335CD11BDDE05BF6
document.lockedBy FK335CD11BBD032133
document.user1Id FK335CD11B4267BDB3
document.user2Id FK335CD11B4267C174
email.userId FK5C24B9C1958AE78
evententry.eventUser FK3AFE26184D1BFDB7
integrationconnection.defaultContourUserId FKB2C6BBB2845B1931
jamacomment.userId FKECA112F41958AE78
project.projectManager FKED904B194A8942C6
project.user1Id FKED904B194267BDB3
project.user2Id FKED904B194267C174
signature.userId FK3FFD98B81958AE78
subscription.userId FK1456591D1958AE78
user_job.userId FKF022D9491958AE78
user_organization.userId FK3622D271958AE78
user_role.userId FK143BF46A1958AE78
System generated unique ID
userbase lastName varchar 255  √  null User last name
userbase licenseType varchar 255  √  null
userbase locale varchar 32  √  null
userbase location varchar 64  √  null
userbase locked char 1  √  null
userbase modifiedBy int 11  √  null
userbase modifiedDate datetime 19  √  null
userbase notes longtext 2147483647  √  null
userbase organization int 11  √  null
organization.id FKF024151C3006F3ED
userbase password varchar 50 Hashed password
userbase passwordAttempts int 11  √  null
userbase phone varchar 64  √  null
userbase systemUser char 1  √  null
userbase theme varchar 64  √  null
userbase title varchar 64  √  null
userbase userName varchar 255
userbase visibleUser char 1  √  null Internal flag to indicate if the user account is visible
version comments longtext 2147483647  √  null
version createdBy int 11  √  null
version createdDate datetime 19  √  null
version documentId int 11
document.id FK14F51CD8D766C998
version id int 11  √ 
baseline_version.versionId FK5F1F94DE4C133EE4
changerequestassociation.versionEndId FK8C592429A27E04F
changerequestassociation.versionStartId FK8C59242D32E6C16
version modifiedBy int 11  √  null
version modifiedDate datetime 19  √  null
version originDocumentId int 11
document.id FK14F51CD8662C413E
version userComment longtext 2147483647  √  null
version versionNumber varchar 255  √  null
view_itemtype createdBy int 11  √  null
view_itemtype createdDate datetime 19  √  null
view_itemtype id int 11  √ 
view_itemtype isVisible char 1  √  null
view_itemtype itemTypeId int 11  √  null
view_itemtype modifiedBy int 11  √  null
view_itemtype modifiedDate datetime 19  √  null
view_itemtype refId int 11  √  null
view_itemtype scope int 11  √  null
view_itemtype sortOrder int 11  √  null
view_itemtype viewId int 11
jamaview.id FKB04369271A80FDAC
viewconfig config longtext 2147483647  √  null
viewconfig createdBy int 11  √  null
viewconfig createdDate datetime 19  √  null
viewconfig id int 11  √ 
viewconfig modifiedBy int 11  √  null
viewconfig modifiedDate datetime 19  √  null
viewconfig overridable char 1  √  null
viewconfig projectId int 11  √  null
project.id FKAC076E2743370F26
viewconfig refId int 11  √  null
viewconfig scope int 11  √  null
viewconfig viewId int 11
jamaview.id FKAC076E271A80FDAC
viewtype createdBy int 11  √  null
viewtype createdDate datetime 19  √  null
viewtype id int 11  √ 
jamaview.viewTypeId FKCE076630E57BF940
viewtype modifiedBy int 11  √  null
viewtype modifiedDate datetime 19  √  null
viewtype name varchar 255  √  null