Table contour.projecttypefield 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  √ 
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
controlStyle longtext 2147483647  √  null
controlTypeId int 11  √  null
description longtext 2147483647  √  null
groupName varchar 255  √  null
label varchar 255  √  null
lookupTypeId int 11  √  null
name varchar 255  √  null
readOnly char 1  √  null
required char 1  √  null
script longtext 2147483647  √  null
showInFolder char 1  √  null
showInList char 1  √  null
sortOrder int 11  √  null
sortOrderInList int 11  √  null
validation longtext 2147483647  √  null
projectFieldId int 11
projectfield.id FKD312A70774559544
projectTypeId int 11  √  null
projecttype.id FKD312A707B978BDBA

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
projectFieldId Performance Asc FKD312A70774559544
projectTypeId Performance Asc FKD312A707B978BDBA

Close relationships  within of separation: