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
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
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
c3p0_connection_test_table a char 1  √  null
aclpermission aclObjectId int 10  √  null
aclobject.id FKAF999D96BDCCF66
evententry action varchar 255  √  null
stepitem action varchar 4000  √  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
userlogentry actualLicenseType varchar 255  √  null
document actualResults longtext 2147483647  √  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
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
tokenattributes attributeName varchar 255
tokenattributes attributeValue longtext 2147483647  √  null
review_author authorUserId int 10
userbase.id FK2941B452966B3BC3
userbase autoFollowCommentedItems char 1  √  null
userbase avatarId int 10  √  null
attachment.id FK_USER_AVATAR
jamaauthprovider baseDn longtext 2147483647  √  null
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
organization baseUrl varchar 255  √  null
jamaauthprovider bindDn longtext 2147483647  √  null
jamaauthprovider bindPassword longtext 2147483647  √  null
perspective canOverride char 1  √  null
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 changeRequestComment longtext 2147483647  √  null
changerequestassociation changeRequestItemId int 10
document.id FK8C59242A9096BB3
document childDocumentTypeId int 10  √  null
documenttype.id FK335CD11B9E94C348
organization closed char 1  √  null
fieldlayouttype code varchar 31  √  null
lookup color varchar 255  √  null
testcasestatus color varchar 255  √  null
testrunstatus color varchar 255  √  null
jamacomment_userlikes commentId int 10
jamacomment.id FK121CEB466A869C32
evententry comments longtext 2147483647  √  null
signature comments longtext 2147483647  √  null
version comments longtext 2147483647  √  null
integrationcomponentmapping commentsDirectionTypeId int 10  √  null
integrationdirectiontype.id FKBCFD23059A05EA8C
jamacomment commentText longtext 2147483647  √  null Comment text
jamacomment commenttype int 10  √  null
commenttype.id FKECA112F417F9EB
documenttype components longtext 2147483647  √  null
projecttype components longtext 2147483647  √  null
perspectiveconfig config longtext 2147483647  √  null
viewconfig config longtext 2147483647  √  null
itemtemplate content longtext 2147483647  √  null
reportformat contentType varchar 255  √  null
subscription contextId int 10  √  null
subscription contextScope int 10  √  null
report contextSensitive char 1  √  null
documenttypefielddefinition controlStyle longtext 2147483647  √  null
projecttypefield controlStyle longtext 2147483647  √  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
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
documenttype createdDate datetime 19  √  null
documenttypefielddefinition createdDate datetime 19  √  null
email createdDate datetime 19  √  null
estimate createdDate datetime 19  √  null
evententry createdDate datetime 19  √  null
eventtype createdDate datetime 19  √  null
fieldlayout createdDate datetime 19  √  null
fieldlayoutentry createdDate datetime 19  √  null
fieldlayouttype createdDate datetime 19  √  null
filter createdDate datetime 19  √  null
glossaryitem createdDate datetime 19  √  null
integrationcomponentmapping createdDate datetime 19  √  null
integrationconnection createdDate datetime 19  √  null
integrationdirectiontype createdDate datetime 19  √  null
integrationfieldmapping createdDate datetime 19  √  null
integrationtype createdDate datetime 19  √  null
itemsyncstatus createdDate datetime 19  √  null
itemtemplate createdDate datetime 19  √  null
jamaauthprovider createdDate datetime 19  √  null
jamacomment createdDate datetime 19  √  null
jamatoken createdDate datetime 19  √  null
jamaview createdDate datetime 19  √  null
jobschedule createdDate datetime 19  √  null
license_snapshot createdDate datetime 19  √  null
lookup createdDate datetime 19  √  null
lookuptype createdDate datetime 19  √  null
mutedsubscription createdDate datetime 19  √  null
objecttype createdDate datetime 19  √  null
organization createdDate datetime 19  √  null
perspective createdDate datetime 19  √  null
perspective_role createdDate datetime 19  √  null
perspective_view createdDate datetime 19  √  null
perspectiveconfig createdDate datetime 19  √  null
perspectivetype createdDate datetime 19  √  null
pluginentry createdDate datetime 19  √  null
project createdDate datetime 19  √  null
projectfield createdDate datetime 19  √  null
projectrelease createdDate datetime 19  √  null
projecttype createdDate datetime 19  √  null
projecttypefield createdDate datetime 19  √  null
propertyentry createdDate datetime 19  √  null
relationshiptype createdDate datetime 19  √  null
releasetype createdDate datetime 19  √  null
report createdDate datetime 19  √  null
reportcriteria createdDate datetime 19  √  null
reportformat createdDate datetime 19  √  null
reporttype createdDate datetime 19  √  null
review createdDate datetime 19  √  null
revision createdDate datetime 19  √  null
revision_item createdDate datetime 19  √  null
revision_user createdDate datetime 19  √  null
revision_user_item createdDate datetime 19  √  null
revisionpropertyentry createdDate datetime 19  √  null
role createdDate datetime 19  √  null
signature createdDate datetime 19  √  null
smartfilter createdDate datetime 19  √  null
subscription createdDate datetime 19  √  null
tag createdDate datetime 19  √  null
testresult createdDate datetime 19  √  null
user_job createdDate datetime 19  √  null
user_organization createdDate datetime 19  √  null
userbase createdDate datetime 19  √  null
userfavorite createdDate datetime 19  √  null
useritemviewhistory createdDate datetime 19  √  null
version createdDate datetime 19  √  null
view_itemtype createdDate datetime 19  √  null
viewconfig createdDate datetime 19  √  null
viewtype createdDate datetime 19  √  null
jobschedule cronExpression varchar 255  √  null
integrationconnection cronString varchar 255  √  null
documentfield customField char 1  √  null
portletinstance dashboardId int 10
dashboard.id FK_PORTLETINSTANCE_DASHBOARD
reportcriteria datatype varchar 255  √  null
documentfield dataTypeId int 10  √  null Field data type lookup
projectfield dataTypeId int 10  √  null
lookup dataValue varchar 255  √  null
document date1 datetime 19  √  null
project date1 datetime 19  √  null
document date2 datetime 19  √  null
project date2 datetime 19  √  null
document date3 datetime 19  √  null
document date4 datetime 19  √  null
document date5 datetime 19  √  null
integrationconnection defaultContourUserId int 10  √  null
userbase.id FKB2C6BBB2845B1931
documenttype defaultDisplay varchar 255  √  null
projecttype defaultDisplay varchar 255  √  null
documenttype defaultDisplayPlural varchar 255  √  null
projecttype defaultDisplayPlural varchar 255  √  null
documenttype defaultPrefix varchar 255  √  null
projecttype defaultPrefix varchar 255  √  null
lookuptype defaultValue int 10  √  null
releasetype defaultValue int 10  √  null
glossaryitem definition longtext 2147483647  √  null
attachment description longtext 2147483647  √  null
baseline description longtext 2147483647  √  null
dashboardlayout description varchar 255  √  null
distributiongroup description longtext 2147483647  √  null Text description
document description longtext 2147483647  √  null
document_document description longtext 2147483647  √  null
document_url description longtext 2147483647  √  null
documentfield description longtext 2147483647  √  null Label
documentgroup description longtext 2147483647  √  null User entered description of group
documenttype description longtext 2147483647  √  null
documenttypefielddefinition description longtext 2147483647  √  null
eventactiontype description longtext 2147483647  √  null
eventtype description longtext 2147483647  √  null
fieldlayouttype description varchar 255  √  null
filter description longtext 2147483647  √  null
itemtemplate description longtext 2147483647  √  null
jamaauthprovider description longtext 2147483647  √  null
jamaview description longtext 2147483647  √  null
jobschedule description longtext 2147483647  √  null
lookup description longtext 2147483647  √  null User entered description
lookuptype description longtext 2147483647  √  null
objecttype description longtext 2147483647  √  null
organization description longtext 2147483647  √  null
perspective description longtext 2147483647  √  null
portlet description longtext 2147483647  √  null
project description longtext 2147483647  √  null
projectfield description longtext 2147483647  √  null
projectrelease description longtext 2147483647  √  null Description of release
projecttype description longtext 2147483647  √  null
projecttypefield description longtext 2147483647  √  null
relationshiptype description longtext 2147483647  √  null
releasetype description longtext 2147483647  √  null
report description longtext 2147483647  √  null Admin entered description of report
role description longtext 2147483647  √  null
smartfilter description longtext 2147483647  √  null
document detail longtext 2147483647  √  null
attachment diagramGraphXml longtext 2147483647  √  null
attachment diagramHeight int 10  √  null
attachment diagramImageXml longtext 2147483647  √  null
attachment diagramWidth int 10  √  null
userbase disabled char 1  √  null
documentgroup display varchar 255  √  null Singular label to display
documenttype display varchar 255  √  null
report display varchar 255  √  null Display name of report
reportformat display varchar 255  √  null
role display varchar 255  √  null
documentgroup displayInReleaseTree char 1  √  null Flag that determines if the items should be included in the default display of the milestones tree
reportcriteria displayName varchar 255  √  null
documentgroup displayPlural varchar 255  √  null Plural label to display
documenttype displayPlural varchar 255  √  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
document documentKey varchar 255  √  null Configurable unique identifier that includes a prefix and numerical suffix. REQ-101 for example.
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
documenttype documentTypeKey varchar 255  √  null
document duration int 10  √  null
documentfield editxtype varchar 255  √  null
userbase email varchar 255 User email
jamaauthprovider emailAttribute longtext 2147483647  √  null
email emailBody longtext 2147483647  √  null
revision emailSubject varchar 255  √  null
userbase emailUpdatesToFollowedItems char 1  √  null
jamaauthprovider enableJndiReferrals char 1  √  null
revision endDate datetime 19  √  null
document entitytype varchar 31  √  Document
jamacomment entryDate datetime 19  √  null Date comment was created
estimate estimate int 10  √  null
estimate estimatedBy varchar 255  √  null
evententry eventDate datetime 19  √  null
evententry EventType int 10  √  null
eventactiontype eventTypeId int 10  √  null
evententry eventUser int 10  √  null
userbase.id FK3AFE26184D1BFDB7
Associated user ID
stepitem expectedResult varchar 4000  √  null
jamatoken expirationDate datetime 19  √  null
reportformat extention varchar 255  √  null
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 fileName varchar 255  √  null
attachment fileSize int 10  √  null
smartfilter filterAuthor int 10  √  null
revision_user finishedRevision char 1  √  null
userbase firstName varchar 255  √  null User first name
jamaauthprovider firstNameAttribute longtext 2147483647  √  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
documentfield formxtype varchar 255  √  null
email fromAddress varchar 255  √  null
document_document fromDocument int 10  √  null
document.id FKC5FF3FBFA9DB056B
ID of the item the link is coming from.
email fromName varchar 511  √  null
jamaauthprovider fullNameAttribute longtext 2147483647  √  null
document globalSortOrder int 10  √  null
documentnode globalSortOrder int 10
documentfield gridxtype varchar 255  √  null
subscription groupId int 10  √  null
role.id FK_SUBSCRIPTION_ROLE
documenttypefielddefinition groupName varchar 255  √  null
projecttypefield groupName varchar 255  √  null
perspective headerConfig varchar 255  √  null
document hibVersion int 10  √  null
jamacomment highlightQuote longtext 2147483647  √  null
jamacomment hightlightField varchar 255  √  null
jamacomment hightlightRange longtext 2147483647  √  null
perspective icon varchar 255  √  null
itemsyncstatus id int 10
document_document.itemSyncStatus FK_DOCDOC_ITEMSYNCSTATUS
dashboardlayout image varchar 255  √  null
documentgroup image varchar 255  √  null Path to icon
documenttype image varchar 255  √  null
lookup image varchar 255  √  null Path to image
portlet image varchar 255  √  null
projectrelease image varchar 255  √  null Path to icon
relationshiptype image varchar 255  √  null
jamacomment important char 1  √  null
document indent int 10  √  null Calculated value to represent the indentation level when representing data in an outline structure
integrationcomponentmapping integrationTrigger varchar 255  √  null
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
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
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
jobschedule jobClass varchar 255  √  null
jobschedule jobGroup varchar 255  √  null
jobschedule jobName varchar 255  √  null
documentgroup keySeperator varchar 255  √  null
documenttypefielddefinition label varchar 255  √  null
projecttypefield label varchar 255  √  null
jobschedule lastExecuteTime datetime 19  √  null
user_job lastGenerated datetime 19  √  null
revision_user lastLogged datetime 19  √  null
userbase lastName varchar 255  √  null User last name
jamaauthprovider lastNameAttribute longtext 2147483647  √  null
useritemviewhistory lastViewed datetime 19  √  null
revision_user latestActivity datetime 19  √  null
dashboard layoutId int 10
dashboardlayout.id FK_DASHBOARD_LAYOUT
fieldlayoutentry layoutPosition int 10  √  null
dashboardlayout layoutXtype varchar 255
document legacyKey varchar 255  √  null
organization licenseMessage int 10  √  null
license_snapshot_properties licenseSnapshotId int 10
license_snapshot.id FK_PROPERTY_LICENSE_SNAPSHOT
user_organization licenseType varchar 255  √  null
userbase licenseType varchar 255  √  null
userlogentry licenseType varchar 255  √  null
portlet limittooneinstance char 1  √  null
userbase locale varchar 32  √  null
perspective_view location varchar 255  √  null
portletinstance location varchar 255
userbase location varchar 64  √  null
jamaauthprovider locationAttribute longtext 2147483647  √  null
document locked char 1  √  null
userbase locked char 1  √  null
document lockedBy int 10  √  null
userbase.id FK335CD11BBD032133
document lockedDate datetime 19  √  null
userlogentry loginCode int 10  √  null
userlogentry loginTime datetime 19  √  null
userlogentry logoutCode int 10  √  null
userlogentry logoutTime datetime 19  √  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
integrationcomponentmapping mappedId varchar 255  √  null
integrationfieldmapping mappedId varchar 255  √  null
integrationcomponentmapping mappedName varchar 255  √  null
integrationfieldmapping mappedName varchar 255  √  null
aclpermission mask int 10
aclpermissionentry mask bigint 19  √  null
attachment mimeType longtext 2147483647  √  null
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
aclobject modifiedDate datetime 19  √  null
aclpermission modifiedDate datetime 19  √  null
aclpermissionentry modifiedDate datetime 19  √  null
attachment modifiedDate datetime 19  √  null
baseline modifiedDate datetime 19  √  null
changerequestassociation modifiedDate datetime 19  √  null
dashboard modifiedDate datetime 19  √  null
distributiongroup modifiedDate datetime 19  √  null
document modifiedDate datetime 19  √  null
document_attachment modifiedDate datetime 19  √  null
document_docattach modifiedDate datetime 19  √  null
document_document modifiedDate datetime 19  √  null
document_tag modifiedDate datetime 19  √  null
document_url modifiedDate datetime 19  √  null
documentcustomfieldvalue modifiedDate datetime 19  √  null
documentfield modifiedDate datetime 19  √  null User ID
documentgroup modifiedDate datetime 19  √  null
documenttype modifiedDate datetime 19  √  null
documenttypefielddefinition modifiedDate datetime 19  √  null
email modifiedDate datetime 19  √  null
estimate modifiedDate datetime 19  √  null
evententry modifiedDate datetime 19  √  null
eventtype modifiedDate datetime 19  √  null
fieldlayout modifiedDate datetime 19  √  null
fieldlayoutentry modifiedDate datetime 19  √  null
fieldlayouttype modifiedDate datetime 19  √  null
filter modifiedDate datetime 19  √  null
glossaryitem modifiedDate datetime 19  √  null
integrationcomponentmapping modifiedDate datetime 19  √  null
integrationconnection modifiedDate datetime 19  √  null
integrationdirectiontype modifiedDate datetime 19  √  null
integrationfieldmapping modifiedDate datetime 19  √  null
integrationtype modifiedDate datetime 19  √  null
itemsyncstatus modifiedDate datetime 19  √  null
itemtemplate modifiedDate datetime 19  √  null
jamaauthprovider modifiedDate datetime 19  √  null
jamacomment modifiedDate datetime 19  √  null
jamatoken modifiedDate datetime 19  √  null
jamaview modifiedDate datetime 19  √  null
jobschedule modifiedDate datetime 19  √  null
license_snapshot modifiedDate datetime 19  √  null
lookup modifiedDate datetime 19  √  null
lookuptype modifiedDate datetime 19  √  null
mutedsubscription modifiedDate datetime 19  √  null
objecttype modifiedDate datetime 19  √  null
organization modifiedDate datetime 19  √  null
perspective modifiedDate datetime 19  √  null
perspective_role modifiedDate datetime 19  √  null
perspective_view modifiedDate datetime 19  √  null
perspectiveconfig modifiedDate datetime 19  √  null
perspectivetype modifiedDate datetime 19  √  null
pluginentry modifiedDate datetime 19  √  null
project modifiedDate datetime 19  √  null
projectfield modifiedDate datetime 19  √  null
projectrelease modifiedDate datetime 19  √  null
projecttype modifiedDate datetime 19  √  null
projecttypefield modifiedDate datetime 19  √  null
propertyentry modifiedDate datetime 19  √  null
relationshiptype modifiedDate datetime 19  √  null
releasetype modifiedDate datetime 19  √  null
report modifiedDate datetime 19  √  null
reportcriteria modifiedDate datetime 19  √  null
reportformat modifiedDate datetime 19  √  null
reporttype modifiedDate datetime 19  √  null
review modifiedDate datetime 19  √  null
revision modifiedDate datetime 19  √  null
revision_item modifiedDate datetime 19  √  null
revision_user modifiedDate datetime 19  √  null
revision_user_item modifiedDate datetime 19  √  null
revisionpropertyentry modifiedDate datetime 19  √  null
role modifiedDate datetime 19  √  null
signature modifiedDate datetime 19  √  null
smartfilter modifiedDate datetime 19  √  null
subscription modifiedDate datetime 19  √  null
tag modifiedDate datetime 19  √  null
testresult modifiedDate datetime 19  √  null
user_job modifiedDate datetime 19  √  null
user_organization modifiedDate datetime 19  √  null
userbase modifiedDate datetime 19  √  null
userfavorite modifiedDate datetime 19  √  null
useritemviewhistory modifiedDate datetime 19  √  null
version modifiedDate datetime 19  √  null
view_itemtype modifiedDate datetime 19  √  null
viewconfig modifiedDate datetime 19  √  null
viewtype modifiedDate datetime 19  √  null
baseline name varchar 255  √  null
commentstatus name varchar 255  √  null
commenttype name varchar 255  √  null
distributiongroup name varchar 255  √  null Label for the distribution group
document name varchar 255  √  null
documentfield name varchar 255  √  null Internal name of field
documenttype name varchar 255  √  null
documenttypecategory name varchar 255  √  null
documenttypefielddefinition name varchar 255  √  null
eventactiontype name varchar 255  √  null
eventtype name varchar 255  √  null
fieldlayouttype name varchar 127  √  null
filter name varchar 255  √  null
integrationdirectiontype name varchar 255
integrationtype name varchar 255
itemsyncstatus name varchar 255  √  null
itemtemplate name varchar 255  √  null
jamaauthprovider name varchar 255  √  null
jamaview name varchar 255  √  null
lookup name varchar 255  √  null name of lookup
lookuptype name varchar 255  √  null
objecttype name varchar 255  √  null
organization name varchar 255
perspective name varchar 255  √  null
perspectivetype name varchar 255  √  null
pluginentry name varchar 255  √  null
portlet name varchar 255
project name varchar 255  √  null
projectfield name varchar 255  √  null
projectrelease name varchar 255  √  null Name of release
projecttype name varchar 255  √  null
projecttypefield name varchar 255  √  null
relationshiptype name varchar 255  √  null
releasetype name varchar 255  √  null Drop down list item
report name varchar 255  √  null Internal name of report (Duplicate)
report_criterion name varchar 255 Criteria to display to user when running a report
reportcriteria name varchar 255  √  null
reportformat name varchar 255  √  null
reporttype name varchar 255  √  null
review name varchar 255
revisionstatus name varchar 255  √  null
revisionuseritemstatus name varchar 255  √  null
role name varchar 255  √  null
smartfilter name varchar 255  √  null
testcasestatus name varchar 255  √  null
testrunset name varchar 255  √  null
testrunstatus name varchar 255  √  null
testset name varchar 255  √  null
viewtype name varchar 255  √  null
jamaauthprovider nameAttribute longtext 2147483647  √  null
perspective navConfig varchar 255  √  null
document_attachment note longtext 2147483647  √  null User entered text to describe the attachment
document_docattach note longtext 2147483647  √  null
pluginentry notes longtext 2147483647  √  null
testresult notes longtext 2147483647  √  null User entered notes about the executing the test case
userbase notes longtext 2147483647  √  null
revision notifyAuthorOnComplete char 1  √  null
revision numVotesPerUser int 10  √  null
aclpermissionentry objectId int 10  √  null
evententry objectId int 10  √  null
aclobject objectIdentity varchar 100  √  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