SchemaSpy Analysis of db191 Generated by
SchemaSpy
Generated by SchemaSpy on Fri Apr 18 07:59 PDT 2008
Database Type: MySQL - 5.0.45-community-nt SourceForge.net

Please support this project

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

213 Tables:

Table Children Parents Rows
accepted_payment_type 2 5
account 22 5 0
account_action 3 1 19
account_activity 9 0
account_custom_field 2 0
account_fees 3 4 0
account_flag_detail 3 0
account_notes 2 0
account_payment 1 3 0
account_state 6 1 18
account_state_flag 1 2 7
account_status_change_history 4 0
account_trxn 6 6 0
account_type 1 1 4
activity 2 3 180
admin_document 1 0
admin_document_acc_state_mix 2 0
attendance 1 0
batch_branch_cash_confirmation_report 3 0
batch_branch_confirmation_disbursement 1 0
batch_branch_confirmation_issue 1 0
batch_branch_confirmation_recovery 1 0
batch_branch_report 6 0
batch_client_summary 1 0
batch_loan_arrears_aging 1 0
batch_loan_arrears_profile 1 0
batch_loan_details 1 0
batch_staff_summary 1 0
batch_staffing_level_summary 1 0
branch_ho_update 1 0
category_type 3 1 5
change_log 1 1 0
change_log_detail 1 0
checklist 3 3 0
checklist_detail 2 0
client_initial_savings_offering 2 0
client_perf_history 1 0
coa 3 1 0
coa_idmapper 1 0
coahierarchy 2 0
coll_sheet 0
coll_sheet_customer 9 0
coll_sheet_loan_details 15 0
coll_sheet_savings_details 4 0
config_key_value_integer 11
country 1 9
currency 122 4
cust_perf_history 1 0
custom_field_definition 3 3 0
customer 28 5 0
customer_account 1 0
customer_account_activity 3 0
customer_address_detail 2 0
customer_attendance 1 0
customer_attendance_types 1 4
customer_checklist 3 0
customer_custom_field 2 0
customer_detail 7 0
customer_fee_schedule 5 0
customer_flag_detail 3 0
customer_hierarchy 3 0
customer_historical_data 1 0
customer_level 5 2 3
customer_loan_account_detail 6 0
customer_meeting 3 3 0
customer_meeting_detail 2 0
customer_movement 4 0
customer_name_detail 3 0
customer_note 2 0
customer_picture 1 0
customer_position 1 0
customer_program 2 0
customer_schedule 1 3 0
customer_state 3 2 14
customer_state_flag 1 2 20
customer_trxn_detail 4 0
database_version 1
entity_master 2 22
fee_formula_master 1 1 3
fee_frequency 4 0
fee_frequency_type 1 1 2
fee_payment 2 1 3
fee_payments_categories_type 3 3
fee_status 1 1 2
fee_trxn_detail 3 0
fee_type 1 1 5
fee_update_type 1 2
feelevel 1 0
fees 7 9 0
field_configuration 1 2 74
financial_action 1 1 22
financial_trxn 1 8 0
freq_of_deposits 1 0
fund 4 1 5
fund_code 1 5
gl_code 11 0
grace_period_type 2 1 3
group_perf_history 1 0
holiday 2 0
inherited_meeting 2 0
insurance_offering 1 0
interest_calc_rule 1 1 2
interest_calculation_types 2 1 2
interest_types 2 2 3
language 1 1 4
loan_account 7 15 0
loan_activity_details 10 0
loan_amount_from_last_loan 1 0
loan_amount_from_loan_cycle 1 0
loan_amount_same_for_all_loan 1 0
loan_arrears_aging 10 0
loan_counter 0
loan_fee_schedule 5 0
loan_offering 7 11 0
loan_offering_fund 2 0
loan_penalty 2 0
loan_perf_history 1 0
loan_schedule 1 13 0
loan_summary 9 0
loan_trxn_detail 6 0
logmessages 0
lookup_entity 5 77
lookup_label 2 71
lookup_value 53 1 391
lookup_value_locale 1 2 381
max_min_loan_amount 1 0
max_min_no_of_install 1 0
meeting 7 1 0
meeting_type 2 5
mfi_attribute 1 5
mis_bank 3
mis_bankbranch 6
mis_geographicalarea 9
mis_geographicalareatype 2
mis_shgmemberprofile 4
mis_shgprofile 6
no_of_install_from_last_loan 1 0
no_of_install_from_loan_cycle 1 0
no_of_install_same_for_all_loan 1 0
offering_fund 2 0
office 19 4 1
office_action_payment_type 4 5
office_address 1 0
office_code 1 1 2
office_custom_field 1 0
office_hierarchy 3 0
office_level 2 1 5
office_status 1 1 2
payment_type 3 1 3
penalty 2 4 0
personnel 37 6 1
personnel_custom_field 2 0
personnel_details 3 1
personnel_hierarchy 3 0
personnel_level 2 2 2
personnel_movement 3 0
personnel_notes 2 0
personnel_role 2 1
personnel_status 1 2
position 1 4
ppi_likelihoods 1 0
ppi_survey 1 0
ppi_survey_instance 0
prd_applicable_master 1 1 3
prd_category 1 1 2
prd_category_status 1 2
prd_checklist 3 0
prd_fee_frequency 3 0
prd_offering 12 6 0
prd_offering_fees 1 2 0
prd_offering_meeting 3 0
prd_offering_mix 2 0
prd_state 1 1 2
prd_status 1 2 4
prd_type 6 1 2
product_offering_mandatory_savings 1 0
program 2 3 0
program_fund 2 0
question_choices 1 1 0
questions 2 0
rank_days_master 2 1 5
recommended_amnt_unit 2 1 2
recur_on_day 3 0
recurrence_detail 3 2 0
recurrence_type 2 3
repayment_rule 1 1 3
report 1 3
report_category 2 7
report_datasource 0
report_jasper_map 1 3
report_parameter 0
report_parameter_map 0
role 2 2 1
roles_activity 2 159
saving_schedule 5 0
savings_account 10 0
savings_activity_details 5 0
savings_offering 9 0
savings_performance 4 0
savings_trxn_detail 5 0
savings_type 2 1 2
scheduled_tasks 0
spouse_father_lookup 1 2
supported_locale 7 2 4
survey 4 0
survey_instance 1 5 0
survey_questions 1 2 0
survey_response 3 0
temp_id 0
transaction_type 1 5
waive_off_history 1 0
week_days_master 2 1 7
yes_no_master 1 2

Total rows: 1,678