SchemaSpy Analysis of db165 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Dec 14 17:59 PST 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
db165 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