Table db156.custom_field_definition Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
FIELD_ID smallint 6  √ 
account_custom_field.FIELD_ID account_custom_field_ibfk_1
customer_custom_field.FIELD_ID customer_custom_field_ibfk_1
office_custom_field.FIELD_ID Implied Constraint
personnel_custom_field.FIELD_ID personnel_custom_field_ibfk_2
ENTITY_ID smallint 6
lookup_entity.ENTITY_ID custom_field_definition_ibfk_2
LEVEL_ID smallint 6  √  null
customer_level.LEVEL_ID custom_field_definition_ibfk_1
FIELD_TYPE smallint 6  √  null
ENTITY_TYPE smallint 6
entity_master.ENTITY_TYPE_ID custom_field_definition_ibfk_3
MANDATORY_FLAG smallint 6
DEFAULT_VALUE varchar 200  √  null

Table contained 11 rows at Fri Nov 09 16:15 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
FIELD_ID Primary key Asc PRIMARY
ENTITY_ID Performance Asc ENTITY_ID
ENTITY_TYPE Performance Asc ENTITY_TYPE
LEVEL_ID Performance Asc LEVEL_ID

Close relationships  within one two degrees of separation :