SchemaSpy Analysis of db164 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Dec 13 21:59 PST 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
db164 contains 1363 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
ACCEPTED_PAYMENT_TYPE_ID accepted_payment_type smallint 6  √ 
ACCNT_BALANCE coll_sheet_savings_details decimal 10,3  √  null
ACCNT_BALANCE_CURRENCY coll_sheet_savings_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_savings_details_ibfk_1
ACCNT_ID coll_sheet_loan_details int 11
ACCNT_ID coll_sheet_savings_details int 11
ACCOUNTING_UPDATED financial_trxn smallint 6  √  null
ACCOUNT_ACTION_ID account_action smallint 6
account_trxn.ACCOUNT_ACTION_ID account_trxn_ibfk_2
office_action_payment_type.ACCOUNT_ACTION_ID office_action_payment_type_ibfk_1
savings_activity_details.ACCOUNT_ACTION_ID savings_activity_details_ibfk_3
ACCOUNT_ACTION_ID account_trxn smallint 6
account_action.ACCOUNT_ACTION_ID account_trxn_ibfk_2
ACCOUNT_ACTION_ID office_action_payment_type smallint 6
account_action.ACCOUNT_ACTION_ID office_action_payment_type_ibfk_1
ACCOUNT_ACTION_ID savings_activity_details smallint 6
account_action.ACCOUNT_ACTION_ID savings_activity_details_ibfk_3
ACCOUNT_CUSTOM_FIELD_ID account_custom_field int 11  √ 
ACCOUNT_FEES_DETAIL_ID customer_fee_schedule int 11  √ 
loan_fee_schedule.ACCOUNT_FEES_DETAIL_ID Implied Constraint
ACCOUNT_FEES_DETAIL_ID loan_fee_schedule int 11  √ 
customer_fee_schedule.ACCOUNT_FEES_DETAIL_ID Implied Constraint
ACCOUNT_FEE_AMNT account_fees decimal 10,3
ACCOUNT_FEE_AMNT_CURRENCY_ID account_fees smallint 6  √  null
currency.CURRENCY_ID account_fees_ibfk_3
ACCOUNT_FEE_ID account_fees int 11  √ 
customer_fee_schedule.ACCOUNT_FEE_ID customer_fee_schedule_ibfk_5
fee_trxn_detail.ACCOUNT_FEE_ID fee_trxn_detail_ibfk_1
loan_fee_schedule.ACCOUNT_FEE_ID loan_fee_schedule_ibfk_5
ACCOUNT_FEE_ID customer_fee_schedule int 11
account_fees.ACCOUNT_FEE_ID customer_fee_schedule_ibfk_5
ACCOUNT_FEE_ID fee_trxn_detail int 11  √  null
account_fees.ACCOUNT_FEE_ID fee_trxn_detail_ibfk_1
ACCOUNT_FEE_ID loan_fee_schedule int 11
account_fees.ACCOUNT_FEE_ID loan_fee_schedule_ibfk_5
ACCOUNT_FLAG_ID account_flag_detail int 11  √ 
ACCOUNT_ID account int 11  √ 
account_activity.ACCOUNT_ID account_activity_ibfk_1
account_custom_field.ACCOUNT_ID account_custom_field_ibfk_2
account_fees.ACCOUNT_ID account_fees_ibfk_1
account_flag_detail.ACCOUNT_ID account_flag_detail_ibfk_1
account_notes.ACCOUNT_ID account_notes_ibfk_1
account_payment.ACCOUNT_ID account_payment_ibfk_1
account_status_change_history.ACCOUNT_ID account_status_change_history_ibfk_1
account_trxn.ACCOUNT_ID account_trxn_ibfk_1
customer_account.ACCOUNT_ID customer_account_ibfk_1
customer_account_activity.ACCOUNT_ID customer_account_activity_ibfk_1
customer_schedule.ACCOUNT_ID customer_schedule_ibfk_1
loan_account.ACCOUNT_ID loan_account_ibfk_1
loan_account.PARENT_ACCOUNT_ID loan_account_ibfk_12
loan_activity_details.ACCOUNT_ID loan_activity_details_ibfk_2
loan_arrears_aging.ACCOUNT_ID loan_arrears_aging_ibfk_1
loan_perf_history.ACCOUNT_ID loan_perf_history_ibfk_1
loan_schedule.ACCOUNT_ID loan_schedule_ibfk_1
saving_schedule.ACCOUNT_ID saving_schedule_ibfk_1
savings_account.ACCOUNT_ID savings_account_ibfk_1
savings_activity_details.ACCOUNT_ID savings_activity_details_ibfk_2
savings_performance.ACCOUNT_ID savings_performance_ibfk_1
survey_instance.ACCOUNT_ID survey_instance_ibfk_4
ACCOUNT_ID account_activity int 11
account.ACCOUNT_ID account_activity_ibfk_1
ACCOUNT_ID account_custom_field int 11
account.ACCOUNT_ID account_custom_field_ibfk_2
ACCOUNT_ID account_fees int 11
account.ACCOUNT_ID account_fees_ibfk_1
ACCOUNT_ID account_flag_detail int 11
account.ACCOUNT_ID account_flag_detail_ibfk_1
ACCOUNT_ID account_notes int 11
account.ACCOUNT_ID account_notes_ibfk_1
ACCOUNT_ID account_payment int 11
account.ACCOUNT_ID account_payment_ibfk_1
ACCOUNT_ID account_status_change_history int 11
account.ACCOUNT_ID account_status_change_history_ibfk_1
ACCOUNT_ID account_trxn int 11
account.ACCOUNT_ID account_trxn_ibfk_1
ACCOUNT_ID customer_account int 11
account.ACCOUNT_ID customer_account_ibfk_1
ACCOUNT_ID customer_account_activity int 11
account.ACCOUNT_ID customer_account_activity_ibfk_1
ACCOUNT_ID customer_loan_account_detail int 11
loan_account.ACCOUNT_ID customer_loan_account_detail_ibfk_6
ACCOUNT_ID customer_schedule int 11
account.ACCOUNT_ID customer_schedule_ibfk_1
ACCOUNT_ID loan_account int 11
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
ACCOUNT_ID loan_activity_details int 11
account.ACCOUNT_ID loan_activity_details_ibfk_2
ACCOUNT_ID loan_arrears_aging int 11
account.ACCOUNT_ID loan_arrears_aging_ibfk_1
ACCOUNT_ID loan_penalty int 11  √  null
loan_account.ACCOUNT_ID loan_penalty_ibfk_1
ACCOUNT_ID loan_perf_history int 11
account.ACCOUNT_ID loan_perf_history_ibfk_1
ACCOUNT_ID loan_schedule int 11
account.ACCOUNT_ID loan_schedule_ibfk_1
ACCOUNT_ID loan_summary int 11
loan_account.ACCOUNT_ID loan_summary_ibfk_9
ACCOUNT_ID max_min_loan_amount int 11  √ 
loan_account.ACCOUNT_ID max_min_loan_amount_ibfk_1
ACCOUNT_ID max_min_no_of_install int 11  √ 
loan_account.ACCOUNT_ID max_min_no_of_install_ibfk_1
ACCOUNT_ID saving_schedule int 11
account.ACCOUNT_ID saving_schedule_ibfk_1
ACCOUNT_ID savings_account int 11
account.ACCOUNT_ID savings_account_ibfk_1
ACCOUNT_ID savings_activity_details int 11
account.ACCOUNT_ID savings_activity_details_ibfk_2
ACCOUNT_ID savings_performance int 11
account.ACCOUNT_ID savings_performance_ibfk_1
ACCOUNT_ID survey_instance int 11  √  null
account.ACCOUNT_ID survey_instance_ibfk_4
ACCOUNT_ID waive_off_history int 11
loan_account.ACCOUNT_ID waive_off_history_ibfk_1
ACCOUNT_NOTES_ID account_notes int 11  √ 
ACCOUNT_STATE_ID account smallint 6  √  null
account_state.ACCOUNT_STATE_ID account_ibfk_1
ACCOUNT_STATE_ID account_state smallint 6  √ 
account.ACCOUNT_STATE_ID account_ibfk_1
account_state_flag.STATUS_ID account_state_flag_ibfk_1
account_status_change_history.NEW_STATUS account_status_change_history_ibfk_3
account_status_change_history.OLD_STATUS account_status_change_history_ibfk_2
prd_checklist.ACCOUNT_STATUS prd_checklist_ibfk_1
ACCOUNT_STATUS prd_checklist smallint 6
account_state.ACCOUNT_STATE_ID prd_checklist_ibfk_1
ACCOUNT_STATUS_CHANGE_ID account_status_change_history int 11  √ 
ACCOUNT_TRXN_ID account_trxn int 11  √ 
customer_loan_account_detail.ACCOUNT_TRXN_ID customer_loan_account_detail_ibfk_1
customer_trxn_detail.ACCOUNT_TRXN_ID customer_trxn_detail_ibfk_4
fee_trxn_detail.ACCOUNT_TRXN_ID fee_trxn_detail_ibfk_3
financial_trxn.ACCOUNT_TRXN_ID financial_trxn_ibfk_1
loan_trxn_detail.ACCOUNT_TRXN_ID loan_trxn_detail_ibfk_6
savings_trxn_detail.ACCOUNT_TRXN_ID savings_trxn_detail_ibfk_1
ACCOUNT_TRXN_ID customer_loan_account_detail int 11
account_trxn.ACCOUNT_TRXN_ID customer_loan_account_detail_ibfk_1
ACCOUNT_TRXN_ID customer_trxn_detail int 11
account_trxn.ACCOUNT_TRXN_ID customer_trxn_detail_ibfk_4
ACCOUNT_TRXN_ID fee_trxn_detail int 11
account_trxn.ACCOUNT_TRXN_ID fee_trxn_detail_ibfk_3
ACCOUNT_TRXN_ID financial_trxn int 11
account_trxn.ACCOUNT_TRXN_ID financial_trxn_ibfk_1
ACCOUNT_TRXN_ID loan_trxn_detail int 11
account_trxn.ACCOUNT_TRXN_ID loan_trxn_detail_ibfk_6
ACCOUNT_TRXN_ID savings_trxn_detail int 11
account_trxn.ACCOUNT_TRXN_ID savings_trxn_detail_ibfk_1
ACCOUNT_TYPE_ID account smallint 6
account_type.ACCOUNT_TYPE_ID account_ibfk_2
ACCOUNT_TYPE_ID account_type smallint 6  √ 
account.ACCOUNT_TYPE_ID account_ibfk_2
ACTION_DATE account_trxn date 10
ACTION_DATE customer_schedule date 10  √  null
ACTION_DATE financial_trxn date 10
ACTION_DATE loan_schedule date 10  √  null
ACTION_DATE saving_schedule date 10  √  null
ACTIVATION_DATE savings_account date 10  √  null
ACTIVE_LOANS_COUNT cust_perf_history smallint 6  √  null
ACTIVITY_ID account_activity int 11  √ 
ACTIVITY_ID activity smallint 6  √ 
activity.PARENT_ID activity_ibfk_1
report.ACTIVITY_ID Implied Constraint
report_category.ACTIVITY_ID Implied Constraint
roles_activity.ACTIVITY_ID roles_activity_ibfk_1
ACTIVITY_ID report smallint 6  √  null
activity.ACTIVITY_ID Implied Constraint
ACTIVITY_ID report_category smallint 6  √  null
activity.ACTIVITY_ID Implied Constraint
ACTIVITY_ID roles_activity smallint 6
activity.ACTIVITY_ID roles_activity_ibfk_1
ACTIVITY_NAME account_activity varchar 50
ACTIVITY_NAME_LOOKUP_ID activity int 11
lookup_value.LOOKUP_ID activity_ibfk_2
ADDRESS_1 office_address varchar 200  √  null
ADDRESS_1 personnel_details varchar 200  √  null
ADDRESS_2 office_address varchar 200  √  null
ADDRESS_2 personnel_details varchar 200  √  null
ADDRESS_3 office_address varchar 200  √  null
ADDRESS_3 personnel_details varchar 200  √  null
ADDRESS_NAME customer_address_detail varchar 100  √  null
ADDRESS_STATUS customer_address_detail smallint 6  √  null
AMNT_OVERDUE coll_sheet_savings_details decimal 10,3  √  null
AMNT_OVERDUE_CURRENCY coll_sheet_savings_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_savings_details_ibfk_3
AMNT_TOBE_DISBURSED coll_sheet_loan_details decimal 10,3  √  null
AMNT_TOBE_DISBURSED_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_14
AMNT_TO_CLOSE_LOAN coll_sheet_loan_details decimal 10,3
AMNT_TO_CLOSE_LOAN_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_2
AMOUNT account_payment decimal 10,3
AMOUNT account_trxn decimal 10,3
AMOUNT customer_account_activity decimal 10,3  √  null
AMOUNT customer_fee_schedule decimal 10,3  √  null
AMOUNT loan_fee_schedule decimal 10,3  √  null
AMOUNT savings_activity_details decimal 10,3
AMOUNT_CURRENCY_ID account_trxn smallint 6  √  null
currency.CURRENCY_ID account_trxn_ibfk_5
AMOUNT_CURRENCY_ID customer_fee_schedule smallint 6  √  null
currency.CURRENCY_ID customer_fee_schedule_ibfk_2
AMOUNT_CURRENCY_ID loan_fee_schedule smallint 6  √  null
currency.CURRENCY_ID loan_fee_schedule_ibfk_2
AMOUNT_CURRENCY_ID savings_activity_details smallint 6
currency.CURRENCY_ID savings_activity_details_ibfk_4
AMOUNT_PAID customer_fee_schedule decimal 10,3  √  null
AMOUNT_PAID loan_fee_schedule decimal 10,3  √  null
AMOUNT_PAID_CURRENCY_ID customer_fee_schedule smallint 6  √  null
currency.CURRENCY_ID customer_fee_schedule_ibfk_3
AMOUNT_PAID_CURRENCY_ID loan_fee_schedule smallint 6  √  null
currency.CURRENCY_ID loan_fee_schedule_ibfk_3
ANSWER_TYPE checklist_detail smallint 6
ANSWER_TYPE questions int 11
ATTENDANCE attendance smallint 6  √  null
ATTENDANCE customer_attendance smallint 6  √  null
ATTENDANCE_ID customer_attendance_types smallint 6  √ 
ATTENDANCE_LOOKUP_ID customer_attendance_types int 11
lookup_value.LOOKUP_ID customer_attendance_types_ibfk_1
ATTRIBUTE_ID mfi_attribute smallint 6
ATTRIBUTE_NAME mfi_attribute varchar 100
ATTRIBUTE_VALUE mfi_attribute varchar 200
AT_RISK_MAX ppi_survey int 11
AT_RISK_MIN ppi_survey int 11
AVG_LOAN_SIZE group_perf_history decimal 10,3  √  null
AVG_LOAN_SIZE_CURRENCY_ID group_perf_history smallint 6  √  null
BACK_DATED_TXN_ALLOWED system_configuration smallint 6  √  null
BALANCE savings_trxn_detail decimal 10,3  √  null
BALANCE_AMOUNT financial_trxn decimal 10,3
BALANCE_AMOUNT savings_activity_details decimal 10,3
BALANCE_AMOUNT_CURRENCY_ID financial_trxn smallint 6  √  null
currency.CURRENCY_ID financial_trxn_ibfk_4
BALANCE_AMOUNT_CURRENCY_ID savings_activity_details smallint 6
currency.CURRENCY_ID savings_activity_details_ibfk_5
BALANCE_CURRENCY_ID savings_trxn_detail smallint 6
currency.CURRENCY_ID savings_trxn_detail_ibfk_5
BALANCE_FEE_AMOUNT loan_activity_details decimal 10,3  √  null
BALANCE_FEE_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_10
BALANCE_INTEREST_AMOUNT loan_activity_details decimal 10,3  √  null
BALANCE_INTEREST_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_8
BALANCE_PENALTY_AMOUNT loan_activity_details decimal 10,3  √  null
BALANCE_PENALTY_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_9
BALANCE_PRINCIPAL_AMOUNT loan_activity_details decimal 10,3  √  null
BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_7
BANK_NAME account_payment varchar 50  √  null
BLACKLISTED customer smallint 6  √  null
BRANCH_ID customer smallint 6  √  null
office.OFFICE_ID customer_ibfk_3
BUSINESS_ACTIVITIES customer_detail int 11  √  null
BUSINESS_ACTIVITIES_ID loan_account int 11  √  null
lookup_value.LOOKUP_ID loan_account_ibfk_10
CATEGORY_ID category_type smallint 6
fee_payments_categories_type.CATEGORY_ID fee_payments_categories_type_ibfk_1
fees.CATEGORY_ID fees_ibfk_2
penalty.CATEGORY_ID penalty_ibfk_1
CATEGORY_ID fee_payments_categories_type smallint 6  √  null
category_type.CATEGORY_ID fee_payments_categories_type_ibfk_1
CATEGORY_ID fees smallint 6
category_type.CATEGORY_ID fees_ibfk_2
CATEGORY_ID interest_types smallint 6
prd_type.PRD_TYPE_ID interest_types_ibfk_1
CATEGORY_ID penalty smallint 6  √  null
category_type.CATEGORY_ID penalty_ibfk_1
CATEGORY_LOOKUP_ID category_type int 11
lookup_value.LOOKUP_ID category_type_ibfk_1
CENTER_HIERARCHY_EXIST system_configuration smallint 6  √  null
CHANGED_BY account_status_change_history smallint 6
personnel.PERSONNEL_ID account_status_change_history_ibfk_4
CHANGED_BY change_log smallint 6
personnel.PERSONNEL_ID change_log_ibfk_1
CHANGED_DATE account_status_change_history date 10
CHANGED_DATE change_log date 10  √  null
CHANGE_LOG_ID change_log int 11  √ 
change_log_detail.CHANGE_LOG_ID change_log_detail_ibfk_1
CHANGE_LOG_ID change_log_detail int 11
change_log.CHANGE_LOG_ID change_log_detail_ibfk_1
CHECKLIST_ID checklist smallint 6  √ 
checklist_detail.CHECKLIST_ID checklist_detail_ibfk_1
customer_checklist.CHECKLIST_ID customer_checklist_ibfk_1
prd_checklist.CHECKLIST_ID prd_checklist_ibfk_2
CHECKLIST_ID checklist_detail smallint 6  √  null
checklist.CHECKLIST_ID checklist_detail_ibfk_1
CHECKLIST_ID customer_checklist smallint 6
checklist.CHECKLIST_ID customer_checklist_ibfk_1
CHECKLIST_ID prd_checklist smallint 6
checklist.CHECKLIST_ID prd_checklist_ibfk_2
CHECKLIST_NAME checklist varchar 100  √  null
CHECKLIST_STATUS checklist smallint 6 1
CHECK_NUMBER account_payment varchar 50  √  null
CHOICE_ID question_choices int 11  √ 
survey_response.CHOICE_VALUE survey_response_ibfk_3
CHOICE_ORDER question_choices int 11
CHOICE_TEXT question_choices varchar 200
CHOICE_VALUE survey_response int 11  √  null
question_choices.CHOICE_ID survey_response_ibfk_3
CITIZENSHIP customer_detail int 11  √  null
lookup_value.LOOKUP_ID customer_detail_ibfk_2
CITY customer_address_detail varchar 100  √  null
CITY office_address varchar 100  √  null
CITY personnel_details varchar 100  √  null
CLASSNAME report_parameter varchar 255
CLASS_NAME logmessages varchar 50  √  null
CLIENT_CAN_EXIST_OUTSIDE_GROUP system_configuration smallint 6  √  null
CLIENT_CONFIDENTIAL customer smallint 6  √  null
CLIENT_OFFERING_ID client_initial_savings_offering int 11  √ 
CLIENT_PERF_ID loan_counter int 11
CLOSED_DATE account date 10  √  null
COA_ID coa smallint 6  √ 
coa_idmapper.COA_ID coa_idmapper_ibfk_1
coahierarchy.COA_ID coahierarchy_ibfk_1
coahierarchy.PARENT_COAID coahierarchy_ibfk_2
COA_ID coa_idmapper smallint 6
coa.COA_ID coa_idmapper_ibfk_1
COA_ID coahierarchy smallint 6
coa.COA_ID coahierarchy_ibfk_1
COA_Name coa varchar 150
CODE_ID office_code smallint 6  √ 
office.OFFICE_CODE_ID office_ibfk_4
COLLATERAL_NOTE loan_account text 65535  √  null
COLLATERAL_TYPE_ID collateral_type smallint 6
loan_account.COLLATERAL_TYPE_ID loan_account_ibfk_9
COLLATERAL_TYPE_ID loan_account smallint 6  √  null
collateral_type.COLLATERAL_TYPE_ID loan_account_ibfk_9
COLLECTIVE_ACCNT_CHARGES coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_ACCNT_CHARGES_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_7
COLLECTIVE_LN_AMNT_DUE coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_LN_AMNT_DUE_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_4
COLLECTIVE_LN_DISBURSAL coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_LN_DISBURSAL_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_5
COLLECTIVE_NET_CASH_IN coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_NET_CASH_IN_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_9
COLLECTIVE_SAVINGS_DUE coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_SAVINGS_DUE_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_6
COLLECTIVE_TOTAL_CHARGES coll_sheet_customer decimal 10,3  √  null
COLLECTIVE_TOTAL_CHARGES_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_8
COLL_SHEET_CUST_ID coll_sheet_customer bigint 20  √ 
coll_sheet_loan_details.COLL_SHEET_CUST_ID Implied Constraint
COLL_SHEET_CUST_ID coll_sheet_loan_details bigint 20
coll_sheet_customer.COLL_SHEET_CUST_ID Implied Constraint
COLL_SHEET_CUST_ID coll_sheet_savings_details int 11
COLL_SHEET_DATE coll_sheet date 10
COLL_SHEET_ID coll_sheet int 11  √ 
coll_sheet_customer.COLL_SHEET_ID Implied Constraint
COLL_SHEET_ID coll_sheet_customer int 11
coll_sheet.COLL_SHEET_ID Implied Constraint
COMMENT customer_note varchar 500
COMMENTS account_trxn varchar 200  √  null
COMMENTS loan_activity_details varchar 100
COMMENTS personnel_notes varchar 500
COMMENT_DATE account_notes date 10
COMMENT_DATE customer_note date 10
COMMENT_DATE personnel_notes date 10
COMMENT_ID customer_note int 11  √ 
personnel_notes.COMMENT_ID Implied Constraint
COMMENT_ID personnel_notes int 11  √ 
customer_note.COMMENT_ID Implied Constraint
COMPLETED_STATUS survey_instance int 11
CONFIDENTIALITY program smallint 6  √  null
CONFIGURATION_ID config_key_value_integer int 11  √ 
CONFIGURATION_KEY config_key_value_integer varchar 100
CONFIGURATION_VALUE config_key_value_integer int 11
CONFIGURED office_level smallint 6
CONSTANT_ID coa_idmapper smallint 6
COUNTRY customer_address_detail varchar 100  √  null
COUNTRY office_address varchar 100  √  null
COUNTRY personnel_details varchar 100  √  null
COUNTRY_ID country smallint 6
supported_locale.COUNTRY_ID supported_locale_ibfk_1
COUNTRY_ID ppi_survey int 11
COUNTRY_ID supported_locale smallint 6  √  null
country.COUNTRY_ID supported_locale_ibfk_1
COUNTRY_NAME country varchar 100  √  null
COUNTRY_SHORT_NAME country varchar 10  √  null
CREATED_BY account smallint 6
CREATED_BY account_flag_detail smallint 6
personnel.PERSONNEL_ID account_flag_detail_ibfk_3
CREATED_BY checklist smallint 6  √  null
personnel.PERSONNEL_ID checklist_ibfk_2
CREATED_BY customer smallint 6  √  null
CREATED_BY customer_account_activity smallint 6  √  null
personnel.PERSONNEL_ID customer_account_activity_ibfk_3
CREATED_BY customer_flag_detail smallint 6  √  null
personnel.PERSONNEL_ID customer_flag_detail_ibfk_3
CREATED_BY customer_historical_data smallint 6  √  null
CREATED_BY fees smallint 6
personnel.PERSONNEL_ID fees_ibfk_5
CREATED_BY loan_activity_details smallint 6
personnel.PERSONNEL_ID loan_activity_details_ibfk_1
CREATED_BY office smallint 6  √  null
CREATED_BY personnel smallint 6
personnel.PERSONNEL_ID personnel_ibfk_2
CREATED_BY prd_category int 11  √  null
CREATED_BY prd_offering int 11
CREATED_BY prd_offering_mix smallint 6  √  null
CREATED_BY role smallint 6  √  null
personnel.PERSONNEL_ID role_ibfk_1
CREATED_BY savings_activity_details smallint 6  √  null
personnel.PERSONNEL_ID savings_activity_details_ibfk_1
CREATED_DATE account date 10
CREATED_DATE account_flag_detail date 10
CREATED_DATE account_trxn timestamp 19 CURRENT_TIMESTAMP
CREATED_DATE checklist date 10  √  null
CREATED_DATE customer date 10  √  null
CREATED_DATE customer_account_activity date 10
CREATED_DATE customer_flag_detail date 10  √  null
CREATED_DATE customer_historical_data date 10  √  null
CREATED_DATE fees date 10
CREATED_DATE loan_activity_details timestamp 19 CURRENT_TIMESTAMP
CREATED_DATE office date 10  √  null
CREATED_DATE personnel date 10  √  null
CREATED_DATE prd_category date 10  √  null
CREATED_DATE prd_offering date 10
CREATED_DATE prd_offering_mix date 10  √  null
CREATED_DATE role date 10  √  null
CREATED_DATE savings_activity_details timestamp 19 CURRENT_TIMESTAMP
CREATING_OFFICER_ID survey_instance smallint 6
personnel.PERSONNEL_ID survey_instance_ibfk_5
CURRENCY_CODE currency varchar 3  √  null
CURRENCY_ID account_payment smallint 6  √  null
currency.CURRENCY_ID account_payment_ibfk_2
CURRENCY_ID account_trxn smallint 6  √  null
currency.CURRENCY_ID account_trxn_ibfk_4
CURRENCY_ID currency 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_ID customer_loan_account_detail smallint 6  √  null
currency.CURRENCY_ID customer_loan_account_detail_ibfk_2
CURRENCY_ID customer_schedule smallint 6  √  null
currency.CURRENCY_ID customer_schedule_ibfk_2
CURRENCY_ID financial_trxn smallint 6  √  null
currency.CURRENCY_ID financial_trxn_ibfk_5
CURRENCY_ID loan_account smallint 6  √  null
currency.CURRENCY_ID loan_account_ibfk_2
CURRENCY_ID loan_schedule smallint 6  √  null
currency.CURRENCY_ID loan_schedule_ibfk_2
CURRENCY_ID saving_schedule smallint 6  √  null
currency.CURRENCY_ID saving_schedule_ibfk_2
CURRENCY_NAME currency varchar 50  √  null
CURRENTLY_IN_USE account_state smallint 6
CURRENTLY_IN_USE customer_state smallint 6
CURRENTLY_IN_USE prd_status smallint 6
CURRENT_INSTALLMENT_NO coll_sheet_loan_details smallint 6  √  null
CUSTOMER_ACCOUNT_ACTIVITY_ID customer_account_activity int 11  √ 
CUSTOMER_ACTIVATION_DATE customer date 10  √  null
CUSTOMER_ADDRESS_ID customer_address_detail int 11  √ 
CUSTOMER_CUSTOMFIELD_ID customer_custom_field int 11  √ 
CUSTOMER_FLAG_ID customer_flag_detail int 11  √ 
CUSTOMER_FORMEDBY_ID customer smallint 6  √  null
personnel.PERSONNEL_ID customer_ibfk_5
CUSTOMER_ID account int 11  √  null
customer.CUSTOMER_ID account_ibfk_3
CUSTOMER_ID account_trxn int 11  √  null
customer.CUSTOMER_ID account_trxn_ibfk_6
CUSTOMER_ID client_initial_savings_offering int 11
customer.CUSTOMER_ID client_initial_savings_offering_ibfk_1
CUSTOMER_ID client_perf_history int 11
customer.CUSTOMER_ID client_perf_history_ibfk_1
CUSTOMER_ID cust_perf_history int 11
customer.CUSTOMER_ID cust_perf_history_ibfk_1
CUSTOMER_ID customer int 11  √ 
account.CUSTOMER_ID account_ibfk_3
account_trxn.CUSTOMER_ID account_trxn_ibfk_6
client_initial_savings_offering.CUSTOMER_ID client_initial_savings_offering_ibfk_1
client_perf_history.CUSTOMER_ID client_perf_history_ibfk_1
cust_perf_history.CUSTOMER_ID cust_perf_history_ibfk_1
customer_address_detail.CUSTOMER_ID customer_address_detail_ibfk_1
customer_attendance.CUSTOMER_ID customer_attendance_ibfk_1
customer_custom_field.CUSTOMER_ID customer_custom_field_ibfk_2
customer_detail.CUSTOMER_ID customer_detail_ibfk_1
customer_flag_detail.CUSTOMER_ID customer_flag_detail_ibfk_1
customer_hierarchy.CUSTOMER_ID customer_hierarchy_ibfk_1
customer_hierarchy.PARENT_ID customer_hierarchy_ibfk_2
customer_historical_data.CUSTOMER_ID customer_historical_data_ibfk_1
customer_meeting.CUSTOMER_ID customer_meeting_ibfk_1
customer_movement.CUSTOMER_ID customer_movement_ibfk_1
customer_name_detail.CUSTOMER_ID customer_name_detail_ibfk_1
customer_note.CUSTOMER_ID customer_note_ibfk_1
customer_picture.CUSTOMER_ID customer_picture_ibfk_1
customer_position.CUSTOMER_ID customer_position_ibfk_1
customer_program.CUSTOMER_ID customer_program_ibfk_1
customer_schedule.CUSTOMER_ID customer_schedule_ibfk_3
group_perf_history.CUSTOMER_ID group_perf_history_ibfk_1
inherited_meeting.CUSTOMER_ID inherited_meeting_ibfk_1
loan_arrears_aging.CUSTOMER_ID loan_arrears_aging_ibfk_2
loan_arrears_aging.PARENT_CUSTOMER_ID loan_arrears_aging_ibfk_3
loan_schedule.CUSTOMER_ID loan_schedule_ibfk_13
saving_schedule.CUSTOMER_ID saving_schedule_ibfk_5
survey_instance.CUSTOMER_ID survey_instance_ibfk_2
CUSTOMER_ID customer_address_detail int 11  √  null
customer.CUSTOMER_ID customer_address_detail_ibfk_1
CUSTOMER_ID customer_attendance int 11
customer.CUSTOMER_ID customer_attendance_ibfk_1
CUSTOMER_ID customer_custom_field int 11
customer.CUSTOMER_ID customer_custom_field_ibfk_2
CUSTOMER_ID customer_detail int 11
customer.CUSTOMER_ID customer_detail_ibfk_1
CUSTOMER_ID customer_flag_detail int 11
customer.CUSTOMER_ID customer_flag_detail_ibfk_1
CUSTOMER_ID customer_hierarchy int 11  √  null
customer.CUSTOMER_ID customer_hierarchy_ibfk_1
CUSTOMER_ID customer_historical_data int 11
customer.CUSTOMER_ID customer_historical_data_ibfk_1
CUSTOMER_ID customer_meeting int 11
customer.CUSTOMER_ID customer_meeting_ibfk_1
CUSTOMER_ID customer_movement int 11  √  null
customer.CUSTOMER_ID customer_movement_ibfk_1
CUSTOMER_ID customer_name_detail int 11  √  null
customer.CUSTOMER_ID customer_name_detail_ibfk_1
CUSTOMER_ID customer_note int 11
customer.CUSTOMER_ID customer_note_ibfk_1
CUSTOMER_ID customer_picture int 11
customer.CUSTOMER_ID customer_picture_ibfk_1
CUSTOMER_ID customer_position int 11  √  null
customer.CUSTOMER_ID customer_position_ibfk_1
CUSTOMER_ID customer_program int 11
customer.CUSTOMER_ID customer_program_ibfk_1
CUSTOMER_ID customer_schedule int 11
customer.CUSTOMER_ID customer_schedule_ibfk_3
CUSTOMER_ID group_perf_history int 11
customer.CUSTOMER_ID group_perf_history_ibfk_1
CUSTOMER_ID inherited_meeting int 11  √  null
customer.CUSTOMER_ID inherited_meeting_ibfk_1
CUSTOMER_ID loan_arrears_aging int 11
customer.CUSTOMER_ID loan_arrears_aging_ibfk_2
CUSTOMER_ID loan_schedule int 11
customer.CUSTOMER_ID loan_schedule_ibfk_13
CUSTOMER_ID saving_schedule int 11
customer.CUSTOMER_ID saving_schedule_ibfk_5
CUSTOMER_ID survey_instance int 11  √  null
customer.CUSTOMER_ID survey_instance_ibfk_2
CUSTOMER_LEVEL_ID customer smallint 6
customer_level.LEVEL_ID customer_ibfk_1
CUSTOMER_MEETING_ID customer_meeting int 11  √ 
attendance.MEETING_ID attendance_ibfk_1
customer_meeting_detail.MEETING_ID customer_meeting_detail_ibfk_1
inherited_meeting.MEETING_ID inherited_meeting_ibfk_2
CUSTOMER_MOVEMENT_ID customer_movement int 11  √ 
CUSTOMER_NAME loan_arrears_aging varchar 200  √  null
CUSTOMER_NAME_ID customer_name_detail int 11  √ 
CUSTOMER_POSITION_ID customer_position smallint 6  √ 
CUSTOMER_STATUS_ID customer_checklist smallint 6
customer_state.STATUS_ID customer_checklist_ibfk_3
CUST_ACCNT_FEE coll_sheet_customer decimal 10,3  √  null
CUST_ACCNT_FEE_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_2
CUST_ACCNT_ID coll_sheet_customer int 11  √  null
CUST_DISPLAY_NAME coll_sheet_customer varchar 200
CUST_ID coll_sheet_customer int 11
CUST_LEVEL coll_sheet_customer smallint 6
CUST_OFFICE_ID coll_sheet_customer smallint 6
CUST__ACCNT_PENALTY coll_sheet_customer decimal 10,3  √  null
CUST__ACCNT_PENALTY_CURRENCY coll_sheet_customer smallint 6  √  null
currency.CURRENCY_ID coll_sheet_customer_ibfk_3
DATA report_parameter text 65535  √  null
DATABASE_VERSION database_version int 11  √  null
DATASOURCE_ID report_datasource int 11  √ 
report_parameter.DATASOURCE_ID Implied Constraint
DATASOURCE_ID report_parameter int 11  √  null
report_datasource.DATASOURCE_ID Implied Constraint
DATE logmessages varchar 50  √  null
DATE_CONDUCTED survey_instance date 10
DATE_OF_BIRTH customer date 10  √  null
DATE_OF_CREATION survey date 10
DATE_OF_JOINING_BRANCH personnel_details date 10  √  null
DATE_OF_JOINING_MFI personnel_details date 10  √  null
DATE_OF_LEAVING_BRANCH personnel_details date 10  √  null
DATE_STARTED customer_detail date 10  √  null
DATE_VALUE survey_response date 10  √  null
DAYS recur_on_day smallint 6  √  null
week_days_master.WEEK_DAYS_MASTER_ID recur_on_day_ibfk_2
DAYS_IN_ARREARS loan_arrears_aging smallint 6
DAYS_IN_ARREARS loan_perf_history smallint 6  √  null
DAY_NUMBER recur_on_day smallint 6  √  null
DEBIT_CREDIT_FLAG financial_trxn smallint 6
DEFAULT_ADMIN_FEE fees varchar 10  √  null
DEFAULT_CURRENCY currency smallint 6  √  null
DEFAULT_DIGITS_AFTER_DECIMAL currency smallint 6
DEFAULT_LOAN_AMOUNT loan_amount_from_last_loan decimal 10,3
DEFAULT_LOAN_AMOUNT loan_amount_from_loan_cycle decimal 10,3
DEFAULT_LOAN_AMOUNT loan_amount_same_for_all_loan decimal 10,3
DEFAULT_LOAN_AMOUNT loan_offering decimal 10,3  √  null
DEFAULT_LOAN_AMOUNT_CURRENCY_ID loan_offering smallint 6  √  null
currency.CURRENCY_ID loan_offering_ibfk_8
DEFAULT_LOCALE supported_locale smallint 6  √  null
DEFAULT_NO_INSTALL no_of_install_from_last_loan decimal 10,3
DEFAULT_NO_INSTALL no_of_install_from_loan_cycle decimal 10,3
DEFAULT_NO_INSTALL no_of_install_same_for_all_loan decimal 10,3
DEFAULT_VALUE custom_field_definition varchar 200  √  null
DEF_INTEREST_RATE loan_offering decimal 13,10
DEF_NO_INSTALLMENTS loan_offering smallint 6  √  null
DELINQUINT_PORTFOLIO client_perf_history decimal 10,3  √  null
DELINQUINT_PORTFOLIO cust_perf_history decimal 10,3  √  null
DELINQUINT_PORTFOLIO_CURRENCY_ID client_perf_history smallint 6  √  null
DEPOSIT saving_schedule decimal 10,3
DEPOSIT_AMOUNT savings_trxn_detail decimal 10,3  √  null
DEPOSIT_AMOUNT_CURRENCY_ID savings_trxn_detail smallint 6  √  null
currency.CURRENCY_ID savings_trxn_detail_ibfk_2
DEPOSIT_CURRENCY_ID saving_schedule smallint 6  √  null
currency.CURRENCY_ID saving_schedule_ibfk_3
DEPOSIT_GLCODE_ID savings_offering smallint 6
gl_code.GLCODE_ID savings_offering_ibfk_8
DEPOSIT_PAID saving_schedule decimal 10,3  √  null
DEPOSIT_PAID_CURRENCY_ID saving_schedule smallint 6  √  null
currency.CURRENCY_ID saving_schedule_ibfk_4
DESCRIPTION account_type varchar 50  √  null
DESCRIPTION coa_idmapper varchar 50  √  null
DESCRIPTION customer_account_activity varchar 200
DESCRIPTION customer_attendance_types varchar 50  √  null
DESCRIPTION customer_state varchar 200  √  null
DESCRIPTION interest_calculation_types varchar 100  √  null
DESCRIPTION lookup_entity varchar 200  √  null
DESCRIPTION meeting_type varchar 200
DESCRIPTION prd_category varchar 500  √  null
DESCRIPTION prd_offering varchar 200  √  null
DESCRIPTION recurrence_type varchar 200
DESCRIPTION report_parameter varchar 255  √  null
DESCRIPTION scheduled_tasks varchar 500  √  null
DESCRIPTION_LOOKUP_ID activity int 11
lookup_value.LOOKUP_ID activity_ibfk_3
DESCRIPTON interest_types varchar 50  √  null
DETAILS_ID customer_meeting_detail int 11
recurrence_detail.DETAILS_ID customer_meeting_detail_ibfk_2
DETAILS_ID recur_on_day int 11
recurrence_detail.DETAILS_ID recur_on_day_ibfk_1
DETAILS_ID recurrence_detail int 11  √ 
account_fees.FEE_FREQUENCY account_fees_ibfk_4
customer_meeting_detail.DETAILS_ID customer_meeting_detail_ibfk_2
recur_on_day.DETAILS_ID recur_on_day_ibfk_1
DETAIL_ID checklist_detail int 11  √ 
DETAIL_TEXT checklist_detail varchar 250  √  null
DISBURSEMENT_DATE loan_account date 10  √  null
DISCRIMINATOR customer varchar 20  √  null
DISCRIMINATOR fees varchar 20  √  null
DISPLAY_ADDRESS customer varchar 500  √  null
DISPLAY_NAME customer varchar 200  √  null
DISPLAY_NAME customer_name_detail varchar 200  √  null
DISPLAY_NAME office varchar 200
DISPLAY_NAME personnel varchar 200  √  null
DISPLAY_SYMBOL currency varchar 50  √  null
DOB personnel_details date 10
DORMANCY_DAYS prd_type smallint 6  √  null
DRIVER report_datasource varchar 255  √  null
DUE_DATE account_trxn date 10  √  null
DUE_DATE customer_loan_account_detail date 10
EDUCATION_LEVEL customer_detail int 11  √  null
lookup_value.LOOKUP_ID customer_detail_ibfk_3
EMAIL_ID personnel varchar 255  √  null
ENDTIME scheduled_tasks timestamp 19 0000-00-00 00:00:00
END_DATE account_fees date 10  √  null
END_DATE customer_hierarchy date 10  √  null
END_DATE customer_movement date 10  √  null
END_DATE loan_penalty date 10  √  null
END_DATE meeting date 10  √  null
END_DATE office_hierarchy date 10  √  null
END_DATE personnel_hierarchy date 10
END_DATE personnel_movement date 10  √  null
END_DATE prd_offering date 10  √  null
END_DATE program date 10  √  null
END_RANGE loan_amount_from_last_loan decimal 10,3
END_RANGE no_of_install_from_last_loan decimal 10,3
END_TIME meeting date 10  √  null
ENTITY_ID change_log int 11  √  null
ENTITY_ID custom_field_definition smallint 6
lookup_entity.ENTITY_ID custom_field_definition_ibfk_2
ENTITY_ID field_configuration smallint 6
entity_master.ENTITY_TYPE_ID field_configuration_ibfk_1
ENTITY_ID lookup_entity smallint 6  √ 
custom_field_definition.ENTITY_ID custom_field_definition_ibfk_2
customer_level.LEVEL_NAME_ID customer_level_ibfk_2
fee_type.FEE_LOOKUP_ID fee_type_ibfk_1
lookup_label.ENTITY_ID lookup_label_ibfk_1
lookup_value.ENTITY_ID lookup_value_ibfk_1
ENTITY_ID lookup_label smallint 6  √  null
lookup_entity.ENTITY_ID lookup_label_ibfk_1
ENTITY_ID lookup_value smallint 6  √  null
lookup_entity.ENTITY_ID lookup_value_ibfk_1
ENTITY_NAME lookup_entity varchar 100
ENTITY_NAME lookup_label varchar 200  √  null
ENTITY_TYPE change_log smallint 6  √  null
ENTITY_TYPE custom_field_definition smallint 6
entity_master.ENTITY_TYPE_ID custom_field_definition_ibfk_3
ENTITY_TYPE entity_master varchar 100
ENTITY_TYPE_ID entity_master smallint 6  √ 
custom_field_definition.ENTITY_TYPE custom_field_definition_ibfk_3
field_configuration.ENTITY_ID field_configuration_ibfk_1
ETHINICITY customer_detail int 11  √  null
lookup_value.LOOKUP_ID customer_detail_ibfk_4
EXTERNAL_ID customer varchar 50  √  null
FEE account_activity decimal 13,2  √  null
FEELEVEL_ID feelevel smallint 6  √ 
FEES_DUE coll_sheet_loan_details decimal 10,3  √  null
FEES_DUE_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_5
FEES_OVERDUE coll_sheet_loan_details decimal 10,3  √  null
FEES_OVERDUE_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_10
FEES_PAID loan_summary decimal 10,3  √  null
FEES_PAID_CURRENCY_ID loan_summary smallint 6  √  null
currency.CURRENCY_ID loan_summary_ibfk_7
FEE_AMNT account_fees decimal 10,3
FEE_AMOUNT fee_trxn_detail decimal 10,3
FEE_AMOUNT fees decimal 10,3  √  null
FEE_AMOUNT loan_activity_details decimal 10,3  √  null
FEE_AMOUNT_CURRENCY_ID customer_account_activity smallint 6  √  null
currency.CURRENCY_ID customer_account_activity_ibfk_2
FEE_AMOUNT_CURRENCY_ID fee_trxn_detail smallint 6  √  null
currency.CURRENCY_ID fee_trxn_detail_ibfk_2
FEE_AMOUNT_CURRENCY_ID fees smallint 6  √  null
currency.CURRENCY_ID fees_ibfk_9
FEE_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_5
FEE_CURRENCY_ID account_activity smallint 6  √  null
currency.CURRENCY_ID account_activity_ibfk_6
FEE_FREQUENCY account_fees int 11  √  null
recurrence_detail.DETAILS_ID account_fees_ibfk_4
FEE_FREQUENCYTYPE_ID fee_frequency smallint 6
fee_frequency_type.FEE_FREQUENCY_ID fee_frequency_ibfk_2
FEE_FREQUENCY_ID fee_frequency smallint 6  √ 
fee_frequency_type.FEE_FREQUENCY_ID Implied Constraint
FEE_FREQUENCY_ID fee_frequency_type smallint 6  √ 
fee_frequency.FEE_FREQUENCYTYPE_ID fee_frequency_ibfk_2
fee_frequency.FEE_FREQUENCY_ID Implied Constraint
FEE_ID account_fees smallint 6
fees.FEE_ID account_fees_ibfk_2
FEE_ID customer_fee_schedule smallint 6
fees.FEE_ID customer_fee_schedule_ibfk_4
FEE_ID fee_frequency smallint 6
fees.FEE_ID fee_frequency_ibfk_1
FEE_ID feelevel smallint 6
fees.FEE_ID feelevel_ibfk_1
FEE_ID fees smallint 6  √ 
account_fees.FEE_ID account_fees_ibfk_2
customer_fee_schedule.FEE_ID customer_fee_schedule_ibfk_4
fee_frequency.FEE_ID fee_frequency_ibfk_1
feelevel.FEE_ID feelevel_ibfk_1
loan_fee_schedule.FEE_ID loan_fee_schedule_ibfk_4
prd_fee_frequency.FEE_ID prd_fee_frequency_ibfk_1
prd_offering_fees.FEE_ID prd_offering_fees_ibfk_1
FEE_ID loan_fee_schedule smallint 6
fees.FEE_ID loan_fee_schedule_ibfk_4
FEE_ID prd_fee_frequency smallint 6  √  null
fees.FEE_ID prd_fee_frequency_ibfk_1
FEE_ID prd_offering_fees smallint 6  √  null
fees.FEE_ID prd_offering_fees_ibfk_1
FEE_LOOKUP_ID fee_type smallint 6  √  null
lookup_entity.ENTITY_ID fee_type_ibfk_1
FEE_NAME fees varchar 50
FEE_OUTSTANDING account_activity decimal 13,2  √  null
FEE_OUTSTANDING_CURRENCY_ID account_activity smallint 6  √  null
currency.CURRENCY_ID account_activity_ibfk_7
FEE_PAYMENTS_CATEGORY_TYPE_ID fee_payments_categories_type smallint 6
fees.FEE_PAYMENTS_CATEGORY_TYPE_ID Implied Constraint
FEE_PAYMENTS_CATEGORY_TYPE_ID fees smallint 6  √  null
fee_payments_categories_type.FEE_PAYMENTS_CATEGORY_TYPE_ID Implied Constraint
FEE_PAYMENT_ID fee_payment smallint 6  √ 
fee_frequency.FREQUENCY_PAYMENT_ID fee_frequency_ibfk_3
fee_payments_categories_type.FEE_PAYMENT_ID fee_payments_categories_type_ibfk_2
FEE_PAYMENT_ID fee_payments_categories_type smallint 6  √  null
fee_payment.FEE_PAYMENT_ID fee_payments_categories_type_ibfk_2
FEE_PAYMENT_LOOKUP_ID fee_payment int 11  √  null
lookup_value.LOOKUP_ID fee_payment_ibfk_1
FEE_STATUS account_fees smallint 6  √  null
FEE_TRXN_DETAIL_ID fee_trxn_detail int 11  √ 
FEE_TYPE_ID fee_payments_categories_type smallint 6  √  null
fee_type.FEE_TYPE_ID fee_payments_categories_type_ibfk_3
FEE_TYPE_ID fee_type smallint 6
fee_payments_categories_type.FEE_TYPE_ID fee_payments_categories_type_ibfk_3
FEE_UPDATE_TYPE_ID fee_update_type smallint 6  √ 
FIELDS_CHANGED change_log varchar 250  √  null
FIELD_CONFIG_ID field_configuration int 11  √ 
field_configuration.PARENT_FIELD_CONFIG_ID field_configuration_ibfk_2
FIELD_ID account_custom_field smallint 6
custom_field_definition.FIELD_ID account_custom_field_ibfk_1
FIELD_ID custom_field_definition smallint 6  √ 
account_custom_field.FIELD_ID account_custom_field_ibfk_1
customer_custom_field.FIELD_ID customer_custom_field_ibfk_1
office_custom_field.FIELD_ID Implied Constraint
personnel_custom_field.FIELD_ID personnel_custom_field_ibfk_2
FIELD_ID customer_custom_field smallint 6
custom_field_definition.FIELD_ID customer_custom_field_ibfk_1
FIELD_ID office_custom_field smallint 6
custom_field_definition.FIELD_ID Implied Constraint
FIELD_ID personnel_custom_field smallint 6
custom_field_definition.FIELD_ID personnel_custom_field_ibfk_2
FIELD_NAME change_log_detail varchar 100  √  null
FIELD_NAME field_configuration varchar 100
FIELD_OFFICER_ID customer_note smallint 6
personnel.PERSONNEL_ID customer_note_ibfk_2
FIELD_TYPE custom_field_definition smallint 6  √  null
FIELD_VALUE account_custom_field varchar 200  √  null
FIELD_VALUE customer_custom_field varchar 200  √  null
FIELD_VALUE office_custom_field varchar 200  √  null
FIELD_VALUE personnel_custom_field varchar 100  √  null
FIN_ACTION_ID financial_action smallint 6
financial_trxn.FIN_ACTION_ID financial_trxn_ibfk_7
FIN_ACTION_ID financial_trxn smallint 6  √  null
financial_action.FIN_ACTION_ID financial_trxn_ibfk_7
FIRST_NAME customer varchar 200  √  null
FIRST_NAME customer_name_detail varchar 100
FIRST_NAME personnel_details varchar 100
FLAG_DESCRIPTION account_state_flag varchar 200  √  null
FLAG_DESCRIPTION customer_state_flag varchar 200
FLAG_ID account_flag_detail smallint 6
account_state_flag.FLAG_ID account_flag_detail_ibfk_2
FLAG_ID account_state_flag smallint 6  √ 
account_flag_detail.FLAG_ID account_flag_detail_ibfk_2
customer_state_flag.FLAG_ID Implied Constraint
FLAG_ID customer_flag_detail smallint 6
customer_state_flag.FLAG_ID customer_flag_detail_ibfk_2
FLAG_ID customer_state_flag smallint 6
customer_flag_detail.FLAG_ID customer_flag_detail_ibfk_2
account_state_flag.FLAG_ID Implied Constraint
FLAG_LOOKUP_ID customer_state_flag int 11
lookup_value.LOOKUP_ID customer_state_flag_ibfk_2
FLAT_OR_RATE fee_type smallint 6  √  null
FORMULA fee_type varchar 100  √  null
FORMULA penalty varchar 100  √  null
FORMULAID fee_formula_master smallint 6  √ 
fees.FORMULA_ID fees_ibfk_7
FORMULA_ID fees smallint 6  √  null
fee_formula_master.FORMULAID fees_ibfk_7
FORUMLA_LOOKUP_ID fee_formula_master int 11
lookup_value.LOOKUP_ID fee_formula_master_ibfk_1
FREETEXT_VALUE survey_response text 65535  √  null
FREQUENCY_ID prd_fee_frequency smallint 6
recurrence_type.RECURRENCE_ID prd_fee_frequency_ibfk_3
FREQUENCY_MEETING_ID fee_frequency int 11  √  null
meeting.MEETING_ID fee_frequency_ibfk_4
FREQUENCY_PAYMENT_ID fee_frequency smallint 6  √  null
fee_payment.FEE_PAYMENT_ID fee_frequency_ibfk_3
FREQ_OF_DEPOSITS_ID freq_of_deposits smallint 6  √ 
FUNDCODE_ID fund smallint 6
fund_code.FUNDCODE_ID fund_ibfk_1
FUNDCODE_ID fund_code smallint 6  √ 
fund.FUNDCODE_ID fund_ibfk_1
FUNDCODE_VALUE fund_code varchar 50
FUND_ID fund smallint 6  √ 
loan_account.FUND_ID loan_account_ibfk_5
loan_offering_fund.FUND_ID loan_offering_fund_ibfk_2
offering_fund.FUND_ID offering_fund_ibfk_1
program_fund.FUND_ID program_fund_ibfk_1
FUND_ID loan_account smallint 6  √  null
fund.FUND_ID loan_account_ibfk_5
FUND_ID loan_offering_fund smallint 6
fund.FUND_ID loan_offering_fund_ibfk_2
FUND_ID offering_fund smallint 6  √  null
fund.FUND_ID offering_fund_ibfk_1
FUND_ID program_fund smallint 6  √  null
fund.FUND_ID program_fund_ibfk_1
FUND_NAME fund varchar 100  √  null
GENDER customer_detail smallint 6  √  null
GENDER personnel_details int 11
lookup_value.LOOKUP_ID personnel_details_ibfk_2
GLCODE_ID coa smallint 6
gl_code.GLCODE_ID coa_ibfk_1
GLCODE_ID fees smallint 6
gl_code.GLCODE_ID fees_ibfk_1
GLCODE_ID financial_trxn smallint 6
gl_code.GLCODE_ID financial_trxn_ibfk_9
GLCODE_ID gl_code smallint 6  √ 
coa.GLCODE_ID coa_ibfk_1
fees.GLCODE_ID fees_ibfk_1
financial_trxn.GLCODE_ID financial_trxn_ibfk_9
loan_offering.INTEREST_GLCODE_ID loan_offering_ibfk_2
loan_offering.PENALTIES_GLCODE_ID LOAN_OFFERING_PENALTY_GLCODE
loan_offering.PRINCIPAL_GLCODE_ID loan_offering_ibfk_1
penalty.GLCODE_ID penalty_ibfk_2
prd_offering.GLCODE_ID prd_offering_ibfk_1
program.GLCODE_ID program_ibfk_1
savings_offering.DEPOSIT_GLCODE_ID savings_offering_ibfk_8
savings_offering.INTEREST_GLCODE_ID savings_offering_ibfk_9
GLCODE_ID penalty smallint 6
gl_code.GLCODE_ID penalty_ibfk_2
GLCODE_ID prd_offering smallint 6  √  null
gl_code.GLCODE_ID prd_offering_ibfk_1
GLCODE_ID program smallint 6  √  null
gl_code.GLCODE_ID program_ibfk_1
GLCODE_VALUE gl_code varchar 50
GLOBAL_ACCOUNT_NUM account varchar 100  √  null
GLOBAL_CUST_NUM customer varchar 100  √  null
GLOBAL_FEE_NUM fees varchar 50  √  null
GLOBAL_OFFICE_NUM office varchar 100
GLOBAL_PENALTY_NUM penalty varchar 100  √  null
GLOBAL_PERSONNEL_NUM personnel varchar 100  √  null
GLOBAL_PRD_OFFERING_NUM prd_category varchar 50
GLOBAL_PRD_OFFERING_NUM prd_offering varchar 50
GOVERNMENT_ID customer varchar 50  √  null
GOVERNMENT_ID_NUMBER personnel_details varchar 50  √  null
GRACEPERIOD_TYPE_ID loan_offering smallint 6  √  null
grace_period_type.GRACE_PERIOD_TYPE_ID loan_offering_ibfk_3
GRACE_PERIOD_DURATION loan_account smallint 6  √  null
GRACE_PERIOD_DURATION loan_offering smallint 6  √  null
GRACE_PERIOD_PENALTY loan_account smallint 6  √  null
GRACE_PERIOD_TYPE_ID grace_period_type smallint 6  √ 
loan_account.GRACE_PERIOD_TYPE_ID loan_account_ibfk_6
loan_offering.GRACEPERIOD_TYPE_ID loan_offering_ibfk_3
GRACE_PERIOD_TYPE_ID loan_account smallint 6
grace_period_type.GRACE_PERIOD_TYPE_ID loan_account_ibfk_6
GROUP_CAN_APPLY_LOANS system_configuration smallint 6  √  null
GROUP_FLAG customer smallint 6  √  null
GROUP_FLAG loan_account smallint 6  √  null
HANDICAPPED customer_detail int 11  √  null
lookup_value.LOOKUP_ID customer_detail_ibfk_5
HANDICAPPED_DETAILS customer_detail varchar 200  √  null
HIDDEN_FLAG field_configuration smallint 6
HIERARCHY_ID customer_hierarchy int 11  √ 
personnel_hierarchy.HIERARCHY_ID Implied Constraint
HIERARCHY_ID office_hierarchy int 11  √ 
personnel_hierarchy.HIERARCHY_ID Implied Constraint
HIERARCHY_ID personnel_hierarchy int 11
customer_hierarchy.HIERARCHY_ID Implied Constraint
office_hierarchy.HIERARCHY_ID Implied Constraint
HISTORICAL_ID customer_historical_data smallint 6  √ 
HOLIDAY_CHANGES_APPLIED_FLAG holiday smallint 6  √  1
HOLIDAY_FROM_DATE holiday date 10
HOLIDAY_NAME holiday varchar 100  √  null
HOLIDAY_THRU_DATE holiday date 10  √  null
HO_UPDATED customer smallint 6  √  null
ID client_perf_history int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID customer_attendance int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID customer_fee_schedule int 11
customer_schedule.ID customer_fee_schedule_ibfk_1
ID customer_schedule int 11  √ 
customer_fee_schedule.ID customer_fee_schedule_ibfk_1
loan_arrears_aging.ID Implied Constraint
ID group_perf_history int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID loan_activity_details int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID loan_arrears_aging int 11  √ 
client_perf_history.ID Implied Constraint
customer_attendance.ID Implied Constraint
customer_schedule.ID Implied Constraint
group_perf_history.ID Implied Constraint
loan_activity_details.ID Implied Constraint
loan_perf_history.ID Implied Constraint
loan_schedule.ID Implied Constraint
saving_schedule.ID Implied Constraint
savings_activity_details.ID Implied Constraint
savings_performance.ID Implied Constraint
ID loan_fee_schedule int 11
loan_schedule.ID loan_fee_schedule_ibfk_1
ID loan_perf_history int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID loan_schedule int 11  √ 
loan_fee_schedule.ID loan_fee_schedule_ibfk_1
loan_arrears_aging.ID Implied Constraint
ID saving_schedule int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID savings_activity_details int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID savings_performance int 11  √ 
loan_arrears_aging.ID Implied Constraint
ID temp_id smallint 6  √ 
INHERITED_FLAG account_fees smallint 6  √  null
INSTALLMENT_ID account_trxn smallint 6  √  null
INSTALLMENT_ID coll_sheet_savings_details smallint 6
INSTALLMENT_ID customer_fee_schedule int 11
INSTALLMENT_ID customer_schedule smallint 6
INSTALLMENT_ID loan_fee_schedule int 11
INSTALLMENT_ID loan_schedule smallint 6
INSTALLMENT_ID saving_schedule smallint 6
INSTALLMENT_NUMBER customer_loan_account_detail smallint 6
INSTANCE_ID survey_instance int 11  √ 
survey_response.INSTANCE_ID survey_response_ibfk_2
INSTANCE_ID survey_response int 11
survey_instance.INSTANCE_ID survey_response_ibfk_2
INTERACTION_FLAG customer_level smallint 6  √  null
INTERACTION_FLAG office_level smallint 6  √  null
INTERACTION_FLAG personnel_level smallint 6  √  null
INTEREST account_activity decimal 13,10  √  null
INTEREST customer_loan_account_detail decimal 10,3
INTEREST loan_schedule decimal 10,3
INTEREST_AMOUNT loan_activity_details decimal 10,3  √  null
INTEREST_AMOUNT loan_trxn_detail decimal 10,3  √  null
INTEREST_AMOUNT savings_trxn_detail decimal 10,3  √  null
INTEREST_AMOUNT_CURRENCY_ID loan_activity_details smallint 6  √  null
currency.CURRENCY_ID loan_activity_details_ibfk_4
INTEREST_AMOUNT_CURRENCY_ID loan_trxn_detail smallint 6  √  null
currency.CURRENCY_ID loan_trxn_detail_ibfk_2
INTEREST_AMOUNT_CURRENCY_ID savings_trxn_detail smallint 6  √  null
currency.CURRENCY_ID savings_trxn_detail_ibfk_4
INTEREST_AT_DISB loan_account smallint 6  √  null
INTEREST_CALCULATION_LOOKUP_ID interest_calculation_types int 11
lookup_value.LOOKUP_ID interest_calculation_types_ibfk_1
INTEREST_CALCULATION_TYPE_ID interest_calculation_types smallint 6  √ 
savings_account.INTEREST_CALCULATION_TYPE_ID savings_account_ibfk_8
savings_offering.INTEREST_CALCULATION_TYPE_ID savings_offering_ibfk_4
INTEREST_CALCULATION_TYPE_ID savings_account smallint 6
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID savings_account_ibfk_8
INTEREST_CALCULATION_TYPE_ID savings_offering smallint 6
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID savings_offering_ibfk_4
INTEREST_CALC_RULE_ID interest_calc_rule smallint 6  √ 
loan_offering.INTEREST_CALC_RULE_ID LOAN_OFFERING_INTEREST_CALC_RULE
INTEREST_CALC_RULE_ID loan_offering smallint 6  √  null
interest_calc_rule.INTEREST_CALC_RULE_ID LOAN_OFFERING_INTEREST_CALC_RULE
INTEREST_CURRENCY_ID account_activity smallint 6  √  null
currency.CURRENCY_ID account_activity_ibfk_4
INTEREST_CURRENCY_ID customer_loan_account_detail smallint 6
currency.CURRENCY_ID customer_loan_account_detail_ibfk_4
INTEREST_CURRENCY_ID loan_schedule smallint 6  √  null
currency.CURRENCY_ID loan_schedule_ibfk_4
INTEREST_DUE coll_sheet_loan_details decimal 10,3  √  null
INTEREST_DUE_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_4
INTEREST_GLCODE_ID loan_offering smallint 6
gl_code.GLCODE_ID loan_offering_ibfk_2
INTEREST_GLCODE_ID savings_offering smallint 6
gl_code.GLCODE_ID savings_offering_ibfk_9
INTEREST_OUTSTANDING account_activity decimal 13,10  √  null
INTEREST_OUTSTANDING_CURRENCY_ID account_activity smallint 6  √  null
currency.CURRENCY_ID account_activity_ibfk_5
INTEREST_OVERDUE coll_sheet_loan_details decimal 10,3  √  null
INTEREST_OVERDUE_CURRENCY coll_sheet_loan_details smallint 6  √  null
currency.CURRENCY_ID coll_sheet_loan_details_ibfk_9
INTEREST_PAID customer_historical_data decimal 10,3  √  null
INTEREST_PAID loan_schedule decimal 10,3  √  null
INTEREST_PAID loan_summary decimal 10,3  √  null
INTEREST_PAID_CURRENCY_ID customer_historical_data smallint 6  √  null
INTEREST_PAID_CURRENCY_ID loan_schedule smallint 6  √  null
currency.CURRENCY_ID loan_schedule_ibfk_10
INTEREST_PAID_CURRENCY_ID loan_summary smallint 6  √  null
currency.CURRENCY_ID loan_summary_ibfk_6
INTEREST_RATE loan_account decimal 13,10  √  null
INTEREST_RATE savings_account decimal 13,10
INTEREST_RATE savings_offering decimal 13,10
INTEREST_TYPE_ID interest_types smallint 6  √ 
loan_account.INTEREST_TYPE_ID loan_account_ibfk_7
loan_offering.INTEREST_TYPE_ID loan_offering_ibfk_5
INTEREST_TYPE_ID loan_account smallint 6  √  null
interest_types.INTEREST_TYPE_ID loan_account_ibfk_7
INTEREST_TYPE_ID loan_offering smallint 6
interest_types.INTEREST_TYPE_ID loan_offering_ibfk_5
INTER_INT_CALC_DATE savings_account date 10  √  null
INT_DED_DISBURSEMENT_FLAG loan_offering smallint 6
INT_TO_BE_POSTED savings_account decimal 10,3  √  null
INT_TO_BE_POSTED_CURRENCY_ID savings_account smallint 6  √  null
currency.CURRENCY_ID savings_account_ibfk_4
ISBLACKLISTED customer_state_flag smallint 6  √  null
JNDI report_datasource tinyint 4  √  null
LABEL_ID lookup_label int 11  √ 
LANG_ID language smallint 6
supported_locale.LANG_ID supported_locale_ibfk_2
LANG_ID supported_locale smallint 6  √  null
language.LANG_ID supported_locale_ibfk_2
LANG_NAME language varchar 100  √  null
LANG_SHORT_NAME language varchar 10  √  null
LAST_APPLIED_DATE account_fees date 10  √  null
LAST_GROUP_LOAN_AMNT_DISB group_perf_history decimal 10,3  √  null
LAST_GROUP_LOAN_AMNT_DISB_CURRENCY_ID group_perf_history smallint 6  √  null
LAST_INT_CALC_DATE savings_account date 10  √  null
LAST_INT_POST_DATE savings_account date 10  √  null
LAST_LOAN_AMNT client_perf_history decimal 10,3  √  null
LAST_LOAN_AMNT cust_perf_history decimal 10,3  √  null
LAST_LOAN_AMNT_CURRENCY_ID client_perf_history smallint 6  √  null
LAST_LOGIN personnel date 10  √  null
LAST_NAME customer varchar 200  √  null
LAST_NAME customer_name_detail varchar 100
LAST_NAME personnel_details varchar 100  √  null
LAST_UPDATED_DATE branch_ho_update date 10  √  null
LATENESS_DAYS prd_type smallint 6  √  null
LEVEL logmessages varchar 20  √  null
LEVEL_ID custom_field_definition smallint 6  √  null
customer_level.LEVEL_ID custom_field_definition_ibfk_1
LEVEL_ID customer_checklist smallint 6
customer_level.LEVEL_ID customer_checklist_ibfk_2
LEVEL_ID customer_level smallint 6
custom_field_definition.LEVEL_ID custom_field_definition_ibfk_1
customer.CUSTOMER_LEVEL_ID customer_ibfk_1
customer_checklist.LEVEL_ID customer_checklist_ibfk_2
customer_level.PARENT_LEVEL_ID customer_level_ibfk_1
customer_state.LEVEL_ID customer_state_ibfk_1
personnel_level.LEVEL_ID Implied Constraint
LEVEL_ID customer_state smallint 6
customer_level.LEVEL_ID customer_state_ibfk_1
LEVEL_ID feelevel smallint 6
personnel_level.LEVEL_ID Implied Constraint
LEVEL_ID office_level smallint 6
office.OFFICE_LEVEL_ID office_ibfk_1
office_level.PARENT_LEVEL_ID office_level_ibfk_1
personnel_level.LEVEL_ID Implied Constraint
LEVEL_ID personnel smallint 6
personnel_level.LEVEL_ID personnel_ibfk_3
LEVEL_ID personnel_level smallint 6
customer_level.LEVEL_ID Implied Constraint
feelevel.LEVEL_ID Implied Constraint
office_level.LEVEL_ID Implied Constraint
personnel.LEVEL_ID personnel_ibfk_3
personnel_level.PARENT_LEVEL_ID personnel_level_ibfk_1
LEVEL_NAME_ID customer_level smallint 6
lookup_entity.ENTITY_ID customer_level_ibfk_2
LEVEL_NAME_ID office_level smallint 6  √  null
LEVEL_NAME_ID personnel_level int 11
lookup_value.LOOKUP_ID personnel_level_ibfk_2
LINE_1 customer_address_detail varchar 200  √  null
LINE_2 customer_address_detail varchar 200  √  null
LINE_3 customer_address_detail varchar 200  √  null
LINE_NUMBER logmessages varchar 50  √  null
LOAN_AMOUNT customer_historical_data decimal 10,3  √  null
LOAN_AMOUNT loan_account decimal 10,3  √  null
LOAN_AMOUNT_CURRENCY_ID customer_historical_data smallint 6  √  null
LOAN_AMOUNT_CURRENCY_ID loan_account smallint 6  √  null
currency.CURRENCY_ID loan_account_ibfk_3
LOAN_AMOUNT_FROM_LAST_LOAN_ID loan_amount_from_last_loan smallint 6  √ 
LOAN_AMOUNT_FROM_LOAN_CYCLE_ID loan_amount_from_loan_cycle smallint 6  √ 
LOAN_AMOUNT_SAME_FOR_ALL_LOAN_ID loan_amount_same_for_all_loan smallint 6  √ 
LOAN_BALANCE loan_account decimal 10,3  √  null
LOAN_BALANCE_CURRENCY_ID loan_account smallint 6  √  null
currency.CURRENCY_ID loan_account_ibfk_4
LOAN_COUNTER_FLAG loan_offering smallint 6  √  null
LOAN_COUNTER_ID loan_counter int 11  √ 
LOAN_CYCLE_COUNTER cust_perf_history smallint 6  √  null
LOAN_CYCLE_COUNTER loan_counter smallint 6  √  null
LOAN_CYCLE_NUMBER customer_historical_data int 11  √  null
LOAN_DETAILS_ID coll_sheet_loan_details bigint 20  √ 
LOAN_MATURITY_DATE loan_perf_history date 10  √  null
LOAN_OFFERING_FUND_ID loan_offering_fund smallint 6  √ 
LOAN_OFFERING_ID loan_counter smallint 6
LOAN_OFFICER_ID coll_sheet_customer smallint 6  √  null
LOAN_OFFICER_ID customer smallint 6  √  null
personnel.PERSONNEL_ID customer_ibfk_4
LOAN_PENALTY_ID loan_penalty int 11  √ 
LOCALE_ID checklist smallint 6
supported_locale.LOCALE_ID checklist_ibfk_1
LOCALE_ID checklist_detail smallint 6  √  null
supported_locale.LOCALE_ID checklist_detail_ibfk_2
LOCALE_ID customer_address_detail smallint 6  √  null
supported_locale.LOCALE_ID customer_address_detail_ibfk_2
LOCALE_ID customer_name_detail smallint 6  √  null
supported_locale.LOCALE_ID customer_name_detail_ibfk_3
LOCALE_ID lookup_label smallint 6  √  null
supported_locale.LOCALE_ID lookup_label_ibfk_2
LOCALE_ID lookup_value_locale smallint 6
supported_locale.LOCALE_ID lookup_value_locale_ibfk_2
LOCALE_ID supported_locale smallint 6