Table contour.document_document
Relationships between artifacts

 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  √  System generated unique ID
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
description longtext 2147483647  √  null
suspect char 1  √  null Suspect link flag
associationType int 11  √  null
lookup.id FKC5FF3FBFA07B777C
lookup ID
fromDocument int 11  √  null
document.id FKC5FF3FBFA6F164E7
ID of the item the link is coming from.
relationshipType int 11  √  null
relationshiptype.id FKC5FF3FBF45B2C50B
status int 11  √  null
lookup.id FKC5FF3FBFF0FE0433
toDocument int 11  √  null
document.id FKC5FF3FBF3649FAB8
ID of the item the link is pointing to

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
toDocument Performance Asc FKC5FF3FBF3649FAB8
relationshipType Performance Asc FKC5FF3FBF45B2C50B
associationType Performance Asc FKC5FF3FBFA07B777C
fromDocument Performance Asc FKC5FF3FBFA6F164E7
status Performance Asc FKC5FF3FBFF0FE0433

Close relationships  within of separation: