Table contour.version
Master versioning table that associates an item with its versions

 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 10  √ 
baseline_version.versionId FK5F1F94DE4C133EE4
changerequestassociation.versionEndId FK8C592429A27E04F
changerequestassociation.versionStartId FK8C59242D32E6C16
revision_item.versionId FKFA072CF74C133EE4
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
comments longtext 2147483647  √  null
organizationId int 10  √  null
userComment longtext 2147483647  √  null
versionNumber varchar 255  √  null
documentId int 10
document.id FK14F51CD8DA506A1C
originDocumentId int 10
document.id FK14F51CD86915E1C2

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
originDocumentId Performance Asc FK14F51CD86915E1C2
documentId Performance Asc FK14F51CD8DA506A1C

Close relationships  within of separation: