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
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
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
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 attributeValue longtext 2147483647  √  null
userbase autoFollowCommentedItems char 1  √  null
userbase avatarId int 10  √  null
attachment.id FK_USER_AVATAR
jamaauthprovider baseDn longtext 2147483647  √  null
documentnode baseLineId int 10  √  null
baseline.id FK_DOCUMENTNODE_BASELINE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
fieldlayoutentry layoutPosition int 10  √  null
document legacyKey varchar 255  √  null
organization licenseMessage int 10  √  null
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
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
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
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
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
perspective name varchar 255  √  null
perspectivetype name varchar 255  √  null
pluginentry name varchar 255  √  null
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)
reportcriteria name varchar 255  √  null
reportformat name varchar 255  √  null
reporttype name varchar 255  √  null
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
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
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
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
perspectiveconfig overridable char 1  √  null
viewconfig overridable char 1  √  null
revision overview longtext 2147483647  √  null
jobschedule params varchar 255  √  null
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
testresult passStatus char 1  √  null Flag - 'Y' or 'N'
integrationconnection password varchar 255  √  null
userbase passwordAttempts int 10  √  null
aclpermissionentry permissionType int 10  √  null
userbase phone varchar 64  √  null
jamaauthprovider phoneAttribute longtext 2147483647  √  null
pluginentry pluginClass longtext 2147483647  √  null
pluginentry pluginParams longtext 2147483647  √  null
pluginentry pluginType int 10  √  null
documentgroup prefix varchar 255  √  null Prefix for item Key such as 'REQ'
integrationcomponentmapping prefix varchar 255  √  null
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
project projectGroupLookupId int 10  √  null
lookup.id FKED904B19C82FC15C
Associated project group
attachment projectId int 10  √  null
project.id FK8AF7592362A5139B
documentgroup projectId int 10  √  null
project.id FK5EF19E4462A5139B
documentkeylookup projectId int 10  √  null
project.id FK_dockeylookup_project
integrationcomponentmapping projectId int 10  √  null
perspectiveconfig projectId int 10  √  null
project.id FKAB47207E62A5139B
role projectId int 10  √  null
viewconfig projectId int 10  √  null
project.id FKAC076E2762A5139B
documentkeylookup projectKey varchar 255  √  null
project projectKey varchar 255  √  null
project projectManager int 10  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
project projectTypeId int 10  √  null
projecttype.id FKED904B19B0B57FAF
projecttypefield projectTypeId int 10  √  null
projecttype.id FKD312A707B0B57FAF
propertyentry propertyName varchar 255  √  null
revisionpropertyentry propertyName varchar 255  √  null
propertyentry propertyType int 10  √  null
revisionpropertyentry propertyType int 10  √  null
portletinstanceproperties propertyvalue longtext 2147483647  √  null
propertyentry propertyValue longtext 2147483647  √  null
revisionpropertyentry propertyValue longtext 2147483647  √  null
integrationcomponentmapping pullIntoContourFilter int 10  √  null
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
organization redirectUrl varchar 255  √  null
baseline refId int 10  √  null
dashboard refId int 10  √  null
documentfield refId int 10  √  null
documenttype refId int 10  √  null
fieldlayout refId int 10  √  null
filter refId int 10  √  null
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
projectrelease releaseDate datetime 19  √  null
document releaseId int 10  √  null
projectrelease.id FK335CD11BD1554582
Associated release ID
document remainingEstimate int 10  √  null Units remaining - typically in hours
email replyToAddress varchar 255  √  null
report reportClass varchar 1024  √  null
reportcriteria reportId int 10  √  null
report.id FK767C093166CC54A
report reportParams longtext 2147483647  √  null
report reportTypeId int 10  √  null
reporttype.id FKC84C5534F0DEC1DE
documenttypefielddefinition required char 1  √  null
projecttypefield required char 1  √  null
revision requireSignature char 1  √  null
organization returnEmail varchar 255  √  null
signature revokeComments varchar 255  √  null
signature revokeDate datetime 19  √  null
aclpermission roleId int 10  √  null
role.id FKAF999D91403590E
perspective_role roleId int 10  √  null
role.id FK4FA204991403590E
userbase salt varchar 255  √  null
documentfield scope int 10  √  null 1 = Organization
documenttype scope int 10  √  null
fieldlayout scope int 10  √  null
filter scope int 10  √  null
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
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
documenttypefielddefinition script longtext 2147483647  √  null
projecttypefield script longtext 2147483647  √  null
document sequence varchar 255  √  null
documentkeylookup sequence int 10  √  null
revision sequence int 10  √  null
documentgroup sequenceNumber int 10  √  null Numerical value to start with when generating unique item keys
userlogentry sessionId varchar 255  √  null
document setKey varchar 255  √  null
documentkeylookup setKey varchar 255  √  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
aclpermissionentry sid int 10  √  null
aclpermissionentry sidType int 10  √  null
report sortItems char 1  √  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
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
view_itemtype sortOrder int 10  √  null
documenttypefielddefinition sortOrderInList int 10  √  null
projecttypefield sortOrderInList int 10  √  null
revision startDate datetime 19  √  null
document_document status int 10  √  null
lookup.id FKC5FF3FBFF0FE0433
email status varchar 255  √  null
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
stepitem stepnotes longtext 2147483647  √  null
jamaview stereotypeId int 10  √  null
jamaview.id FKCE07663057893EF9
perspective stereotypeId int 10  √  null
perspective.id FKC653A3C1E06C7A2
document string1 varchar 255  √  null
project string1 varchar 255  √  null
document string10 varchar 255  √  null
document string11 varchar 255  √  null
document string12 varchar 255  √  null
document string13 varchar 255  √  null
document string14 varchar 255  √  null
document string15 varchar 255  √  null
document string2 varchar 255  √  null
project string2 varchar 255  √  null
document string3 varchar 255  √  null
project string3 varchar 255  √  null
document string4 varchar 255  √  null
project string4 varchar 255  √  null
document string5 varchar 255  √  null
document string6 varchar 255  √  null
document string7 varchar 255  √  null
document string8 varchar 255  √  null
document string9 varchar 255  √  null
organization subdomain varchar 255  √  null
email subject varchar 255  √  null
aclobject subObject longtext 2147483647  √  null
subscription subscribedBy int 10  √  null
userbase.id FK_SUBSCRIPTION_SUBSCRIBEDBY
document_document suspect char 1  √  null Suspect link flag
attachment system char 1  √  null
report system char 1  √  null
userbase systemUser char 1  √  null
document_tag tag int 10  √  null
tag.id FKA835BA76868B9321
tag ID
tag tagName varchar 255  √  null Tag Name
integrationcomponentmapping targetDocumentId int 10  √  null
document.id FKBCFD230525D539E9
glossaryitem term varchar 255  √  null
testresult testCaseDetails longtext 2147483647  √  null
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
document testCaseVersionNumber varchar 255  √  null
testresult testConfiguration int 10  √  null
lookup.id FK9B0ED72FDAF8E1E5
Associated lookup list
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