Table db175.currency 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
CURRENCY_ID smallint 6  √ 
account_activity.FEE_CURRENCY_ID account_activity_ibfk_6
account_activity.FEE_OUTSTANDING_CURRENCY_ID account_activity_ibfk_7
account_activity.INTEREST_CURRENCY_ID account_activity_ibfk_4
account_activity.INTEREST_OUTSTANDING_CURRENCY_ID account_activity_ibfk_5
account_activity.PENALTY_CURRENCY_ID account_activity_ibfk_8
account_activity.PENALTY_OUTSTANDING_CURRENCY_ID account_activity_ibfk_9
account_activity.PRINCIPAL_CURRENCY_ID account_activity_ibfk_2
account_activity.PRINCIPAL_OUTSTANDING_CURRENCY_ID account_activity_ibfk_3
account_fees.ACCOUNT_FEE_AMNT_CURRENCY_ID account_fees_ibfk_3
account_payment.CURRENCY_ID account_payment_ibfk_2
account_trxn.AMOUNT_CURRENCY_ID account_trxn_ibfk_5
account_trxn.CURRENCY_ID account_trxn_ibfk_4
coll_sheet_customer.COLLECTIVE_ACCNT_CHARGES_CURRENCY coll_sheet_customer_ibfk_7
coll_sheet_customer.COLLECTIVE_LN_AMNT_DUE_CURRENCY coll_sheet_customer_ibfk_4
coll_sheet_customer.COLLECTIVE_LN_DISBURSAL_CURRENCY coll_sheet_customer_ibfk_5
coll_sheet_customer.COLLECTIVE_NET_CASH_IN_CURRENCY coll_sheet_customer_ibfk_9
coll_sheet_customer.COLLECTIVE_SAVINGS_DUE_CURRENCY coll_sheet_customer_ibfk_6
coll_sheet_customer.COLLECTIVE_TOTAL_CHARGES_CURRENCY coll_sheet_customer_ibfk_8
coll_sheet_customer.CUST_ACCNT_FEE_CURRENCY coll_sheet_customer_ibfk_2
coll_sheet_customer.CUST__ACCNT_PENALTY_CURRENCY coll_sheet_customer_ibfk_3
coll_sheet_customer.TOTAL_DUE_SAVINGS_LOAN_CURRENCY coll_sheet_customer_ibfk_1
coll_sheet_loan_details.AMNT_TOBE_DISBURSED_CURRENCY coll_sheet_loan_details_ibfk_14
coll_sheet_loan_details.AMNT_TO_CLOSE_LOAN_CURRENCY coll_sheet_loan_details_ibfk_2
coll_sheet_loan_details.FEES_DUE_CURRENCY coll_sheet_loan_details_ibfk_5
coll_sheet_loan_details.FEES_OVERDUE_CURRENCY coll_sheet_loan_details_ibfk_10
coll_sheet_loan_details.INTEREST_DUE_CURRENCY coll_sheet_loan_details_ibfk_4
coll_sheet_loan_details.INTEREST_OVERDUE_CURRENCY coll_sheet_loan_details_ibfk_9
coll_sheet_loan_details.ORIG_LOAN_AMNT_CURRENCY coll_sheet_loan_details_ibfk_1
coll_sheet_loan_details.PENALTY_DUE_CURRENCY coll_sheet_loan_details_ibfk_6
coll_sheet_loan_details.PENALTY_OVERDUE_CURRENCY coll_sheet_loan_details_ibfk_11
coll_sheet_loan_details.PRINCIPAL_DUE_CURRENCY coll_sheet_loan_details_ibfk_3
coll_sheet_loan_details.PRINCIPAL_OVERDUE_CURRENCY coll_sheet_loan_details_ibfk_8
coll_sheet_loan_details.TOTAL_AMNT_DUE_CURRENCY coll_sheet_loan_details_ibfk_13
coll_sheet_loan_details.TOTAL_AMNT_OVERDUE_CURRENCY coll_sheet_loan_details_ibfk_12
coll_sheet_loan_details.TOTAL_PRIN_DUE_CURRENCY coll_sheet_loan_details_ibfk_15
coll_sheet_loan_details.TOTAL_SCHEDULED_AMNT_DUE_CURRENCY coll_sheet_loan_details_ibfk_7
coll_sheet_savings_details.ACCNT_BALANCE_CURRENCY coll_sheet_savings_details_ibfk_1
coll_sheet_savings_details.AMNT_OVERDUE_CURRENCY coll_sheet_savings_details_ibfk_3
coll_sheet_savings_details.RECOMMENDED_AMNT_DUE_CURRENCY coll_sheet_savings_details_ibfk_2
coll_sheet_savings_details.TOTAL_SAVINGS_AMNT_DUE_CURRENCY coll_sheet_savings_details_ibfk_4
customer_account_activity.FEE_AMOUNT_CURRENCY_ID customer_account_activity_ibfk_2
customer_fee_schedule.AMOUNT_CURRENCY_ID customer_fee_schedule_ibfk_2
customer_fee_schedule.AMOUNT_PAID_CURRENCY_ID customer_fee_schedule_ibfk_3
customer_loan_account_detail.CURRENCY_ID customer_loan_account_detail_ibfk_2
customer_loan_account_detail.INTEREST_CURRENCY_ID customer_loan_account_detail_ibfk_4
customer_loan_account_detail.PENALTY_CURRENCY_ID customer_loan_account_detail_ibfk_5
customer_loan_account_detail.PRINCIPAL_CURRENCY_ID customer_loan_account_detail_ibfk_3
customer_schedule.CURRENCY_ID customer_schedule_ibfk_2
customer_trxn_detail.MISC_FEE_AMOUNT_CURRENCY_ID customer_trxn_detail_ibfk_3
customer_trxn_detail.MISC_PENALTY_AMOUNT_CURRENCY_ID customer_trxn_detail_ibfk_2
customer_trxn_detail.TOTAL_AMOUNT_CURRENCY_ID customer_trxn_detail_ibfk_1
fee_trxn_detail.FEE_AMOUNT_CURRENCY_ID fee_trxn_detail_ibfk_2
fees.FEE_AMOUNT_CURRENCY_ID fees_ibfk_9
fees.RATE_OR_AMOUNT_CURRENCY_ID fees_ibfk_8
financial_trxn.BALANCE_AMOUNT_CURRENCY_ID financial_trxn_ibfk_4
financial_trxn.CURRENCY_ID financial_trxn_ibfk_5
financial_trxn.POSTED_AMOUNT_CURRENCY_ID financial_trxn_ibfk_3
loan_account.CURRENCY_ID loan_account_ibfk_2
loan_account.LOAN_AMOUNT_CURRENCY_ID loan_account_ibfk_3
loan_account.LOAN_BALANCE_CURRENCY_ID loan_account_ibfk_4
loan_activity_details.BALANCE_FEE_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_10
loan_activity_details.BALANCE_INTEREST_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_8
loan_activity_details.BALANCE_PENALTY_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_9
loan_activity_details.BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_7
loan_activity_details.FEE_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_5
loan_activity_details.INTEREST_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_4
loan_activity_details.PENALTY_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_6
loan_activity_details.PRINCIPAL_AMOUNT_CURRENCY_ID loan_activity_details_ibfk_3
loan_arrears_aging.OVERDUE_BALANCE_CURRENCY_ID loan_arrears_aging_ibfk_7
loan_arrears_aging.OVERDUE_INTEREST_CURRENCY_ID loan_arrears_aging_ibfk_6
loan_arrears_aging.OVERDUE_PRINCIPAL_CURRENCY_ID loan_arrears_aging_ibfk_5
loan_arrears_aging.UNPAID_BALANCE_CURRENCY_ID loan_arrears_aging_ibfk_10
loan_arrears_aging.UNPAID_INTEREST_CURRENCY_ID loan_arrears_aging_ibfk_9
loan_arrears_aging.UNPAID_PRINCIPAL_CURRENCY_ID loan_arrears_aging_ibfk_8
loan_fee_schedule.AMOUNT_CURRENCY_ID loan_fee_schedule_ibfk_2
loan_fee_schedule.AMOUNT_PAID_CURRENCY_ID loan_fee_schedule_ibfk_3
loan_offering.DEFAULT_LOAN_AMOUNT_CURRENCY_ID loan_offering_ibfk_8
loan_offering.MAX_LOAN_AMNT_CURRENCY_ID loan_offering_ibfk_7
loan_offering.MIN_LOAN_AMOUNT_CURRENCY_ID loan_offering_ibfk_6
loan_schedule.CURRENCY_ID loan_schedule_ibfk_2
loan_schedule.INTEREST_CURRENCY_ID loan_schedule_ibfk_4
loan_schedule.INTEREST_PAID_CURRENCY_ID loan_schedule_ibfk_10
loan_schedule.MISC_FEES_CURRENCY_ID loan_schedule_ibfk_6
loan_schedule.MISC_FEES_PAID_CURRENCY_ID loan_schedule_ibfk_7
loan_schedule.MISC_PENALTY_CURRENCY_ID loan_schedule_ibfk_8
loan_schedule.MISC_PENALTY_PAID_CURRENCY_ID loan_schedule_ibfk_12
loan_schedule.PENALTY_CURRENCY_ID loan_schedule_ibfk_5
loan_schedule.PENALTY_PAID_CURRENCY_ID loan_schedule_ibfk_11
loan_schedule.PRINCIPAL_CURRENCY_ID loan_schedule_ibfk_3
loan_schedule.PRINCIPAL_PAID_CURRENCY_ID loan_schedule_ibfk_9
loan_summary.FEES_PAID_CURRENCY_ID loan_summary_ibfk_7
loan_summary.INTEREST_PAID_CURRENCY_ID loan_summary_ibfk_6
loan_summary.ORIG_FEES_CURRENCY_ID loan_summary_ibfk_3
loan_summary.ORIG_INTEREST_CURRENCY_ID loan_summary_ibfk_2
loan_summary.ORIG_PENALTY_CURRENCY_ID loan_summary_ibfk_4
loan_summary.ORIG_PRINCIPAL_CURRENCY_ID loan_summary_ibfk_1
loan_summary.PENALTY_PAID_CURRENCY_ID loan_summary_ibfk_8
loan_summary.PRINCIPAL_PAID_CURRENCY_ID loan_summary_ibfk_5
loan_trxn_detail.INTEREST_AMOUNT_CURRENCY_ID loan_trxn_detail_ibfk_2
loan_trxn_detail.MISC_FEE_AMOUNT_CURRENCY_ID loan_trxn_detail_ibfk_5
loan_trxn_detail.MISC_PENALTY_AMOUNT_CURRENCY_ID loan_trxn_detail_ibfk_4
loan_trxn_detail.PENALTY_AMOUNT_CURRENCY_ID loan_trxn_detail_ibfk_3
loan_trxn_detail.PRINCIPAL_AMOUNT_CURRENCY_ID loan_trxn_detail_ibfk_1
saving_schedule.CURRENCY_ID saving_schedule_ibfk_2
saving_schedule.DEPOSIT_CURRENCY_ID saving_schedule_ibfk_3
saving_schedule.DEPOSIT_PAID_CURRENCY_ID saving_schedule_ibfk_4
savings_account.INT_TO_BE_POSTED_CURRENCY_ID savings_account_ibfk_4
savings_account.MIN_AMNT_FOR_INT_CURRENCY_ID savings_account_ibfk_10
savings_account.RECOMMENDED_AMOUNT_CURRENCY_ID savings_account_ibfk_3
savings_account.SAVINGS_BALANCE_CURRENCY_ID savings_account_ibfk_2
savings_activity_details.AMOUNT_CURRENCY_ID savings_activity_details_ibfk_4
savings_activity_details.BALANCE_AMOUNT_CURRENCY_ID savings_activity_details_ibfk_5
savings_offering.MAX_AMNT_WITHDRAWL_CURRENCY_ID savings_offering_ibfk_6
savings_offering.MIN_AMNT_FOR_INT_CURRENCY_ID savings_offering_ibfk_7
savings_offering.RECOMMENDED_AMOUNT_CURRENCY_ID savings_offering_ibfk_5
savings_performance.TOTAL_DEPOSITS_CURRENCY_ID savings_performance_ibfk_2
savings_performance.TOTAL_INTEREST_EARNED_CURRENCY_ID savings_performance_ibfk_4
savings_performance.TOTAL_WITHDRAWALS_CURRENCY_ID savings_performance_ibfk_3
savings_trxn_detail.BALANCE_CURRENCY_ID savings_trxn_detail_ibfk_5
savings_trxn_detail.DEPOSIT_AMOUNT_CURRENCY_ID savings_trxn_detail_ibfk_2
savings_trxn_detail.INTEREST_AMOUNT_CURRENCY_ID savings_trxn_detail_ibfk_4
savings_trxn_detail.WITHDRAWAL_AMOUNT_CURRENCY_ID savings_trxn_detail_ibfk_3
CURRENCY_NAME varchar 50  √  null
DISPLAY_SYMBOL varchar 50  √  null
ROUNDING_MODE smallint 6  √  null
ROUNDING_AMOUNT decimal 6,3  √  null
DEFAULT_CURRENCY smallint 6  √  null
DEFAULT_DIGITS_AFTER_DECIMAL smallint 6
CURRENCY_CODE varchar 3  √  null

Table contained 4 rows at Thu Feb 28 14:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
CURRENCY_ID Primary key Asc PRIMARY

Close relationships  within one two degrees of separation :