Table db165.savings_activity_details 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
ID int 11  √ 
loan_arrears_aging.ID Implied Constraint
CREATED_BY smallint 6  √  null
personnel.PERSONNEL_ID savings_activity_details_ibfk_1
ACCOUNT_ID int 11
account.ACCOUNT_ID savings_activity_details_ibfk_2
CREATED_DATE timestamp 19 CURRENT_TIMESTAMP
ACCOUNT_ACTION_ID smallint 6
account_action.ACCOUNT_ACTION_ID savings_activity_details_ibfk_3
AMOUNT decimal 10,3
AMOUNT_CURRENCY_ID smallint 6
currency.CURRENCY_ID savings_activity_details_ibfk_4
BALANCE_AMOUNT decimal 10,3
BALANCE_AMOUNT_CURRENCY_ID smallint 6
currency.CURRENCY_ID savings_activity_details_ibfk_5

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
ACCOUNT_ACTION_ID Performance Asc ACCOUNT_ACTION_ID
ACCOUNT_ID Performance Asc ACCOUNT_ID
AMOUNT_CURRENCY_ID Performance Asc AMOUNT_CURRENCY_ID
BALANCE_AMOUNT_CURRENCY_ID Performance Asc BALANCE_AMOUNT_CURRENCY_ID
CREATED_BY Performance Asc CREATED_BY

Close relationships  within one two degrees of separation :