Table db160.coll_sheet_customer 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
COLL_SHEET_CUST_ID bigint 20  √ 
coll_sheet_loan_details.COLL_SHEET_CUST_ID Implied Constraint
COLL_SHEET_ID int 11
coll_sheet.COLL_SHEET_ID Implied Constraint
CUST_ID int 11
CUST_DISPLAY_NAME varchar 200
TOTAL_DUE_SAVINGS_LOAN decimal 10,3  √  null
TOTAL_DUE_SAVINGS_LOAN_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_1
CUST_ACCNT_FEE decimal 10,3  √  null
CUST_ACCNT_FEE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_2
CUST__ACCNT_PENALTY decimal 10,3  √  null
CUST__ACCNT_PENALTY_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_3
CUST_LEVEL smallint 6
CUST_ACCNT_ID int 11  √  null
CUST_OFFICE_ID smallint 6
SEARCH_ID varchar 100
PARENT_CUSTOMER_ID int 11  √  null
COLLECTIVE_LN_AMNT_DUE decimal 10,3  √  null
COLLECTIVE_LN_AMNT_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_4
COLLECTIVE_LN_DISBURSAL decimal 10,3  √  null
COLLECTIVE_LN_DISBURSAL_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_5
COLLECTIVE_SAVINGS_DUE decimal 10,3  √  null
COLLECTIVE_SAVINGS_DUE_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_6
COLLECTIVE_ACCNT_CHARGES decimal 10,3  √  null
COLLECTIVE_ACCNT_CHARGES_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_7
COLLECTIVE_TOTAL_CHARGES decimal 10,3  √  null
COLLECTIVE_TOTAL_CHARGES_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_8
COLLECTIVE_NET_CASH_IN decimal 10,3  √  null
COLLECTIVE_NET_CASH_IN_CURRENCY smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_9
LOAN_OFFICER_ID smallint 6  √  null

Table contained 0 rows at Fri Nov 30 11:59 PST 2007

Indexes:
Column(s) Type Sort Constraint Name
COLL_SHEET_CUST_ID Primary key Asc PRIMARY
COLLECTIVE_ACCNT_CHARGES_CURRENCY Performance Asc COLLECTIVE_ACCNT_CHARGES_CURRENCY
COLLECTIVE_LN_AMNT_DUE_CURRENCY Performance Asc COLLECTIVE_LN_AMNT_DUE_CURRENCY
COLLECTIVE_LN_DISBURSAL_CURRENCY Performance Asc COLLECTIVE_LN_DISBURSAL_CURRENCY
COLLECTIVE_NET_CASH_IN_CURRENCY Performance Asc COLLECTIVE_NET_CASH_IN_CURRENCY
COLLECTIVE_SAVINGS_DUE_CURRENCY Performance Asc COLLECTIVE_SAVINGS_DUE_CURRENCY
COLLECTIVE_TOTAL_CHARGES_CURRENCY Performance Asc COLLECTIVE_TOTAL_CHARGES_CURRENCY
CUST_ACCNT_FEE_CURRENCY Performance Asc CUST_ACCNT_FEE_CURRENCY
CUST__ACCNT_PENALTY_CURRENCY Performance Asc CUST__ACCNT_PENALTY_CURRENCY
TOTAL_DUE_SAVINGS_LOAN_CURRENCY Performance Asc TOTAL_DUE_SAVINGS_LOAN_CURRENCY

Close relationships  within one two degrees of separation :