Table db172.customer_level Generated by
SchemaSpy
Implied relationships 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
LEVEL_ID smallint 6
custom_field_definition.LEVEL_ID custom_field_definition_ibfk_1
customer.CUSTOMER_LEVEL_ID customer_ibfk_1
customer_checklist.LEVEL_ID customer_checklist_ibfk_2
customer_level.PARENT_LEVEL_ID customer_level_ibfk_1
customer_state.LEVEL_ID customer_state_ibfk_1
personnel_level.LEVEL_ID Implied Constraint
PARENT_LEVEL_ID smallint 6  √  null
customer_level.LEVEL_ID customer_level_ibfk_1
LEVEL_NAME_ID smallint 6
lookup_entity.ENTITY_ID customer_level_ibfk_2
INTERACTION_FLAG smallint 6  √  null
MAX_CHILD_COUNT smallint 6
MAX_INSTANCE_COUNT smallint 6

Table contained 3 rows at Tue Jan 29 17:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
LEVEL_ID Primary key Asc PRIMARY
LEVEL_NAME_ID Performance Asc LEVEL_NAME_ID
PARENT_LEVEL_ID Performance Asc PARENT_LEVEL_ID

Close relationships  within one two degrees of separation :