Table db167.coll_sheet_loan_details Generated by
SchemaSpy
Implied relationships 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
LOAN_DETAILS_ID bigint 20  √ 
COLL_SHEET_CUST_ID bigint 20
coll_sheet_customer.COLL_SHEET_CUST_ID Implied Constraint
ACCNT_ID int 11
TOTAL_PRIN_DUE decimal 10,3
TOTAL_PRIN_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_15
ORIG_LOAN_AMNT decimal 10,3
ORIG_LOAN_AMNT_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_1
AMNT_TO_CLOSE_LOAN decimal 10,3
AMNT_TO_CLOSE_LOAN_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_2
TOTAL_NO_OF_INSTALLMENTS smallint 6
CURRENT_INSTALLMENT_NO smallint 6  √  null
PRINCIPAL_DUE decimal 10,3  √  null
PRINCIPAL_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_3
INTEREST_DUE decimal 10,3  √  null
INTEREST_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_4
FEES_DUE decimal 10,3  √  null
FEES_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_5
PENALTY_DUE decimal 10,3  √  null
PENALTY_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_6
TOTAL_SCHEDULED_AMNT_DUE decimal 10,3  √  null
TOTAL_SCHEDULED_AMNT_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_7
PRINCIPAL_OVERDUE decimal 10,3  √  null
PRINCIPAL_OVERDUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_8
INTEREST_OVERDUE decimal 10,3  √  null
INTEREST_OVERDUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_9
FEES_OVERDUE decimal 10,3  √  null
FEES_OVERDUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_10
PENALTY_OVERDUE decimal 10,3  √  null
PENALTY_OVERDUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_11
TOTAL_AMNT_OVERDUE decimal 10,3  √  null
TOTAL_AMNT_OVERDUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_12
TOTAL_AMNT_DUE decimal 10,3  √  null
TOTAL_AMNT_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_13
AMNT_TOBE_DISBURSED decimal 10,3  √  null
AMNT_TOBE_DISBURSED_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_14

Table contained 0 rows at Wed Dec 26 12:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
LOAN_DETAILS_ID Primary key Asc PRIMARY
AMNT_TOBE_DISBURSED_CURRENCY Performance Asc AMNT_TOBE_DISBURSED_CURRENCY
AMNT_TO_CLOSE_LOAN_CURRENCY Performance Asc AMNT_TO_CLOSE_LOAN_CURRENCY
FEES_DUE_CURRENCY Performance Asc FEES_DUE_CURRENCY
FEES_OVERDUE_CURRENCY Performance Asc FEES_OVERDUE_CURRENCY
INTEREST_DUE_CURRENCY Performance Asc INTEREST_DUE_CURRENCY
INTEREST_OVERDUE_CURRENCY Performance Asc INTEREST_OVERDUE_CURRENCY
ORIG_LOAN_AMNT_CURRENCY Performance Asc ORIG_LOAN_AMNT_CURRENCY
PENALTY_DUE_CURRENCY Performance Asc PENALTY_DUE_CURRENCY
PENALTY_OVERDUE_CURRENCY Performance Asc PENALTY_OVERDUE_CURRENCY
PRINCIPAL_DUE_CURRENCY Performance Asc PRINCIPAL_DUE_CURRENCY
PRINCIPAL_OVERDUE_CURRENCY Performance Asc PRINCIPAL_OVERDUE_CURRENCY
TOTAL_AMNT_DUE_CURRENCY Performance Asc TOTAL_AMNT_DUE_CURRENCY
TOTAL_AMNT_OVERDUE_CURRENCY Performance Asc TOTAL_AMNT_OVERDUE_CURRENCY
TOTAL_PRIN_DUE_CURRENCY Performance Asc TOTAL_PRIN_DUE_CURRENCY
TOTAL_SCHEDULED_AMNT_DUE_CURRENCY Performance Asc TOTAL_SCHEDULED_AMNT_DUE_CURRENCY

Close relationships  within one two degrees of separation :