Table db182.loan_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 10
customer_loan_account_detail.ACCOUNT_ID customer_loan_account_detail_ibfk_6
loan_account.PARENT_ACCOUNT_ID fk_loan_account
loan_penalty.ACCOUNT_ID loan_penalty_ibfk_1
loan_summary.ACCOUNT_ID loan_summary_ibfk_9
max_min_loan_amount.ACCOUNT_ID max_min_loan_amount_ibfk_1
max_min_no_of_install.ACCOUNT_ID max_min_no_of_install_ibfk_1
waive_off_history.ACCOUNT_ID waive_off_history_ibfk_1
account.ACCOUNT_ID loan_account_ibfk_1
BUSINESS_ACTIVITIES_ID int 10  √  null
lookup_value.LOOKUP_ID fk_loan_bus_act_id
COLLATERAL_TYPE_ID int 10  √  null
lookup_value.LOOKUP_ID fk_loan_col_type_id
GRACE_PERIOD_TYPE_ID smallint 5
grace_period_type.GRACE_PERIOD_TYPE_ID loan_account_ibfk_6
GROUP_FLAG smallint 5  √  null
LOAN_AMOUNT decimal 10,3  √  null
LOAN_AMOUNT_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID loan_account_ibfk_3
LOAN_BALANCE decimal 10,3  √  null
LOAN_BALANCE_CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID loan_account_ibfk_4
INTEREST_TYPE_ID smallint 5  √  null
interest_types.INTEREST_TYPE_ID loan_account_ibfk_7
INTEREST_RATE decimal 13,10  √  null
FUND_ID smallint 5  √  null
fund.FUND_ID loan_account_ibfk_5
MEETING_ID int 10  √  null
meeting.MEETING_ID loan_account_ibfk_8
CURRENCY_ID smallint 5  √  null
currency.CURRENCY_ID loan_account_ibfk_2
NO_OF_INSTALLMENTS smallint 5
DISBURSEMENT_DATE date 0  √  null
COLLATERAL_NOTE text 65535  √  null
GRACE_PERIOD_DURATION smallint 5  √  null
INTEREST_AT_DISB smallint 5  √  null
GRACE_PERIOD_PENALTY smallint 5  √  null
PRD_OFFERING_ID smallint 5  √  null
prd_offering.PRD_OFFERING_ID fk_loan_prd_off_id
REDONE smallint 5
PARENT_ACCOUNT_ID int 10  √  null
account.ACCOUNT_ID fk_loan_acc_id
loan_account.ACCOUNT_ID fk_loan_account
MONTH_RANK smallint 5  √  null
rank_days_master.RANK_DAYS_MASTER_ID fk_loan_rankday
MONTH_WEEK smallint 5  √  null
week_days_master.WEEK_DAYS_MASTER_ID fk_loan_monthweek
RECUR_MONTH smallint 5  √  null

Table contained 0 rows at Wed Mar 19 17:59 PDT 2008

Indexes:
Column(s) Type Sort Constraint Name
ACCOUNT_ID Primary key Asc PRIMARY
CURRENCY_ID Performance Asc CURRENCY_ID
FUND_ID Performance Asc FUND_ID
GRACE_PERIOD_TYPE_ID Performance Asc GRACE_PERIOD_TYPE_ID
INTEREST_TYPE_ID Performance Asc INTEREST_TYPE_ID
LOAN_AMOUNT_CURRENCY_ID Performance Asc LOAN_AMOUNT_CURRENCY_ID
LOAN_BALANCE_CURRENCY_ID Performance Asc LOAN_BALANCE_CURRENCY_ID
MEETING_ID Performance Asc MEETING_ID
PARENT_ACCOUNT_ID Performance Asc fk_loan_account
BUSINESS_ACTIVITIES_ID Performance Asc fk_loan_bus_act_id
COLLATERAL_TYPE_ID Performance Asc fk_loan_col_type_id
MONTH_WEEK Performance Asc fk_loan_monthweek
PRD_OFFERING_ID Performance Asc fk_loan_prd_off_id
MONTH_RANK Performance Asc fk_loan_rankday

Close relationships  within one two degrees of separation :