Table db195.personnel_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 5
customer_level.LEVEL_ID Implied Constraint
feelevel.LEVEL_ID Implied Constraint
office_level.LEVEL_ID Implied Constraint
personnel.LEVEL_ID personnel_ibfk_3
personnel_level.PARENT_LEVEL_ID personnel_level_ibfk_1
LEVEL_NAME_ID int 10
lookup_value.LOOKUP_ID personnel_level_ibfk_2
PARENT_LEVEL_ID smallint 5  √  null
personnel_level.LEVEL_ID personnel_level_ibfk_1
INTERACTION_FLAG smallint 5  √  null

Table contained 2 rows at Tue May 13 16:59 PDT 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 :