Table db171.customer_state 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
STATUS_ID smallint 6  √ 
customer.STATUS_ID customer_ibfk_2
customer_checklist.CUSTOMER_STATUS_ID customer_checklist_ibfk_3
customer_state_flag.STATUS_ID customer_state_flag_ibfk_1
office_status.STATUS_ID Implied Constraint
STATUS_LOOKUP_ID int 11
lookup_value.LOOKUP_ID customer_state_ibfk_2
LEVEL_ID smallint 6
customer_level.LEVEL_ID customer_state_ibfk_1
DESCRIPTION varchar 200  √  null
CURRENTLY_IN_USE smallint 6

Table contained 14 rows at Wed Jan 16 09:59 PST 2008

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

Close relationships  within one two degrees of separation :