Table db164.savings_account 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
ACCOUNT_ID int 11
account.ACCOUNT_ID savings_account_ibfk_1
ACTIVATION_DATE date 10  √  null
SAVINGS_BALANCE decimal 10,3  √  null
SAVINGS_BALANCE_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID savings_account_ibfk_2
RECOMMENDED_AMOUNT decimal 10,3  √  null
RECOMMENDED_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID savings_account_ibfk_3
RECOMMENDED_AMNT_UNIT_ID smallint 6  √  null
recommended_amnt_unit.RECOMMENDED_AMNT_UNIT_ID savings_account_ibfk_5
SAVINGS_TYPE_ID smallint 6
savings_type.SAVINGS_TYPE_ID savings_account_ibfk_6
INT_TO_BE_POSTED decimal 10,3  √  null
INT_TO_BE_POSTED_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID savings_account_ibfk_4
LAST_INT_CALC_DATE date 10  √  null
LAST_INT_POST_DATE date 10  √  null
NEXT_INT_CALC_DATE date 10  √  null
NEXT_INT_POST_DATE date 10  √  null
INTER_INT_CALC_DATE date 10  √  null
PRD_OFFERING_ID smallint 6
prd_offering.PRD_OFFERING_ID savings_account_ibfk_7
INTEREST_RATE decimal 13,10
INTEREST_CALCULATION_TYPE_ID smallint 6
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID savings_account_ibfk_8
TIME_PER_FOR_INT_CALC int 11  √  null
meeting.MEETING_ID savings_account_ibfk_9
MIN_AMNT_FOR_INT decimal 10,3  √  null
MIN_AMNT_FOR_INT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID savings_account_ibfk_10

Table contained 0 rows at Thu Dec 13 21:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
ACCOUNT_ID Primary key Asc PRIMARY
INTEREST_CALCULATION_TYPE_ID Performance Asc INTEREST_CALCULATION_TYPE_ID
INT_TO_BE_POSTED_CURRENCY_ID Performance Asc INT_TO_BE_POSTED_CURRENCY_ID
MIN_AMNT_FOR_INT_CURRENCY_ID Performance Asc MIN_AMNT_FOR_INT_CURRENCY_ID
PRD_OFFERING_ID Performance Asc PRD_OFFERING_ID
RECOMMENDED_AMNT_UNIT_ID Performance Asc RECOMMENDED_AMNT_UNIT_ID
RECOMMENDED_AMOUNT_CURRENCY_ID Performance Asc RECOMMENDED_AMOUNT_CURRENCY_ID
SAVINGS_BALANCE_CURRENCY_ID Performance Asc SAVINGS_BALANCE_CURRENCY_ID
SAVINGS_TYPE_ID Performance Asc SAVINGS_TYPE_ID
TIME_PER_FOR_INT_CALC Performance Asc TIME_PER_FOR_INT_CALC

Close relationships  within one two degrees of separation :