Table contour.documentfield
Configuration table that

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  √ 
documenttypefielddefinition.documentFieldId FK9F2566584D729212
integrationfieldmapping.fieldId FK7FB5A268F5ECC78D
System generated unique ID
createdBy int 10  √  null User ID
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null User ID
category int 10  √  null
customField char 1  √  null
dataTypeId int 10  √  null Field data type lookup
description longtext 2147483647  √  null Label
editxtype varchar 255  √  null
fieldType int 10  √  null
formxtype varchar 255  √  null
gridxtype varchar 255  √  null
isDerived char 1  √  null
name varchar 255  √  null Internal name of field
organizationId int 10  √  null
readOnly char 1  √  null
refId int 10  √  null
scope int 10  √  null 1 = Organization
userConfigurable char 1  √  null

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

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

Close relationships  within of separation: