Tables


SchemaSpy Analysis of fineract_default

Generated on Sun May 08 21:27 CEST 2022

XML Representation
Insertion Order Deletion Order
TABLES 222
VIEWS 0
COLUMNS 2094
Constraints 368
Anomalies 7
Routines 0

Database Properties

Database Type: MariaDB - 10.6.7-MariaDB-1:10.6.7+maria~focal

Tables

Table / View Children Parents Columns Rows Type Comments
m_provisioning_criteria_definition 0 4 8 0 Table
m_report_mailing_job_run_history 0 1 7 0 Table
acc_accounting_rule 1 3 9 0 Table
m_entity_to_entity_access 0 1 6 0 Table
m_product_mix 0 2 3 0 Table
acc_gl_journal_entry 1 10 28 0 Table
m_loan_charge_paid_by 0 2 5 0 Table
m_loan_recalculation_details 0 1 16 0 Table
m_share_product_market_price 0 1 4 0 Table
acc_rule_tags 0 2 4 0 Table
m_office 20 1 6 0 Table
m_group_level 2 1 6 0 Table
request_audit_table 0 1 11 0 Table
m_code 2 0 3 0 Table
m_mandatory_savings_schedule 0 1 15 0 Table
m_entity_datatable_check 0 1 6 0 Table
m_loan_repayment_schedule 5 1 33 0 Table
m_calendar_history 0 1 14 0 Table
m_account_transfer_standing_instructions 1 1 15 0 Table
m_creditbureau 3 0 5 1 Table
m_client_identifier 0 2 11 0 Table
m_product_loan_guarantee_details 0 1 5 0 Table
client_device_registration 0 1 4 0 Table
m_survey_responses 1 1 5 0 Table
m_payment_type 3 0 5 0 Table
notification_mapper 0 2 5 0 Table
m_savings_account_transaction 5 3 23 0 Table
m_meeting 1 1 3 0 Table
x_registered_table 1 0 4 0 Table
m_deposit_product_term_and_preclosure 0 1 14 0 Table
topic_subscriber 0 2 4 0 Table
c_cache 0 0 2 0 Table
scheduled_email_campaign 1 1 25 0 Table
m_survey_lookup_tables 0 1 7 0 Table
m_savings_account_charge 1 2 23 0 Table
m_product_loan_variations_borrower_cycle 0 1 8 0 Table
m_product_loan_variable_installment_config 0 1 4 0 Table
job_run_history 0 1 9 29 Table
m_creditbureau_configuration 0 1 5 0 Table
m_deposit_product_interest_rate_chart 0 2 2 0 Table
m_cashiers 1 2 9 0 Table
m_staff 10 2 14 0 Table
m_permission 1 0 6 865 Table
m_note 0 7 14 0 Table
m_password_validation_policy 0 0 5 0 Table
stretchy_report 4 0 10 0 Table
m_loan_collateral_management 0 3 6 0 Table
m_floating_rates_periods 0 1 10 0 Table
m_address 0 2 17 0 Table
m_loanproduct_provisioning_entry 0 7 11 0 Table
mix_xbrl_namespace 0 0 3 0 Table
m_share_product 4 2 28 0 Table
m_deposit_product_recurring_detail 0 1 5 0 Table
m_charge 9 3 25 0 Table
m_loan_interest_recalculation_additional_details 0 1 4 0 Table
sms_messages_outbound 0 4 12 0 Table
m_loan_paid_in_advance 0 1 6 0 Table
m_provision_category 2 0 3 0 Table
m_interest_rate_chart 2 0 6 0 Table
acc_gl_account 14 2 11 0 Table
ppi_likelihoods_ppi 0 0 4 0 Table
m_survey_scorecards 0 5 8 0 Table
c_external_service_properties 0 1 3 0 Table
m_group 11 5 17 0 Table
m_cashier_transactions 0 1 10 0 Table
m_savings_account_interest_rate_slab 1 1 10 0 Table
m_loan_rate 0 2 2 0 Table
m_client_transfer_details 0 4 8 0 Table
m_loan_transaction_repayment_schedule_mapping 0 2 8 0 Table
m_portfolio_account_associations 1 4 7 0 Table
m_holiday_office 0 2 2 0 Table
ppi_scores 0 0 3 0 Table
m_deposit_account_term_and_preclosure 0 2 20 0 Table
m_savings_officer_assignment_history 0 2 9 0 Table
c_external_service 1 0 2 4 Table
m_loan_transaction 8 3 20 0 Table
m_account_transfer_details 3 8 10 0 Table
notification_generator 1 0 8 0 Table
m_savings_account 17 5 66 0 Table
m_loan_collateral 0 2 5 0 Table
m_product_loan_recalculation_details 0 1 18 0 Table
job_parameters 0 1 4 0 Table
m_entity_to_entity_mapping 0 1 6 0 Table
m_share_account_dividend_details 0 2 6 0 Table
mix_taxonomy 0 0 7 0 Table
m_selfservice_beneficiaries_tpt 0 0 9 0 Table
scheduled_email_messages_outbound 0 4 12 0 Table
stretchy_report_parameter 0 2 4 0 Table
m_tax_group 4 2 6 0 Table
m_tellers 1 3 9 0 Table
r_enum_value 0 0 5 0 Table
m_appuser_role 0 2 2 0 Table
twofactor_access_token 0 1 6 9 Table
m_collateral_management 1 1 7 0 Table
m_entity_relation 1 0 4 0 Table
m_working_days 0 0 5 0 Table
gsim_accounts 1 1 8 0 Table
m_interest_incentives 0 1 8 0 Table
m_loan_reschedule_request 2 5 14 0 Table
c_account_number_format 0 0 4 0 Table
m_guarantor 1 2 18 0 Table
m_account_transfer_standing_instructions_history 0 1 6 0 Table
m_loan_topup 0 3 5 0 Table
m_share_account 3 9 30 0 Table
mix_taxonomy_mapping 0 0 5 0 Table
x_table_column_code_mappings 0 1 2 0 Table
m_pocket 1 1 2 0 Table
m_loan_overdue_installment_charge 0 2 4 0 Table
acc_gl_closure 0 3 9 0 Table
rpt_sequence 0 0 1 0 Table
m_loan_tranche_disbursement_charge 0 2 3 0 Table
m_report_mailing_job 1 4 24 0 Table
m_office_transaction 0 2 8 0 Table
m_deposit_account_on_hold_transaction 1 1 7 0 Table
m_hook_schema 0 1 6 0 Table
m_savings_interest_incentives 0 1 8 0 Table
m_hook_configuration 0 1 5 0 Table
m_family_members 0 5 14 0 Table
scheduled_email_configuration 0 0 3 0 Table
m_hook 2 2 9 0 Table
m_tax_component_history 0 3 9 0 Table
m_loan_arrears_aging 0 1 7 0 Table
m_deposit_account_recurring_detail 0 1 9 0 Table
scheduler_detail 0 0 4 0 Table
interop_identifier 0 1 9 0 Table
m_report_mailing_job_configuration 0 0 3 0 Table
m_share_product_charge 0 2 2 0 Table
m_loan_disbursement_detail 1 1 6 0 Table
ppi_likelihoods 0 0 3 0 Table
m_group_roles 0 3 4 0 Table
m_loan_installment_charge 0 2 12 0 Table
m_client 23 13 45 0 Table
m_hook_registered_events 0 1 4 0 Table
m_product_loan_rate 0 2 2 0 Table
m_guarantor_transaction 0 3 5 0 Table
m_savings_account_charge_paid_by 0 2 4 0 Table
m_provisioning_history 1 2 6 0 Table
m_client_non_person 0 1 7 0 Table
m_guarantor_funding_details 1 2 8 0 Table
m_repayment_with_post_dated_checks 0 2 9 0 Table
acc_gl_financial_activity_account 0 1 3 0 Table
m_holiday 1 0 9 0 Table
acc_product_mapping 0 2 7 0 Table
m_hook_templates 2 0 2 0 Table
m_savings_product 6 1 35 0 Table
m_loan_charge 4 2 22 0 Table
m_image 2 0 3 0 Table
m_rate 2 2 10 0 Table
stretchy_parameter 2 1 12 0 Table
m_tax_component 3 4 12 0 Table
m_share_account_transactions 2 1 11 0 Table
m_account_transfer_transaction 0 5 13 0 Table
m_loan 24 15 108 0 Table
m_savings_account_interest_rate_chart 1 1 7 0 Table
oauth_client_details 0 0 11 0 Table
m_share_account_charge 1 2 19 0 Table
oauth_refresh_token 0 0 3 0 Table
m_share_account_charge_paid_by 0 2 4 0 Table
m_template 1 0 5 0 Table
m_calendar 2 0 18 0 Table
m_survey_components 0 1 6 0 Table
m_template_m_templatemappers 0 0 2 0 Table
c_configuration 0 0 8 38 Table
m_provisioning_criteria 3 2 6 0 Table
DATABASECHANGELOG 0 0 14 1034 Table
m_trial_balance 0 0 6 0 Table
m_import_document 0 2 10 0 Table
m_loanproduct_provisioning_mapping 0 2 3 0 Table
m_savings_product_charge 0 2 2 0 Table
glim_accounts 1 1 8 0 Table
m_client_charge_paid_by 0 2 4 0 Table
m_survey_questions 2 1 7 0 Table
job 2 0 18 0 Table
m_payment_detail 3 1 7 0 Table
m_floating_rates 2 0 8 0 Table
m_calendar_instance 1 1 4 0 Table
m_product_loan_floating_rates 0 2 8 0 Table
m_appuser_previous_password 0 1 4 0 Table
m_currency 1 0 7 0 Table
sms_campaign 1 1 21 0 Table
m_creditreport 0 1 4 0 Table
m_loan_repayment_schedule_history 0 2 15 0 Table
m_document 1 0 10 0 Table
m_savings_account_transaction_tax_details 0 2 4 0 Table
m_adhoc 0 2 14 0 Table
m_fund 2 0 3 0 Table
oauth_access_token 0 0 7 0 Table
m_share_product_dividend_pay_out 1 3 10 0 Table
m_pocket_accounts_mapping 0 1 5 0 Table
m_product_loan 14 2 61 0 Table
m_creditbureau_loanproduct_mapping 0 2 7 0 Table
m_loan_term_variations 1 1 10 0 Table
m_loan_officer_assignment_history 0 2 9 0 Table
m_client_address 0 2 5 0 Table
m_surveys 4 0 7 0 Table
m_code_value 25 1 8 0 Table
m_client_collateral_management 1 2 4 0 Table
topic 1 0 6 0 Table
ref_loan_transaction_processing_strategy 2 0 4 0 Table
m_client_transaction 2 2 12 0 Table
m_interest_rate_slab 1 1 10 0 Table
m_staff_assignment_history 0 2 9 0 Table
m_templatemappers 0 0 4 0 Table
m_selfservice_user_client_mapping 0 2 3 0 Table
m_client_charge 1 2 16 0 Table
m_organisation_creditbureau 1 1 4 0 Table
m_field_configuration 0 0 7 0 Table
m_role_permission 0 2 2 0 Table
m_tax_group_mappings 0 4 9 0 Table
m_product_loan_charge 0 2 2 0 Table
m_loan_tranche_charges 0 2 3 0 Table
m_group_client 0 2 2 0 Table
m_product_loan_configurable_attributes 0 1 10 0 Table
m_role 2 0 4 0 Table
m_portfolio_command_source 0 2 21 15 Table
m_loan_reschedule_request_term_variations_mapping 0 2 3 0 Table
m_appuser 57 2 18 0 Table
twofactor_configuration 0 0 3 0 Table
m_creditbureau_token 0 0 7 0 Table
DATABASECHANGELOGLOCK 0 0 4 0 Table
m_organisation_currency 0 0 7 0 Table
m_client_attendance 0 2 4 0 Table