Table db187.savings_offering 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
PRD_OFFERING_ID smallint 5
prd_offering.PRD_OFFERING_ID savings_offering_ibfk_1
INTEREST_CALCULATION_TYPE_ID smallint 5
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID savings_offering_ibfk_4
SAVINGS_TYPE_ID smallint 5
savings_type.SAVINGS_TYPE_ID savings_offering_ibfk_3
RECOMMENDED_AMNT_UNIT_ID smallint 5  √  null
recommended_amnt_unit.RECOMMENDED_AMNT_UNIT_ID savings_offering_ibfk_2
RECOMMENDED_AMOUNT decimal 10,3  √  null
RECOMMENDED_AMOUNT_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID savings_offering_ibfk_5
INTEREST_RATE decimal 13,10
MAX_AMNT_WITHDRAWL decimal 10,3  √  null
MAX_AMNT_WITHDRAWL_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID savings_offering_ibfk_6
MIN_AMNT_FOR_INT decimal 10,3  √  null
MIN_AMNT_FOR_INT_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID savings_offering_ibfk_7
DEPOSIT_GLCODE_ID smallint 5
gl_code.GLCODE_ID savings_offering_ibfk_8
INTEREST_GLCODE_ID smallint 5
gl_code.GLCODE_ID savings_offering_ibfk_9

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

Indexes:
Column(s) Type Sort Constraint Name
PRD_OFFERING_ID Primary key Asc PRIMARY
DEPOSIT_GLCODE_ID Performance Asc DEPOSIT_GLCODE_ID
INTEREST_CALCULATION_TYPE_ID Performance Asc INTEREST_CALCULATION_TYPE_ID
INTEREST_GLCODE_ID Performance Asc INTEREST_GLCODE_ID
MAX_AMNT_WITHDRAWL_CURRENCY_ID Performance Asc MAX_AMNT_WITHDRAWL_CURRENCY_ID
MIN_AMNT_FOR_INT_CURRENCY_ID Performance Asc MIN_AMNT_FOR_INT_CURRENCY_ID
RECOMMENDED_AMNT_UNIT_ID Performance Asc RECOMMENDED_AMNT_UNIT_ID
RECOMMENDED_AMOUNT_CURRENCY_ID Performance Asc RECOMMENDED_AMOUNT_CURRENCY_ID
SAVINGS_TYPE_ID Performance Asc SAVINGS_TYPE_ID

Close relationships  within one two degrees of separation :