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
id int 11  √ 
changerequestassociation.associatedItemId FK8C59242E91C4E16
changerequestassociation.changeRequestItemId FK8C59242A61FCB2F
document_attachment.documentId FKFEB8AEC7D766C998
document_docattach.docattachId FKD8310F5993BB117A
document_docattach.documentId FKD8310F59D766C998
document_document.fromDocument FKC5FF3FBFA6F164E7
document_document.toDocument FKC5FF3FBF3649FAB8
document_tag.document FKA835BA763B56973D
document_url.documentId FKA835C04BD766C998
documentcustomfieldvalue.documentId FKE13A6A03D766C998
evententry.document FK3AFE26183B56973D
jamacomment.documentId FKECA112F4D766C998
testresult.testCaseId FK9B0ED72F8937517F
version.documentId FK14F51CD8D766C998
version.originDocumentId FK14F51CD8662C413E
System generated unique ID
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
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 11  √  null
date1 datetime 19  √  null
date2 datetime 19  √  null
date3 datetime 19  √  null
date4 datetime 19  √  null
date5 datetime 19  √  null
description longtext 2147483647  √  null
detail longtext 2147483647  √  null
documentKey varchar 255  √  null Configurable unique identifier that includes a prefix and numerical suffix. REQ-101 for example.
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 11  √  null
hibVersion int 11  √  null
indent int 11  √  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
locked char 1  √  null
lockedDate datetime 19  √  null
name varchar 255  √  null
originalEstimate int 11  √  null Original estimate for an item - typically in hours
parentId int 11  √  null ID of the parent item as configured in the tree view
remainingEstimate int 11  √  null Units remaining - typically in hours
sequence varchar 255  √  null
sortOrder int 11  √  null Used by internal routine called prior to a report being run to sort amongst all items within a group based on the explorer view
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 11  √  null Actual time spent - typically in hours
xprojectLinkId int 11  √  null Reference to a linked item from another project.
assignedToId int 11  √  null
userbase.id FK335CD11BDDE05BF6
Associated User ID
documentGroup int 11  √  null
documentgroup.id FK335CD11B884663C1
Related group ID
lockedBy int 11  √  null
userbase.id FK335CD11BBD032133
lookup1Id int 11  √  null
lookup.id FK335CD11B6AC02593
lookup10Id int 11  √  null
lookup.id FK335CD11B739D9835
lookup2Id int 11  √  null
lookup.id FK335CD11B6AC02954
lookup3Id int 11  √  null
lookup.id FK335CD11B6AC02D15
lookup4Id int 11  √  null
lookup.id FK335CD11B6AC030D6
lookup5Id int 11  √  null
lookup.id FK335CD11B6AC03497
lookup6Id int 11  √  null
lookup.id FK335CD11B6AC03858
lookup7Id int 11  √  null
lookup.id FK335CD11B6AC03C19
lookup8Id int 11  √  null
lookup.id FK335CD11B6AC03FDA
lookup9Id int 11  √  null
lookup.id FK335CD11B6AC0439B
priorityId int 11  √  null
lookup.id FK335CD11B6080E200
Associated Priority ID
projectId int 11
project.id FK335CD11B43370F26
related Project ID
releaseId int 11  √  null
projectrelease.id FK335CD11BD1554582
Associated release ID
release1Id int 11  √  null
projectrelease.id FK335CD11B718FC1C5
release2Id int 11  √  null
projectrelease.id FK335CD11B718FC586
statusId int 11  √  null
lookup.id FK335CD11B74C9DCCE
Associated status ID
user1Id int 11  √  null
userbase.id FK335CD11B4267BDB3
user2Id int 11  √  null
userbase.id FK335CD11B4267C174

Table contained 351 rows at Mon Jun 14 17:03 PDT 2010

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
parentId Performance Asc document_parentid_idx
xprojectLinkId Performance Asc document_xprojectlink_idx
user1Id Performance Asc FK335CD11B4267BDB3
user2Id Performance Asc FK335CD11B4267C174
projectId Performance Asc FK335CD11B43370F26
priorityId Performance Asc FK335CD11B6080E200
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
lockedBy Performance Asc FK335CD11BBD032133
releaseId Performance Asc FK335CD11BD1554582
assignedToId Performance Asc FK335CD11BDDE05BF6

Close relationships  within of separation: