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

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

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

Close relationships  within of separation: