Table contour.document
Artifacts such as requirements, use cases etc

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
entitytype varchar 31  √  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
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.
attachment int 10  √  null
createdBy int 10  √  null
createdDate datetime 19  √  null
description longtext 2147483647  √  null
documentKey varchar 255  √  null Configurable unique identifier that includes a prefix and numerical suffix. REQ-101 for example.
hibVersion int 10  √  null
legacyKey varchar 255  √  null
locked char 1  √  null
lockedDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
name varchar 255  √  null
organizationId int 10  √  null
date1 datetime 19  √  null
date2 datetime 19  √  null
date3 datetime 19  √  null
date4 datetime 19  √  null
date5 datetime 19  √  null
detail longtext 2147483647  √  null
flag1 char 1  √  null User defined field - Boolean
flag2 char 1  √  null User defined field - Boolean
flag3 char 1  √  null User defined field - Boolean
flag4 char 1  √  null User defined field - Boolean
flag5 char 1  √  null User defined field - Boolean
globalSortOrder int 10  √  null
indent int 10  √  null Calculated value to represent the indentation level when representing data in an outline structure
isFolder char 1  √  null Indicator that the item is a folder
originalEstimate int 10  √  null Original estimate for an item - typically in hours
parentId int 10  √  null ID of the parent item as configured in the tree view
remainingEstimate int 10  √  null Units remaining - typically in hours
sequence varchar 255  √  null
setKey varchar 255  √  null
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
string1 varchar 255  √  null
string10 varchar 255  √  null
string11 varchar 255  √  null
string12 varchar 255  √  null
string13 varchar 255  √  null
string14 varchar 255  √  null
string15 varchar 255  √  null
string2 varchar 255  √  null
string3 varchar 255  √  null
string4 varchar 255  √  null
string5 varchar 255  √  null
string6 varchar 255  √  null
string7 varchar 255  √  null
string8 varchar 255  √  null
string9 varchar 255  √  null
text1 longtext 2147483647  √  null
text10 longtext 2147483647  √  null
text2 longtext 2147483647  √  null
text3 longtext 2147483647  √  null
text4 longtext 2147483647  √  null
text5 longtext 2147483647  √  null
text6 longtext 2147483647  √  null
text7 longtext 2147483647  √  null
text8 longtext 2147483647  √  null
text9 longtext 2147483647  √  null
timeSpent int 10  √  null Actual time spent - typically in hours
xprojectLinkId int 10  √  null Reference to a linked item from another project.
archived char 1  √  null
actualResults longtext 2147483647  √  null
duration int 10  √  null
testCaseVersionNumber varchar 255  √  null
documentTypeId int 10  √  null
documenttype.id FK335CD11BE181EF2C
lockedBy int 10  √  null
userbase.id FK335CD11BBD032133
projectId int 10
project.id FK335CD11B62A5139B
related Project ID
assignedToId int 10  √  null
userbase.id FK_TESTRUN_USER
Associated User ID
childDocumentTypeId int 10  √  null
documenttype.id FK335CD11B9E94C348
documentGroup int 10  √  null
documentgroup.id FK335CD11B884663C1
Related group ID
lookup1Id int 10  √  null
lookup.id FK335CD11B6AC02593
lookup10Id int 10  √  null
lookup.id FK335CD11B739D9835
lookup2Id int 10  √  null
lookup.id FK335CD11B6AC02954
lookup3Id int 10  √  null
lookup.id FK335CD11B6AC02D15
lookup4Id int 10  √  null
lookup.id FK335CD11B6AC030D6
lookup5Id int 10  √  null
lookup.id FK335CD11B6AC03497
lookup6Id int 10  √  null
lookup.id FK335CD11B6AC03858
lookup7Id int 10  √  null
lookup.id FK335CD11B6AC03C19
lookup8Id int 10  √  null
lookup.id FK335CD11B6AC03FDA
lookup9Id int 10  √  null
lookup.id FK335CD11B6AC0439B
priorityId int 10  √  null
lookup.id FK335CD11B6080E200
Associated Priority ID
releaseId int 10  √  null
projectrelease.id FK335CD11BD1554582
Associated release ID
release1Id int 10  √  null
projectrelease.id FK335CD11B718FC1C5
release2Id int 10  √  null
projectrelease.id FK335CD11B718FC586
statusId int 10  √  null
lookup.id FK335CD11B74C9DCCE
Associated status ID
testCaseStatusId int 10  √  null
testcasestatus.id FK_TESTCASE_TCSTATUS
user1Id int 10  √  null
userbase.id FK335CD11B4267BDB3
user2Id int 10  √  null
userbase.id FK335CD11B4267C174
testPlanId int 10  √  null
document.id FK_TESTCYCLE_TESTPLAN
testCaseId int 10  √  null
document.id FK_TESTRUN_TESTCASE
testRunSetId int 10  √  null
testrunset.id FK_TESTRUN_TESTRUNSET
testRunStatusId int 10  √  null
testrunstatus.id FK_TESTRUN_TESTRUNSTATUS

Table contained 182 rows at Wed Jan 18 17:22 PST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
active Performance Asc contourobject_active_idx
documentKey Performance Asc document_documentkey_idx
parentId Performance Asc document_parentid_idx
xprojectLinkId Performance Asc document_xprojectlinkid_idx
user1Id Performance Asc FK335CD11B4267BDB3
user2Id Performance Asc FK335CD11B4267C174
priorityId Performance Asc FK335CD11B6080E200
projectId Performance Asc FK335CD11B62A5139B
lookup1Id Performance Asc FK335CD11B6AC02593
lookup2Id Performance Asc FK335CD11B6AC02954
lookup3Id Performance Asc FK335CD11B6AC02D15
lookup4Id Performance Asc FK335CD11B6AC030D6
lookup5Id Performance Asc FK335CD11B6AC03497
lookup6Id Performance Asc FK335CD11B6AC03858
lookup7Id Performance Asc FK335CD11B6AC03C19
lookup8Id Performance Asc FK335CD11B6AC03FDA
lookup9Id Performance Asc FK335CD11B6AC0439B
release1Id Performance Asc FK335CD11B718FC1C5
release2Id Performance Asc FK335CD11B718FC586
lookup10Id Performance Asc FK335CD11B739D9835
statusId Performance Asc FK335CD11B74C9DCCE
documentGroup Performance Asc FK335CD11B884663C1
childDocumentTypeId Performance Asc FK335CD11B9E94C348
lockedBy Performance Asc FK335CD11BBD032133
releaseId Performance Asc FK335CD11BD1554582
documentTypeId Performance Asc FK335CD11BE181EF2C
testCaseStatusId Performance Asc FK_TESTCASE_TCSTATUS
testPlanId Performance Asc FK_TESTCYCLE_TESTPLAN
testCaseId Performance Asc FK_TESTRUN_TESTCASE
testRunSetId Performance Asc FK_TESTRUN_TESTRUNSET
testRunStatusId Performance Asc FK_TESTRUN_TESTRUNSTATUS
assignedToId Performance Asc FK_TESTRUN_USER

Close relationships  within of separation: