Table db175.coahierarchy 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
COA_ID smallint 6
coa.COA_ID coahierarchy_ibfk_1
PARENT_COAID smallint 6  √  null
coa.COA_ID coahierarchy_ibfk_2

Table contained 56 rows at Thu Feb 28 14:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
COA_ID Performance Asc COA_ID
PARENT_COAID Performance Asc PARENT_COAID

Close relationships  within one two degrees of separation :