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

Table contained 0 rows at Thu Apr 03 17:59 PDT 2008

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 :