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 Sun Feb 05 20:26 PST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

contour contains 1309 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
c3p0_connection_test_table a char 1  √  null
baseline active char 1  √  null
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.
documentgroup active char 1  √  null Active flag
documentnode active char 1  √  null
documenttype active char 1  √  null
eventactiontype active char 1  √  null
eventtype active char 1  √  null
fieldlayoutentry active char 1  √  null
integrationcomponentmapping active char 1
integrationconnection active char 1
integrationfieldmapping active char 1
itemtemplate active char 1  √  null
jamacomment active char 1  √  null
jamaview active char 1  √  null
jobschedule active char 1  √  null
lookup active char 1  √  null
lookuptype active char 1  √  null
objecttype active char 1  √  null
perspective active char 1  √  null
pluginentry active char 1  √  null
project active char 1  √  null
projectrelease active char 1  √  null
relationshiptype active char 1  √  null
testrunset active char 1  √  null
review allowAddReviewersAndApprovers char 1  √  null
review allowDelegateApproval char 1  √  null
revision allowVoting char 1  √  null
review approved char 1  √  null
revision_user approvedRevision char 1  √  null
document archived char 1  √  null
projectrelease archived char 1  √  null
userbase autoFollowCommentedItems char 1  √  null
perspective canOverride char 1  √  null
organization closed char 1  √  null
report contextSensitive char 1  √  null
documentfield customField char 1  √  null
userbase disabled char 1  √  null
documentgroup displayInReleaseTree char 1  √  null Flag that determines if the items should be included in the default display of the milestones tree
userbase emailUpdatesToFollowedItems char 1  √  null
jamaauthprovider enableJndiReferrals char 1  √  null
revision_user finishedRevision char 1  √  null
document flag1 char 1  √  null User defined field - Boolean
project flag1 char 1  √  null
document flag2 char 1  √  null User defined field - Boolean
project flag2 char 1  √  null
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
jamacomment important char 1  √  null
revision_user isApprover char 1  √  null
lookup isDefault char 1  √  null
relationshiptype isDefault char 1  √  null
documentfield isDerived char 1  √  null
document isFolder char 1  √  null Indicator that the item is a folder
project isFolder char 1  √  null
filter isHidden char 1  √  null
smartfilter isHidden char 1  √  null
documentnode isPermissionNode char 1
jamacomment isPrivate char 1  √  null
smartfilter isPublic char 1  √  null
signature isRevoked char 1  √  null
documenttypefielddefinition isSynchronizeField char 1  √  null
itemtemplate isSystem char 1  √  null
integrationcomponentmapping isUpstream char 1  √  null
view_itemtype isVisible char 1  √  null
portlet limittooneinstance char 1  √  null
document locked char 1  √  null
userbase locked char 1  √  null
revision notifyAuthorOnComplete char 1  √  null
perspectiveconfig overridable char 1  √  null
viewconfig overridable char 1  √  null
testresult passStatus char 1  √  null Flag - 'Y' or 'N'
integrationcomponentmapping pullIntoContourFlag char 1  √  null
integrationcomponentmapping pushFromContourFlag char 1  √  null
documentfield readOnly char 1  √  null
documenttypefielddefinition readOnly char 1  √  null
projecttypefield readOnly char 1  √  null
documenttypefielddefinition required char 1  √  null
projecttypefield required char 1  √  null
revision requireSignature char 1  √  null
documenttypefielddefinition showInFolder char 1  √  null
projecttypefield showInFolder char 1  √  null
documenttypefielddefinition showInList char 1  √  null
projecttypefield showInList char 1  √  null
relationshiptype showNote char 1  √  null
revision_user showSplashScreen char 1  √  null
relationshiptype showStatus char 1  √  null
report sortItems char 1  √  null
document_document suspect char 1  √  null Suspect link flag
attachment system char 1  √  null
report system char 1  √  null
userbase systemUser char 1  √  null
review timeTrackingEnabled char 1
documenttypefielddefinition triggerSuspect char 1  √  null
userbase unregistered char 1  √  null
integrationconnection useAdvancedScheduling char 1  √  null
integrationfieldmapping useContourOnConflict char 1  √  null
documentfield userConfigurable char 1  √  null
report visible char 1  √  null Flag to indicate the report is visible to users
userbase visibleUser char 1  √  null Internal flag to indicate if the user account is visible
aclpermission aclObjectId int 10  √  null
aclobject.id FKAF999D96BDCCF66
document assignedToId int 10  √  null
userbase.id FK_TESTRUN_USER
Associated User ID
testrunset assignedToId int 10  √  null
userbase.id FK_TESTRUNSET_USER
testset assignedToId int 10  √  null
userbase.id FK_TESTSET_ASSIGNEDTO
changerequestassociation associatedItemId int 10
document.id FK8C59242EC05EE9A
document_document associationType int 10  √  null
lookup.id FKC5FF3FBFA07B777C
lookup ID
document attachment int 10  √  null
document_attachment attachmentId int 10  √  null
attachment.id FKFEB8AEC756B0D1E8
attachment ID
report attachmentId int 10  √  null
attachment.id FKC84C553456B0D1E8
ID of report file
attachment attachmentTypeId int 10  √  null
email attempts int 10  √  null
review_author authorUserId int 10
userbase.id FK2941B452966B3BC3
userbase avatarId int 10  √  null
attachment.id FK_USER_AVATAR
baseline_version baselineId int 10
baseline.id FK5F1F94DE674BC58C
documentnode baseLineId int 10  √  null
baseline.id FK_DOCUMENTNODE_BASELINE
revision baselineId int 10
baseline.id FKF074B7DB674BC58C
signature baseLineId int 10  √  null
baseline.id FK3FFD98B8674BC58C
documentfield category int 10  √  null
documenttype category int 10  √  null
lookuptype category int 10  √  null
projectfield category int 10  √  null
releasetype category int 10  √  null
changerequestassociation changeRequestItemId int 10
document.id FK8C59242A9096BB3
document childDocumentTypeId int 10  √  null
documenttype.id FK335CD11B9E94C348
jamacomment_userlikes commentId int 10
jamacomment.id FK121CEB466A869C32
integrationcomponentmapping commentsDirectionTypeId int 10  √  null
integrationdirectiontype.id FKBCFD23059A05EA8C
jamacomment commenttype int 10  √  null
commenttype.id FKECA112F417F9EB
subscription contextId int 10  √  null
subscription contextScope int 10  √  null
documenttypefielddefinition controlTypeId int 10  √  null
projecttypefield controlTypeId int 10  √  null
aclobject createdBy int 10  √  null
aclpermission createdBy int 10  √  null
aclpermissionentry createdBy int 10  √  null
attachment createdBy int 10  √  null
baseline createdBy int 10  √  null
changerequestassociation createdBy int 10  √  null
dashboard createdBy int 10  √  null
distributiongroup createdBy int 10  √  null User ID
document createdBy int 10  √  null
document_attachment createdBy int 10  √  null
document_docattach createdBy int 10  √  null
document_document createdBy int 10  √  null
document_tag createdBy int 10  √  null
document_url createdBy int 10  √  null
documentcustomfieldvalue createdBy int 10  √  null
documentfield createdBy int 10  √  null User ID
documentgroup createdBy int 10  √  null User ID
documenttype createdBy int 10  √  null
documenttypefielddefinition createdBy int 10  √  null
email createdBy int 10  √  null
estimate createdBy int 10  √  null
evententry createdBy int 10  √  null
eventtype createdBy int 10  √  null
fieldlayout createdBy int 10  √  null
fieldlayoutentry createdBy int 10  √  null
fieldlayouttype createdBy int 10  √  null
filter createdBy int 10  √  null
glossaryitem createdBy int 10  √  null
integrationcomponentmapping createdBy int 10  √  null
integrationconnection createdBy int 10  √  null
integrationdirectiontype createdBy int 10  √  null
integrationfieldmapping createdBy int 10  √  null
integrationtype createdBy int 10  √  null
itemsyncstatus createdBy int 10  √  null
itemtemplate createdBy int 10  √  null
jamaauthprovider createdBy int 10  √  null
jamacomment createdBy int 10  √  null User ID
jamatoken createdBy int 10  √  null
jamaview createdBy int 10  √  null
jobschedule createdBy int 10  √  null
license_snapshot createdBy int 10  √  null
lookup createdBy int 10  √  null
lookuptype createdBy int 10  √  null
mutedsubscription createdBy int 10  √  null
objecttype createdBy int 10  √  null
organization createdBy int 10  √  null
perspective createdBy int 10  √  null
perspective_role createdBy int 10  √  null
perspective_view createdBy int 10  √  null
perspectiveconfig createdBy int 10  √  null
perspectivetype createdBy int 10  √  null
pluginentry createdBy int 10  √  null
project createdBy int 10  √  null
projectfield createdBy int 10  √  null
projectrelease createdBy int 10  √  null
projecttype createdBy int 10  √  null
projecttypefield createdBy int 10  √  null
propertyentry createdBy int 10  √  null
relationshiptype createdBy int 10  √  null
releasetype createdBy int 10  √  null
report createdBy int 10  √  null
reportcriteria createdBy int 10  √  null
reportformat createdBy int 10  √  null
reporttype createdBy int 10  √  null
review createdBy int 10  √  null
revision createdBy int 10  √  null
revision_item createdBy int 10  √  null
revision_user createdBy int 10  √  null
revision_user_item createdBy int 10  √  null
revisionpropertyentry createdBy int 10  √  null
role createdBy int 10  √  null
signature createdBy int 10  √  null
smartfilter createdBy int 10  √  null
subscription createdBy int 10  √  null
tag createdBy int 10  √  null
testresult createdBy int 10  √  null User ID
user_job createdBy int 10  √  null
user_organization createdBy int 10  √  null
userbase createdBy int 10  √  null
userfavorite createdBy int 10  √  null
useritemviewhistory createdBy int 10  √  null
version createdBy int 10  √  null
view_itemtype createdBy int 10  √  null
viewconfig createdBy int 10  √  null
viewtype createdBy int 10  √  null
portletinstance dashboardId int 10
dashboard.id FK_PORTLETINSTANCE_DASHBOARD
documentfield dataTypeId int 10  √  null Field data type lookup
projectfield dataTypeId int 10  √  null
integrationconnection defaultContourUserId int 10  √  null
userbase.id FKB2C6BBB2845B1931
lookuptype defaultValue int 10  √  null
releasetype defaultValue int 10  √  null
attachment diagramHeight int 10  √  null
attachment diagramWidth int 10  √  null
distributiongroup_user distributionGroupId int 10
distributiongroup.id FKC89CDF0F573B620A
document_docattach docattachId int 10  √  null
document.id FKD8310F5993BB117A
document_tag document int 10  √  null
document.id FKA835BA763E4037C1
item ID
evententry document int 10  √  null
document.id FK3AFE26183E4037C1
Associated item ID
documenttypefielddefinition documentFieldId int 10
documentfield.id FK9F2566584D729212
document documentGroup int 10  √  null
documentgroup.id FK335CD11B884663C1
Related group ID
evententry documentGroup int 10  √  null
documentgroup.id FK3AFE2618884663C1
filter documentGroup int 10  √  null
documentgroup.id FKB408CB78884663C1
document_attachment documentId int 10  √  null
document.id FKFEB8AEC7DA506A1C
document ID
document_docattach documentId int 10  √  null
document.id FKD8310F59DA506A1C
document_url documentId int 10  √  null
document.id FKA835C04BDA506A1C
documentcustomfieldvalue documentId int 10  √  null
document.id FKE13A6A03DA506A1C
integrationcomponentmapping documentId int 10  √  null
document.id FKBCFD2305D766C998
jamacomment documentId int 10  √  null
document.id FKECA112F4DA506A1C
Associated artifact
version documentId int 10
document.id FK14F51CD8DA506A1C
evententry documentType int 10  √  null
documenttype.id FK3AFE2618F3ED4351
filter documentType int 10  √  null
documenttype.id FKB408CB78F3ED4351
documenttype documentTypeCategoryId int 10  √  null
documenttypecategory.id FKA83F5AD5672FE4C8
fieldlayoutentry documentTypeFieldId int 10
documenttypefielddefinition.id FKF081564E7C13C8FE
document documentTypeId int 10  √  null
documenttype.id FK335CD11BE181EF2C
documentgroup documentTypeId int 10  √  null
documenttype.id FK5EF19E44E181EF2C
documentkeylookup documentTypeId int 10  √  null
documenttype.id FK_dockeylookup_doctype
documenttypefielddefinition documentTypeId int 10  √  null
documenttype.id FK9F256658E181EF2C
fieldlayout documentTypeId int 10  √  null
documenttype.id FK3F0778A4E181EF2C
document duration int 10  √  null
estimate estimate int 10  √  null
evententry EventType int 10  √  null
eventactiontype eventTypeId int 10  √  null
evententry eventUser int 10  √  null
userbase.id FK3AFE26184D1BFDB7
Associated user ID
documentcustomfieldvalue fieldId int 10  √  null
integrationfieldmapping fieldId int 10
documentfield.id FK7FB5A268F5ECC78D
fieldlayoutentry fieldLayoutId int 10
fieldlayout.id FKF081564EA8BE6B1C
fieldlayout fieldLayoutTypeId int 10  √  null
fieldlayouttype.id FK_fieldlayout_type
documentfield fieldType int 10  √  null
attachment fileSize int 10  √  null
smartfilter filterAuthor int 10  √  null
document_document fromDocument int 10  √  null
document.id FKC5FF3FBFA9DB056B
ID of the item the link is coming from.
document globalSortOrder int 10  √  null
documentnode globalSortOrder int 10
subscription groupId int 10  √  null
role.id FK_SUBSCRIPTION_ROLE
document hibVersion int 10  √  null
aclobject id int 10  √ 
aclpermission.aclObjectId FKAF999D96BDCCF66
aclpermission id int 10  √ 
aclpermissionentry id int 10  √ 
attachment id int 10  √ 
document_attachment.attachmentId FKFEB8AEC756B0D1E8
report.attachmentId FKC84C553456B0D1E8
report.previewAttachmentId FKC84C55347CDA49B0
userbase.avatarId FK_USER_AVATAR
baseline id int 10  √ 
baseline_version.baselineId FK5F1F94DE674BC58C
documentnode.baseLineId FK_DOCUMENTNODE_BASELINE
revision.baselineId FKF074B7DB674BC58C
signature.baseLineId FK3FFD98B8674BC58C
changerequestassociation id int 10  √ 
commentstatus id int 10  √ 
jamacomment.status FKECA112F440920E7C
commenttype id int 10  √ 
jamacomment.commenttype FKECA112F417F9EB
dashboard id int 10  √ 
portletinstance.dashboardId FK_PORTLETINSTANCE_DASHBOARD
dashboardlayout id int 10  √ 
dashboard.layoutId FK_DASHBOARD_LAYOUT
distributiongroup id int 10  √ 
distributiongroup_user.distributionGroupId FKC89CDF0F573B620A
System generated unique ID
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_attachment id int 10  √  System generated unique ID
document_docattach id int 10  √ 
document_document id int 10  √  System generated unique ID
document_tag id int 10  √  System generated unique ID
document_url id int 10  √ 
documentcustomfieldvalue id int 10  √ 
documentfield id int 10  √ 
documenttypefielddefinition.documentFieldId FK9F2566584D729212
integrationfieldmapping.fieldId FK7FB5A268F5ECC78D
System generated unique ID
documentgroup id int 10  √ 
document.documentGroup FK335CD11B884663C1
evententry.documentGroup FK3AFE2618884663C1
filter.documentGroup FKB408CB78884663C1
System generated unique ID
documentkeylookup id int 10  √ 
documentnode id int 10  √ 
documentnode.parentNodeId FK_DOCUMENTNODE_PARENT
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
documenttypecategory id int 10  √ 
documenttype.documentTypeCategoryId FKA83F5AD5672FE4C8
documenttypefielddefinition id int 10  √ 
fieldlayoutentry.documentTypeFieldId FKF081564E7C13C8FE
email id int 10  √ 
estimate id int 10  √ 
eventactiontype id int 10  √ 
evententry id int 10  √ 
eventtype id int 10  √ 
fieldlayout id int 10  √ 
fieldlayoutentry.fieldLayoutId FKF081564EA8BE6B1C
fieldlayoutentry id int 10  √ 
fieldlayouttype id int 10  √ 
fieldlayout.fieldLayoutTypeId FK_fieldlayout_type
filter id int 10  √ 
glossaryitem id int 10  √ 
integrationcomponentmapping id int 10  √ 
integrationcomponentmapping.relatedMappingId FK_MAPPING_MAPPING
integrationfieldmapping.setMappingId FK7FB5A268BF0C02E5
integrationconnection id int 10  √ 
integrationdirectiontype id int 10  √ 
integrationcomponentmapping.commentsDirectionTypeId FKBCFD23059A05EA8C
integrationfieldmapping.updateDirectionTypeId FK7FB5A268917BEB17
integrationfieldmapping id int 10  √ 
integrationtype id int 10  √ 
integrationcomponentmapping.integrationTypeId FKBCFD23057EF490F0
integrationconnection.integrationTypeId FKB2C6BBB27EF490F0
integrationfieldmapping.integrationTypeId FK7FB5A2687EF490F0
itemsyncstatus id int 10
document_document.itemSyncStatus FK_DOCDOC_ITEMSYNCSTATUS
itemtemplate id int 10  √ 
jamaauthprovider id int 10  √ 
jamacomment id int 10  √ 
jamacomment_userlikes.commentId FK121CEB466A869C32
System generated unique Id
jamatoken id int 10  √ 
tokenattributes.tokenId FK_ATTRIBUTE_TOKEN
jamaview id int 10  √ 
fieldlayout.viewId FK3F0778A41A80FDAC
jamaview.stereotypeId FKCE07663057893EF9
perspective_view.viewId FK4FA3BEC81A80FDAC
view_itemtype.viewId FKB04369271A80FDAC
viewconfig.viewId FKAC076E271A80FDAC
jobschedule id int 10  √ 
user_job.job FKF022D94934453ACA
license_snapshot id int 10  √ 
license_snapshot_properties.licenseSnapshotId FK_PROPERTY_LICENSE_SNAPSHOT
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
lookuptype id int 10  √ 
lookup.lookupTypeId FKBE9BA97A8CB30AEA
mutedsubscription id int 10  √ 
objecttype id int 10  √ 
organization id int 10  √ 
attachment.organizationId FK8AF75923B2808048
distributiongroup.organizationId FK3C591A7BB2808048
evententry.organization FK3AFE26183006F3ED
project.organizationId FKED904B19B2808048
user_organization.organizationId FK3622D27B2808048
userbase.organization FKF024151C3006F3ED
perspective id int 10  √ 
perspective.stereotypeId FKC653A3C1E06C7A2
perspective_role.perspectiveId FK4FA2049999AAFC2C
perspective_view.perspectiveId FK4FA3BEC899AAFC2C
perspectiveconfig.perspectiveId FKAB47207E99AAFC2C
perspective_role id int 10  √ 
perspective_view id int 10  √ 
perspectiveconfig id int 10  √ 
perspectivetype id int 10  √ 
perspective.perspectiveTypeId FKC653A3CAA82B7C0
pluginentry id int 10  √ 
portlet id int 10  √ 
portletinstance.portletId FK_PORTLETINSTANCE_PORTLET
portletinstance id int 10  √ 
portletinstanceproperties.portletInstanceId FK_PROPERTY_PORTLETINSTANCE
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
projectfield id int 10  √ 
projecttypefield.projectFieldId FKD312A70764B111EF
projectrelease id int 10  √ 
document.release1Id FK335CD11B718FC1C5
document.release2Id FK335CD11B718FC586
document.releaseId FK335CD11BD1554582
System generated unique ID
projecttype id int 10  √ 
project.projectTypeId FKED904B19B0B57FAF
projecttypefield.projectTypeId FKD312A707B0B57FAF
projecttypefield id int 10  √ 
propertyentry id int 10  √ 
relationshiptype id int 10  √ 
document_document.relationshipType FKC5FF3FBF45B2C50B
releasetype id int 10  √ 
projectrelease.releaseTypeId FKE93DECE69C6616
report id int 10  √ 
report_criterion.reportId FKC53D6D56166CC54A
report_reportformat.reportId FK5EEEBF56166CC54A
reportcriteria.reportId FK767C093166CC54A
System generated unique ID
reportcriteria id int 10  √ 
reportformat id int 10  √ 
report_reportformat.reportFormatId FK5EEEBF56604E6058
reporttype id int 10  √ 
report.reportTypeId FKC84C5534F0DEC1DE
review id int 10  √ 
review_author.reviewId FK2941B4523C551562
revision.reviewId FKF074B7DB3C551562
revision id int 10  √ 
revision_item.revisionId FKFA072CF7928CF7E8
revision_user.revisionId FKFA0C9DAF928CF7E8
revisionpropertyentry.revisionId FKF377ABC2928CF7E8
revision_item id int 10  √ 
revision_user_item.revisionItemId FK8659CBA3F4E6E0A9
revision_user id int 10  √ 
revision_user_item.revisionUserId FK8659CBA39587419
revision_user_item id int 10  √ 
revisionpropertyentry id int 10  √ 
revisionstatus id int 10  √ 
revision.status FKF074B7DBA8BABC36
revisionuseritemstatus id int 10  √ 
revision_user_item.status FK8659CBA3ED279D54
role id int 10  √ 
aclpermission.roleId FKAF999D91403590E
perspective_role.roleId FK4FA204991403590E
subscription.groupId FK_SUBSCRIPTION_ROLE
user_role.roleId FK143BF46A1403590E
signature id int 10  √ 
smartfilter id int 10  √ 
stepitem id int 10  √ 
subscription id int 10  √ 
mutedsubscription.subscriptionId FK_MUTEDSUB_SUBSCRIPTION
tag id int 10  √ 
document_tag.tag FKA835BA76868B9321
testcasestatus id int 10  √ 
document.testCaseStatusId FK_TESTCASE_TCSTATUS
testresult id int 10  √  System generated unique ID
testrunset id int 10  √ 
document.testRunSetId FK_TESTRUN_TESTRUNSET
testrunstatus id int 10  √ 
document.testRunStatusId FK_TESTRUN_TESTRUNSTATUS
stepitem.testRunStatusId FK_TRSTEP_TESTRUNSTATUS
testset id int 10  √ 
testsetcase.testSetId FK_TESTSETCASE_TESTSET
testsetcase id int 10  √ 
user_job id int 10  √ 
user_organization id int 10  √ 
userbase id int 10  √ 
aclpermission.userId FKAF999D91958AE78
distributiongroup_user.userId FKC89CDF0F1958AE78
document.assignedToId FK_TESTRUN_USER
document.lockedBy FK335CD11BBD032133
document.user1Id FK335CD11B4267BDB3
document.user2Id FK335CD11B4267C174
email.userId FK5C24B9C1958AE78
evententry.eventUser FK3AFE26184D1BFDB7
integrationconnection.defaultContourUserId FKB2C6BBB2845B1931
jamacomment.userId FKECA112F41958AE78
jamacomment_userlikes.userId FK121CEB461958AE78
mutedsubscription.subscriberId FK_MUTEDSUB_USER
project.projectManager FKED904B194A8942C6
project.user1Id FKED904B194267BDB3
project.user2Id FKED904B194267C174
review_author.authorUserId FK2941B452966B3BC3
revision_user.userId FKFA0C9DAF1958AE78
signature.userId FK3FFD98B81958AE78
subscription.subscribedBy FK_SUBSCRIPTION_SUBSCRIBEDBY
subscription.userId FK_SUBSCRIPTION_USER
testrunset.assignedToId FK_TESTRUNSET_USER
testset.assignedToId FK_TESTSET_ASSIGNEDTO
user_job.userId FKF022D9491958AE78
user_organization.userId FK3622D271958AE78
user_role.userId FK143BF46A1958AE78
userfavorite.userId FKD01BA671958AE78
useritemviewhistory.userId FKF9A8E6311958AE78
userlogentry.userId FK46B8C0791958AE78
System generated unique ID
userfavorite id int 10  √ 
useritemviewhistory id int 10  √ 
userlogentry id int 10  √ 
version id int 10  √ 
baseline_version.versionId FK5F1F94DE4C133EE4
changerequestassociation.versionEndId FK8C592429A27E04F
changerequestassociation.versionStartId FK8C59242D32E6C16
revision_item.versionId FKFA072CF74C133EE4
view_itemtype id int 10  √ 
viewconfig id int 10  √ 
viewtype id int 10  √ 
jamaview.viewTypeId FKCE076630E57BF940
document indent int 10  √  null Calculated value to represent the indentation level when representing data in an outline structure
integrationcomponentmapping integrationTypeId int 10
integrationtype.id FKBCFD23057EF490F0
integrationconnection integrationTypeId int 10
integrationtype.id FKB2C6BBB27EF490F0
integrationfieldmapping integrationTypeId int 10
integrationtype.id FK7FB5A2687EF490F0
integrationconnection intervalMinutes int 10  √  null
document_document itemSyncStatus int 10  √  null
itemsyncstatus.id FK_DOCDOC_ITEMSYNCSTATUS
view_itemtype itemTypeId int 10  √  null
user_job job int 10  √  null
jobschedule.id FKF022D94934453ACA
dashboard layoutId int 10
dashboardlayout.id FK_DASHBOARD_LAYOUT
fieldlayoutentry layoutPosition int 10  √  null
organization licenseMessage int 10  √  null
license_snapshot_properties licenseSnapshotId int 10
license_snapshot.id FK_PROPERTY_LICENSE_SNAPSHOT
document lockedBy int 10  √  null
userbase.id FK335CD11BBD032133
userlogentry loginCode int 10  √  null
userlogentry logoutCode int 10  √  null
document lookup10Id int 10  √  null
lookup.id FK335CD11B739D9835
document lookup1Id int 10  √  null
lookup.id FK335CD11B6AC02593
project lookup1Id int 10  √  null
lookup.id FKED904B196AC02593
document lookup2Id int 10  √  null
lookup.id FK335CD11B6AC02954
project lookup2Id int 10  √  null
lookup.id FKED904B196AC02954
document lookup3Id int 10  √  null
lookup.id FK335CD11B6AC02D15
project lookup3Id int 10  √  null
lookup.id FKED904B196AC02D15
document lookup4Id int 10  √  null
lookup.id FK335CD11B6AC030D6
project lookup4Id int 10  √  null
lookup.id FKED904B196AC030D6
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
estimate lookupId int 10  √  null
lookup.id FK8B302528AC877456
documenttypefielddefinition lookupTypeId int 10  √  null
lookup lookupTypeId int 10
lookuptype.id FKBE9BA97A8CB30AEA
Associated lookup list
projecttypefield lookupTypeId int 10  √  null
aclpermission mask int 10
aclobject modifiedBy int 10  √  null
aclpermission modifiedBy int 10  √  null
aclpermissionentry modifiedBy int 10  √  null
attachment modifiedBy int 10  √  null
baseline modifiedBy int 10  √  null
changerequestassociation modifiedBy int 10  √  null
dashboard modifiedBy int 10  √  null
distributiongroup modifiedBy int 10  √  null User ID
document modifiedBy int 10  √  null
document_attachment modifiedBy int 10  √  null
document_docattach modifiedBy int 10  √  null
document_document modifiedBy int 10  √  null
document_tag modifiedBy int 10  √  null
document_url modifiedBy int 10  √  null
documentcustomfieldvalue modifiedBy int 10  √  null
documentfield modifiedBy int 10  √  null
documentgroup modifiedBy int 10  √  null User ID
documenttype modifiedBy int 10  √  null
documenttypefielddefinition modifiedBy int 10  √  null
email modifiedBy int 10  √  null
estimate modifiedBy int 10  √  null
evententry modifiedBy int 10  √  null
eventtype modifiedBy int 10  √  null
fieldlayout modifiedBy int 10  √  null
fieldlayoutentry modifiedBy int 10  √  null
fieldlayouttype modifiedBy int 10  √  null
filter modifiedBy int 10  √  null
glossaryitem modifiedBy int 10  √  null
integrationcomponentmapping modifiedBy int 10  √  null
integrationconnection modifiedBy int 10  √  null
integrationdirectiontype modifiedBy int 10  √  null
integrationfieldmapping modifiedBy int 10  √  null
integrationtype modifiedBy int 10  √  null
itemsyncstatus modifiedBy int 10  √  null
itemtemplate modifiedBy int 10  √  null
jamaauthprovider modifiedBy int 10  √  null
jamacomment modifiedBy int 10  √  null User ID
jamatoken modifiedBy int 10  √  null
jamaview modifiedBy int 10  √  null
jobschedule modifiedBy int 10  √  null
license_snapshot modifiedBy int 10  √  null
lookup modifiedBy int 10  √  null
lookuptype modifiedBy int 10  √  null
mutedsubscription modifiedBy int 10  √  null
objecttype modifiedBy int 10  √  null
organization modifiedBy int 10  √  null
perspective modifiedBy int 10  √  null
perspective_role modifiedBy int 10  √  null
perspective_view modifiedBy int 10  √  null
perspectiveconfig modifiedBy int 10  √  null
perspectivetype modifiedBy int 10  √  null
pluginentry modifiedBy int 10  √  null
project modifiedBy int 10  √  null
projectfield modifiedBy int 10  √  null
projectrelease modifiedBy int 10  √  null
projecttype modifiedBy int 10  √  null
projecttypefield modifiedBy int 10  √  null
propertyentry modifiedBy int 10  √  null
relationshiptype modifiedBy int 10  √  null
releasetype modifiedBy int 10  √  null
report modifiedBy int 10  √  null
reportcriteria modifiedBy int 10  √  null
reportformat modifiedBy int 10  √  null
reporttype modifiedBy int 10  √  null
review modifiedBy int 10  √  null
revision modifiedBy int 10  √  null
revision_item modifiedBy int 10  √  null
revision_user modifiedBy int 10  √  null
revision_user_item modifiedBy int 10  √  null
revisionpropertyentry modifiedBy int 10  √  null
role modifiedBy int 10  √  null
signature modifiedBy int 10  √  null
smartfilter modifiedBy int 10  √  null
subscription modifiedBy int 10  √  null
tag modifiedBy int 10  √  null
testresult modifiedBy int 10  √  null User ID
user_job modifiedBy int 10  √  null
user_organization modifiedBy int 10  √  null
userbase modifiedBy int 10  √  null
userfavorite modifiedBy int 10  √  null
useritemviewhistory modifiedBy int 10  √  null
version modifiedBy int 10  √  null
view_itemtype modifiedBy int 10  √  null
viewconfig modifiedBy int 10  √  null
viewtype modifiedBy int 10  √  null
revision numVotesPerUser int 10  √  null
aclpermissionentry objectId int 10  √  null
evententry objectId int 10  √  null
aclpermissionentry objectType int 10  √  null
evententry objectType int 10  √  null
eventactiontype objectTypeId int 10  √  null
evententry organization int 10  √  null
organization.id FK3AFE26183006F3ED
userbase organization int 10  √  null
organization.id FKF024151C3006F3ED
aclobject organizationId int 10  √  null
aclpermission organizationId int 10  √  null
aclpermissionentry organizationId int 10  √  null
attachment organizationId int 10  √  null
organization.id FK8AF75923B2808048
baseline organizationId int 10  √  null
changerequestassociation organizationId int 10  √  null
commentstatus organizationId int 10  √  null
commenttype organizationId int 10  √  null
dashboard organizationId int 10  √  null
dashboardlayout organizationId int 10  √  null
distributiongroup organizationId int 10  √  null
organization.id FK3C591A7BB2808048
Associated organization ID
document organizationId int 10  √  null
document_attachment organizationId int 10  √  null
document_docattach organizationId int 10  √  null
document_document organizationId int 10  √  null
document_tag organizationId int 10  √  null
document_url organizationId int 10  √  null
documentcustomfieldvalue organizationId int 10  √  null
documentfield organizationId int 10  √  null
documentgroup organizationId int 10  √  null
documentkeylookup organizationId int 10  √  null
documentnode organizationId int 10  √  null
documenttype organizationId int 10  √  null
documenttypecategory organizationId int 10  √  null
documenttypefielddefinition organizationId int 10  √  null
email organizationId int 10  √  null
estimate organizationId int 10  √  null
eventactiontype organizationId int 10  √  null
eventtype organizationId int 10  √  null
fieldlayout organizationId int 10  √  null
fieldlayoutentry organizationId int 10  √  null
fieldlayouttype organizationId int 10  √  null
filter organizationId int 10  √  null
glossaryitem organizationId int 10  √  null
integrationcomponentmapping organizationId int 10  √  null
integrationconnection organizationId int 10  √  null
integrationdirectiontype organizationId int 10  √  null
integrationfieldmapping organizationId int 10  √  null
integrationtype organizationId int 10  √  null
itemsyncstatus organizationId int 10  √  null
itemtemplate organizationId int 10  √  null
jamaauthprovider organizationId int 10  √  null
jamacomment organizationId int 10  √  null
jamatoken organizationId int 10  √  null
jamaview organizationId int 10  √  null
jobschedule organizationId int 10  √  null
license_snapshot organizationId int 10
lookup organizationId int 10  √  null
lookuptype organizationId int 10  √  null
mutedsubscription organizationId int 10  √  null
objecttype organizationId int 10  √  null
perspective organizationId int 10  √  null
perspective_role organizationId int 10  √  null
perspective_view organizationId int 10  √  null
perspectiveconfig organizationId int 10  √  null
perspectivetype organizationId int 10  √  null
pluginentry organizationId int 10  √  null
portlet organizationId int 10  √  null
portletinstance organizationId int 10  √  null
project organizationId int 10
organization.id FKED904B19B2808048
Associated organization
projectfield organizationId int 10  √  null
projectrelease organizationId int 10  √  null
projecttype organizationId int 10  √  null
projecttypefield organizationId int 10  √  null
propertyentry organizationId int 10  √  null
relationshiptype organizationId int 10  √  null
releasetype organizationId int 10  √  null
report organizationId int 10  √  null
reportcriteria organizationId int 10  √  null
reportformat organizationId int 10  √  null
reporttype organizationId int 10  √  null
review organizationId int 10  √  null
revision organizationId int 10  √  null
revision_item organizationId int 10  √  null
revision_user organizationId int 10  √  null
revision_user_item organizationId int 10  √  null
revisionpropertyentry organizationId int 10  √  null
revisionstatus organizationId int 10  √  null
revisionuseritemstatus organizationId int 10  √  null
role organizationId int 10  √  null Associated Organization
signature organizationId int 10  √  null
smartfilter organizationId int 10  √  null
stepitem organizationId int 10  √  null
subscription organizationId int 10  √  null
tag organizationId int 10  √  null
testcasestatus organizationId int 10  √  null
testresult organizationId int 10  √  null
testrunset organizationId int 10  √  null
testrunstatus organizationId int 10  √  null
testset organizationId int 10  √  null
testsetcase organizationId int 10  √  null
user_job organizationId int 10  √  null
user_organization organizationId int 10
organization.id FK3622D27B2808048
userfavorite organizationId int 10  √  null
useritemviewhistory organizationId int 10  √  null
userlogentry organizationId int 10  √  null
version organizationId int 10  √  null
view_itemtype organizationId int 10  √  null
viewconfig organizationId int 10  √  null
viewtype organizationId int 10  √  null
document originalEstimate int 10  √  null Original estimate for an item - typically in hours
version originDocumentId int 10
document.id FK14F51CD86915E1C2
aclobject parentAclObjectId int 10  √  null
evententry parentEventEntryId int 10  √  null
document parentId int 10  √  null ID of the parent item as configured in the tree view
jamacomment parentId int 10  √  null
project parentId int 10  √  null
documentnode parentNodeId int 10  √  null
documentnode.id FK_DOCUMENTNODE_PARENT
userbase passwordAttempts int 10  √  null
aclpermissionentry permissionType int 10  √  null
perspective_role perspectiveId int 10
perspective.id FK4FA2049999AAFC2C
perspective_view perspectiveId int 10
perspective.id FK4FA3BEC899AAFC2C
perspectiveconfig perspectiveId int 10
perspective.id FKAB47207E99AAFC2C
perspective perspectiveTypeId int 10
perspectivetype.id FKC653A3CAA82B7C0
pluginentry pluginType int 10  √  null
portletinstance portletId int 10
portlet.id FK_PORTLETINSTANCE_PORTLET
portletinstanceproperties portletInstanceId int 10
portletinstance.id FK_PROPERTY_PORTLETINSTANCE
report previewAttachmentId int 10  √  null
attachment.id FKC84C55347CDA49B0
document priorityId int 10  √  null
lookup.id FK335CD11B6080E200
Associated Priority ID
evententry project int 10  √  null
project.id FK3AFE2618858B68C0
Associated Project ID
projecttypefield projectFieldId int 10
projectfield.id FKD312A70764B111EF
project projectGroupLookupId int 10  √  null
lookup.id FKED904B19C82FC15C
Associated project group
attachment projectId int 10  √  null
project.id FK8AF7592362A5139B
baseline projectId int 10
project.id FK996EE64562A5139B
distributiongroup projectId int 10
project.id FK3C591A7B62A5139B
Associated project ID
document projectId int 10
project.id FK335CD11B62A5139B
related Project ID
documentgroup projectId int 10  √  null
project.id FK5EF19E4462A5139B
documentkeylookup projectId int 10  √  null
project.id FK_dockeylookup_project
glossaryitem projectId int 10
project.id FKEE51863162A5139B
integrationcomponentmapping projectId int 10  √  null
perspectiveconfig projectId int 10  √  null
project.id FKAB47207E62A5139B
review projectId int 10
project.id FKC84EF75862A5139B
role projectId int 10  √  null
viewconfig projectId int 10  √  null
project.id FKAC076E2762A5139B
project projectManager int 10  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
project projectTypeId int 10  √  null
projecttype.id FKED904B19B0B57FAF
projecttypefield projectTypeId int 10  √  null
projecttype.id FKD312A707B0B57FAF
propertyentry propertyType int 10  √  null
revisionpropertyentry propertyType int 10  √  null
integrationcomponentmapping pullIntoContourFilter int 10  √  null
baseline refId int 10  √  null
dashboard refId int 10  √  null
documentfield refId int 10  √  null
documentnode refId int 10
documenttype refId int 10  √  null
fieldlayout refId int 10  √  null
filter refId int 10  √  null
integrationcomponentmapping refId int 10
integrationconnection refId int 10
itemtemplate refId int 10  √  null
jamacomment refId int 10  √  null
jamaview refId int 10  √  null
lookuptype refId int 10  √  null
perspective refId int 10  √  null
perspectiveconfig refId int 10  √  null
pluginentry refId int 10  √  null
projectfield refId int 10  √  null
projecttype refId int 10  √  null
propertyentry refId int 10  √  null
relationshiptype refId int 10  √  null
releasetype refId int 10  √  null
report refId int 10  √  null
signature refId int 10  √  null
smartfilter refId int 10  √  null
subscription refId int 10  √  null
tag refId int 10  √  null ID related to scope
userfavorite refId int 10  √  null
useritemviewhistory refId int 10  √  null
view_itemtype refId int 10  √  null
viewconfig refId int 10  √  null
integrationcomponentmapping relatedMappingId int 10  √  null
integrationcomponentmapping.id FK_MAPPING_MAPPING
document_document relationshipType int 10  √  null
relationshiptype.id FKC5FF3FBF45B2C50B
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
projectrelease releaseTypeId int 10
releasetype.id FKE93DECE69C6616
Associated release type lookup
document remainingEstimate int 10  √  null Units remaining - typically in hours
report_reportformat reportFormatId int 10
reportformat.id FK5EEEBF56604E6058
report_criterion reportId int 10
report.id FKC53D6D56166CC54A
report_reportformat reportId int 10
report.id FK5EEEBF56166CC54A
reportcriteria reportId int 10  √  null
report.id FK767C093166CC54A
report reportTypeId int 10  √  null
reporttype.id FKC84C5534F0DEC1DE
review_author reviewId int 10
review.id FK2941B4523C551562
revision reviewId int 10
review.id FKF074B7DB3C551562
revision_item revisionId int 10
revision.id FKFA072CF7928CF7E8
revision_user revisionId int 10
revision.id FKFA0C9DAF928CF7E8
revisionpropertyentry revisionId int 10
revision.id FKF377ABC2928CF7E8
revision_user_item revisionItemId int 10
revision_item.id FK8659CBA3F4E6E0A9
revision_user_item revisionUserId int 10
revision_user.id FK8659CBA39587419
aclpermission roleId int 10  √  null
role.id FKAF999D91403590E
perspective_role roleId int 10  √  null
role.id FK4FA204991403590E
user_role roleId int 10
role.id FK143BF46A1403590E
Role ID
documentfield scope int 10  √  null 1 = Organization
documenttype scope int 10  √  null
fieldlayout scope int 10  √  null
filter scope int 10  √  null
integrationcomponentmapping scope int 10
integrationconnection scope int 10
jamaview scope int 10  √  null
lookuptype scope int 10  √  null
perspective scope int 10  √  null
perspectiveconfig scope int 10  √  null
pluginentry scope int 10  √  null
projectfield scope int 10  √  null
projecttype scope int 10  √  null
propertyentry scope int 10  √  null
relationshiptype scope int 10  √  null
releasetype scope int 10  √  null
report scope int 10  √  null
subscription scope int 10  √  null
tag scope int 10  √  null
view_itemtype scope int 10  √  null
viewconfig scope int 10  √  null
baseline scopeId int 10  √  null
dashboard scopeId int 10  √  null
documentnode scopeId int 10
itemtemplate scopeId int 10  √  null
jamacomment scopeId int 10  √  null
signature scopeId int 10  √  null
smartfilter scopeId int 10  √  null
userfavorite scopeId int 10  √  null
useritemviewhistory scopeId int 10  √  null
documentkeylookup sequence int 10  √  null
review sequence int 10
revision sequence int 10  √  null
documentgroup sequenceNumber int 10  √  null Numerical value to start with when generating unique item keys
integrationfieldmapping setMappingId int 10
integrationcomponentmapping.id FK7FB5A268BF0C02E5
aclpermissionentry sid int 10  √  null
aclpermissionentry sidType int 10  √  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
documentgroup sortOrder int 10  √  null Order relative to peers
documentnode sortOrder int 10
documenttypefielddefinition sortOrder int 10  √  null
eventactiontype sortOrder int 10  √  null
eventtype sortOrder int 10  √  null
itemsyncstatus sortOrder int 10  √  null
lookup sortOrder int 10  √  null list order
objecttype sortOrder int 10  √  null
perspective_role sortOrder int 10  √  null
perspective_view sortOrder int 10  √  null
projectrelease sortOrder int 10  √  null Order of item
projecttypefield sortOrder int 10  √  null
relationshiptype sortOrder int 10  √  null
testrunset sortOrder int 10  √  null
testset sortOrder int 10
testsetcase sortOrder int 10
view_itemtype sortOrder int 10  √  null
documenttypefielddefinition sortOrderInList int 10  √  null
projecttypefield sortOrderInList int 10  √  null
document_document status int 10  √  null
lookup.id FKC5FF3FBFF0FE0433
jamacomment status int 10  √  null
commentstatus.id FKECA112F440920E7C
revision status int 10  √  null
revisionstatus.id FKF074B7DBA8BABC36
revision_user_item status int 10  √  null
revisionuseritemstatus.id FK8659CBA3ED279D54
document statusId int 10  √  null
lookup.id FK335CD11B74C9DCCE
Associated status ID
project statusId int 10  √  null
lookup.id FKED904B1974C9DCCE
Status lookup
stepitem stepindex int 10  √  null
jamaview stereotypeId int 10  √  null
jamaview.id FKCE07663057893EF9
perspective stereotypeId int 10  √  null
perspective.id FKC653A3C1E06C7A2
subscription subscribedBy int 10  √  null
userbase.id FK_SUBSCRIPTION_SUBSCRIBEDBY
mutedsubscription subscriberId int 10
userbase.id FK_MUTEDSUB_USER
mutedsubscription subscriptionId int 10
subscription.id FK_MUTEDSUB_SUBSCRIPTION
document_tag tag int 10  √  null
tag.id FKA835BA76868B9321
tag ID
integrationcomponentmapping targetDocumentId int 10  √  null
document.id FKBCFD230525D539E9
document testCaseId int 10  √  null
document.id FK_TESTRUN_TESTCASE
stepitem testCaseId int 10  √  null
document.id FK_TESTCASESTEP_TESTCASE
testresult testCaseId int 10  √  null
document.id FK9B0ED72F8C20F203
Associated test case ID
testsetcase testCaseId int 10  √  null
document.id FK_TESTSETCASE_TESTCASE
document testCaseStatusId int 10  √  null
testcasestatus.id FK_TESTCASE_TCSTATUS
testresult testConfiguration int 10  √  null
lookup.id FK9B0ED72FDAF8E1E5
Associated lookup list
testrunset testCycleId int 10
document.id FK_TESTRUNSET_TESTCYCLE
document testPlanId int 10  √  null
document.id FK_TESTCYCLE_TESTPLAN
testset testPlanId int 10  √  null
document.id FK_TESTSET_TESTPLAN
stepitem testRunId int 10  √  null
document.id FK_TESTRUNSTEP_TESTRUN
document testRunSetId int 10  √  null
testrunset.id FK_TESTRUN_TESTRUNSET
document testRunStatusId int 10  √  null
testrunstatus.id FK_TESTRUN_TESTRUNSTATUS
stepitem testRunStatusId int 10  √  null
testrunstatus.id FK_TRSTEP_TESTRUNSTATUS
testrunset testSetId int 10  √  null
testsetcase testSetId int 10  √  null
testset.id FK_TESTSETCASE_TESTSET
jamacomment threadId int 10  √  null
document timeSpent int 10  √  null Actual time spent - typically in hours
useritemviewhistory timesViewed int 10  √  null
document_document toDocument int 10  √  null
document.id FKC5FF3FBF39339B3C
ID of the item the link is pointing to
tokenattributes tokenId int 10
jamatoken.id FK_ATTRIBUTE_TOKEN
jamatoken tokenType int 10  √  null
lookuptype type int 10  √  null
integrationfieldmapping updateDirectionTypeId int 10  √  null
integrationdirectiontype.id FK7FB5A268917BEB17
document user1Id int 10  √  null
userbase.id FK335CD11B4267BDB3
project user1Id int 10  √  null
userbase.id FKED904B194267BDB3
document user2Id int 10  √  null
userbase.id FK335CD11B4267C174
project user2Id int 10  √  null
userbase.id FKED904B194267C174
aclpermission userId int 10  √  null
userbase.id FKAF999D91958AE78
distributiongroup_user userId int 10
userbase.id FKC89CDF0F1958AE78
email userId int 10  √  null
userbase.id FK5C24B9C1958AE78
jamacomment userId int 10  √  null
userbase.id FKECA112F41958AE78
User Id
jamacomment_userlikes userId int 10
userbase.id FK121CEB461958AE78
revision_user userId int 10
userbase.id FKFA0C9DAF1958AE78
signature userId int 10
userbase.id FK3FFD98B81958AE78
subscription userId int 10  √  null
userbase.id FK_SUBSCRIPTION_USER
user_job userId int 10  √  null
userbase.id FKF022D9491958AE78
user_organization userId int 10
userbase.id FK3622D271958AE78
user_role userId int 10
userbase.id FK143BF46A1958AE78
User ID
userfavorite userId int 10  √  null
userbase.id FKD01BA671958AE78
useritemviewhistory userId int 10  √  null
userbase.id FKF9A8E6311958AE78
userlogentry userId int 10  √  null
userbase.id FK46B8C0791958AE78
changerequestassociation versionEndId int 10  √  null
version.id FK8C592429A27E04F
baseline_version versionId int 10
version.id FK5F1F94DE4C133EE4
revision_item versionId int 10
version.id FKFA072CF74C133EE4
changerequestassociation versionStartId int 10  √  null
version.id FK8C59242D32E6C16
fieldlayout viewId int 10  √  null
jamaview.id FK3F0778A41A80FDAC
perspective_view viewId int 10
jamaview.id FK4FA3BEC81A80FDAC
view_itemtype viewId int 10
jamaview.id FKB04369271A80FDAC
viewconfig viewId int 10
jamaview.id FKAC076E271A80FDAC
jamaview viewTypeId int 10
viewtype.id FKCE076630E57BF940
revision_user_item vote int 10  √  null
document xprojectLinkId int 10  √  null Reference to a linked item from another project.
aclobject createdDate datetime 19  √  null
aclpermission createdDate datetime 19  √  null
aclpermissionentry createdDate datetime 19  √  null
attachment createdDate datetime 19  √  null
baseline createdDate datetime 19  √  null
changerequestassociation createdDate datetime 19  √  null
dashboard createdDate datetime 19  √  null
distributiongroup createdDate datetime 19  √  null
document createdDate datetime 19  √  null
document_attachment createdDate datetime 19  √  null
document_docattach createdDate datetime 19  √  null
document_document createdDate datetime 19  √  null
document_tag createdDate datetime 19  √  null
document_url createdDate datetime 19  √  null
documentcustomfieldvalue createdDate datetime 19  √  null
documentfield createdDate datetime 19  √  null
documentgroup createdDate datetime 19  √  null