Table db176.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 5  √ 
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 5
gl_code.GLCODE_ID coa_ibfk_1
CATEGORY_TYPE varchar 20  √  null

Table contained 0 rows at Tue Mar 04 15:50 PST 2008

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 :