Table contour.lookup 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  √ 
document.lookup10Id FK335CD11B739D9835
document.lookup1Id FK335CD11B6AC02593
document.lookup2Id FK335CD11B6AC02954
document.lookup3Id FK335CD11B6AC02D15
document.lookup4Id FK335CD11B6AC030D6
document.lookup5Id FK335CD11B6AC03497
document.lookup6Id FK335CD11B6AC03858
document.lookup7Id FK335CD11B6AC03C19
document.lookup8Id FK335CD11B6AC03FDA
document.lookup9Id FK335CD11B6AC0439B
document.priorityId FK335CD11B6080E200
document.statusId FK335CD11B74C9DCCE
document_document.associationType FKC5FF3FBFA07B777C
document_document.status FKC5FF3FBFF0FE0433
estimate.lookupId FK8B302528AC877456
project.lookup1Id FKED904B196AC02593
project.lookup2Id FKED904B196AC02954
project.lookup3Id FKED904B196AC02D15
project.lookup4Id FKED904B196AC030D6
project.projectGroupLookupId FKED904B19C82FC15C
project.statusId FKED904B1974C9DCCE
testresult.testConfiguration FK9B0ED72FDAF8E1E5
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
active char 1  √  null
color varchar 255  √  null
dataValue varchar 255  √  null
description longtext 2147483647  √  null User entered description
image varchar 255  √  null Path to image
isDefault char 1  √  null
name varchar 255  √  null name of lookup
organizationId int 10  √  null
sortOrder int 10  √  null list order
lookupTypeId int 10
lookuptype.id FKBE9BA97A8CB30AEA
Associated lookup list

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
lookupTypeId Performance Asc FKBE9BA97A8CB30AEA

Close relationships  within of separation: