Table db165.coa 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_idmapper.COA_ID coa_idmapper_ibfk_1
coahierarchy.COA_ID coahierarchy_ibfk_1
coahierarchy.PARENT_COAID coahierarchy_ibfk_2
COA_Name varchar 150
GLCODE_ID smallint 6
gl_code.GLCODE_ID coa_ibfk_1

Table contained 56 rows at Fri Dec 14 17:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
COA_ID Primary key Asc PRIMARY
GLCODE_ID Performance Asc GLCODE_ID

Close relationships  within one two degrees of separation :