Table db167.fee_payments_categories_type 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
FEE_PAYMENTS_CATEGORY_TYPE_ID smallint 6
fees.FEE_PAYMENTS_CATEGORY_TYPE_ID Implied Constraint
FEE_PAYMENT_ID smallint 6  √  null
fee_payment.FEE_PAYMENT_ID fee_payments_categories_type_ibfk_2
CATEGORY_ID smallint 6  √  null
category_type.CATEGORY_ID fee_payments_categories_type_ibfk_1
FEE_TYPE_ID smallint 6  √  null
fee_type.FEE_TYPE_ID fee_payments_categories_type_ibfk_3

Table contained 3 rows at Wed Dec 26 12:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
FEE_PAYMENTS_CATEGORY_TYPE_ID Primary key Asc PRIMARY
CATEGORY_ID Performance Asc CATEGORY_ID
FEE_PAYMENT_ID Performance Asc FEE_PAYMENT_ID
FEE_TYPE_ID Performance Asc FEE_TYPE_ID

Close relationships  within one two degrees of separation :