Tables


SchemaSpy Analysis of fineract_default.public

Generated on Sun Oct 25 00:05 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 280
VIEWS 0
COLUMNS 2972
Constraints 568
Anomalies 17
Routines 10

Database Properties

Database Type: PostgreSQL - 18.4 (Debian 18.4-1.pgdg13+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
m_provisioning_criteria_definition 0 4 8 -1 Table
m_report_mailing_job_run_history 0 1 7 -1 Table
acc_accounting_rule 1 3 9 -1 Table
m_wc_loan_account_locks 0 0 7 -1 Table
m_wc_loan_delinquency_range_schedule 1 3 18 -1 Table
batch_custom_job_parameters 0 0 2 -1 Table
m_product_mix 0 2 3 -1 Table
acc_gl_journal_entry 3 12 31 -1 Table
m_wc_loan_product 4 4 37 -1 Table
m_loan_charge_paid_by 0 2 5 -1 Table
m_loan_recalculation_details 0 1 18 -1 Table
m_share_product_market_price 0 1 4 -1 Table
acc_rule_tags 0 2 4 -1 Table
batch_job_execution_context 0 1 3 412 Table
m_office 21 1 6 -1 Table
m_group_level 2 1 6 -1 Table
m_external_asset_owner_transfer_details 0 2 12 -1 Table
m_delinquency_range 4 0 9 -1 Table
m_code 2 0 3 -1 Table
m_mandatory_savings_schedule 0 3 17 -1 Table
m_entity_datatable_check 0 1 6 -1 Table
m_loan_repayment_schedule 5 3 42 -1 Table
m_account_transfer_standing_instructions 1 1 15 -1 Table
m_calendar_history 0 1 14 -1 Table
m_creditbureau 3 0 5 -1 Table
m_wc_delinquency_configuration 0 1 10 -1 Table
m_wc_loan_originator_mapping 0 4 7 -1 Table
m_client_identifier 0 4 15 -1 Table
m_loan_originator_mapping 0 4 7 -1 Table
m_product_loan_guarantee_details 0 1 5 -1 Table
m_survey_responses 1 1 5 -1 Table
m_payment_type 3 0 7 -1 Table
notification_mapper 0 2 5 -1 Table
m_meeting 1 1 3 -1 Table
m_savings_account_transaction 5 5 28 -1 Table
x_registered_table 1 0 4 -1 Table
m_deposit_product_term_and_preclosure 0 1 14 -1 Table
c_cache 0 0 2 -1 Table
scheduled_email_campaign 1 1 25 -1 Table
batch_job_execution_params 0 2 5 398 Table
m_survey_lookup_tables 0 1 7 -1 Table
m_product_loan_variations_borrower_cycle 0 1 8 -1 Table
m_savings_account_charge 1 4 27 -1 Table
m_product_loan_variable_installment_config 0 1 4 -1 Table
job_run_history 0 0 9 398 Table
m_wc_loan_breach_schedule 0 3 17 -1 Table
m_creditbureau_configuration 0 1 5 -1 Table
m_deposit_product_interest_rate_chart 0 2 2 -1 Table
m_cashiers 1 2 9 -1 Table
m_staff 10 2 14 -1 Table
m_permission 1 0 6 984 Table
m_wc_loan_disbursement_detail 0 2 8 -1 Table
m_note 0 9 16 -1 Table
m_password_validation_policy 0 0 5 -1 Table
stretchy_report 4 0 10 87 Table
m_loan_collateral_management 0 3 6 -1 Table
m_wc_loan_balance 0 1 26 -1 Table
m_address 0 2 17 -1 Table
m_floating_rates_periods 0 3 12 -1 Table
m_loan_buy_down_fee_balance 0 4 15 -1 Table
m_loanproduct_provisioning_entry 0 7 11 -1 Table
m_wc_loan_note 0 3 7 -1 Table
m_share_product 4 2 28 -1 Table
m_deposit_product_recurring_detail 0 1 5 -1 Table
m_charge 9 3 25 -1 Table
m_loan_interest_recalculation_additional_details 0 1 4 -1 Table
sms_messages_outbound 0 4 12 -1 Table
m_provision_category 2 0 3 -1 Table
m_loan_status_change_history 0 3 8 -1 Table
m_interest_rate_chart 2 0 6 -1 Table
m_loan_delinquency_tag_history 0 2 10 -1 Table
acc_gl_account 16 2 11 -1 Table
ppi_likelihoods_ppi 0 0 4 -1 Table
c_external_service_properties 0 1 3 -1 Table
m_external_asset_owner_loan_product_configurable_attributes 0 3 8 -1 Table
m_survey_scorecards 0 5 8 -1 Table
m_group 11 5 17 -1 Table
acc_gl_journal_entry_annual_summary 0 2 15 -1 Table
m_cashier_transactions 0 1 10 -1 Table
m_wc_loan_amortization_model 0 1 7 -1 Table
m_wc_breach_configuration 2 0 6 -1 Table
m_savings_account_interest_rate_slab 1 1 10 -1 Table
m_client_transfer_details 0 4 8 -1 Table
m_loan_rate 0 2 2 -1 Table
m_loan_transaction_repayment_schedule_mapping 0 2 8 -1 Table
m_portfolio_account_associations 1 4 7 -1 Table
m_loan_payment_allocation_rule 0 3 9 -1 Table
m_holiday_office 0 2 2 -1 Table
ppi_scores 0 0 3 -1 Table
m_loan_reage_parameter 0 2 12 -1 Table
m_deposit_account_term_and_preclosure 0 2 20 -1 Table
m_loan_capitalized_income_balance 0 4 15 -1 Table
m_savings_officer_assignment_history 0 4 11 -1 Table
c_external_service 1 0 2 -1 Table
m_account_transfer_details 3 8 10 -1 Table
m_loan_transaction 14 5 28 -1 Table
m_loan_installment_delinquency_tag 0 2 13 -1 Table
m_loan_progressive_model 0 1 7 -1 Table
notification_generator 1 0 8 -1 Table
m_savings_account 17 7 72 -1 Table
m_loan_collateral 0 2 5 -1 Table
m_product_loan_recalculation_details 0 1 19 -1 Table
job_parameters 0 1 4 5 Table
m_entity_to_entity_mapping 0 1 6 -1 Table
m_share_account_dividend_details 0 2 6 -1 Table
scheduled_email_messages_outbound 0 4 12 -1 Table
stretchy_report_parameter 0 2 4 259 Table
m_tax_group 4 2 6 -1 Table
m_tellers 1 3 9 -1 Table
r_enum_value 0 0 5 198 Table
m_wc_loan_breach_action 0 3 14 -1 Table
m_appuser_role 0 2 2 -1 Table
twofactor_access_token 0 1 6 -1 Table
m_collateral_management 1 1 7 -1 Table
m_wc_loan_transaction_relation 0 3 9 -1 Table
m_entity_relation 1 0 4 -1 Table
m_working_days 0 0 5 -1 Table
m_wc_loan_near_breach_action 0 3 11 -1 Table
gsim_accounts 1 1 8 -1 Table
m_interest_incentives 0 1 8 -1 Table
m_external_asset_owner 4 2 6 -1 Table
m_loan_reschedule_request 2 5 14 -1 Table
c_account_number_format 0 0 4 -1 Table
m_guarantor 1 2 18 -1 Table
m_account_transfer_standing_instructions_history 0 1 6 -1 Table
batch_step_execution_context 0 1 3 428 Table
m_loan_topup 0 3 5 -1 Table
m_loan_product_payment_allocation_rule 0 3 9 -1 Table
m_share_account 3 9 30 -1 Table
m_journal_entry_aggregation_summary 0 6 17 -1 Table
x_table_column_code_mappings 0 1 2 -1 Table
m_loan_overdue_installment_charge 0 2 4 -1 Table
acc_gl_closure 0 3 9 -1 Table
rpt_sequence 0 0 1 -1 Table
m_loan_tranche_disbursement_charge 0 2 3 -1 Table
m_office_transaction 0 2 8 -1 Table
m_report_mailing_job 1 4 24 -1 Table
m_deposit_account_on_hold_transaction 1 3 11 -1 Table
m_hook_schema 0 1 6 -1 Table
m_savings_interest_incentives 0 1 8 -1 Table
m_wc_loan_transaction_allocation 0 3 11 -1 Table
m_hook_configuration 0 1 5 -1 Table
m_family_members 0 5 14 -1 Table
m_business_date 0 3 10 -1 Table
m_loan_delinquency_action 0 1 9 -1 Table
scheduled_email_configuration 0 0 3 -1 Table
m_hook 2 2 9 -1 Table
m_wc_near_breach 2 0 5 -1 Table
m_loan_arrears_aging 0 1 7 -1 Table
m_tax_component_history 0 3 9 -1 Table
m_deposit_account_recurring_detail 0 1 9 -1 Table
scheduler_detail 0 0 4 -1 Table
m_loan_amortization_allocation_mapping 0 5 11 -1 Table
interop_identifier 0 1 9 -1 Table
m_report_mailing_job_configuration 0 0 3 -1 Table
m_share_product_charge 0 2 2 -1 Table
m_loan_disbursement_detail 1 1 7 -1 Table
m_group_roles 0 3 4 -1 Table
ppi_likelihoods 0 0 3 -1 Table
m_external_asset_owner_transfer_journal_entry_mapping 0 4 7 -1 Table
m_loan_installment_charge 0 2 12 -1 Table
m_wc_loan_delinquency_action 0 3 14 -1 Table
m_wc_loan_charge_paid_by 0 2 4 -1 Table
m_client 21 15 48 -1 Table
m_hook_registered_events 0 1 4 -1 Table
m_guarantor_transaction 0 3 5 -1 Table
m_product_loan_rate 0 2 2 -1 Table
m_savings_account_charge_paid_by 0 2 4 -1 Table
m_client_non_person 0 1 7 -1 Table
m_provisioning_history 1 2 6 -1 Table
m_wc_loan_payment_allocation_rule 0 3 8 -1 Table
m_external_event 0 1 11 -1 Table
m_guarantor_funding_details 1 2 8 -1 Table
m_repayment_with_post_dated_checks 0 2 9 -1 Table
acc_gl_financial_activity_account 0 1 3 -1 Table
m_holiday 1 0 9 -1 Table
acc_product_mapping 0 6 11 -1 Table
m_hook_templates 2 0 2 -1 Table
m_savings_product 6 1 35 -1 Table
m_wc_loan_range_delinquency_tag 0 3 12 -1 Table
m_loan_charge 6 4 28 -1 Table
m_image 2 0 3 -1 Table
m_wc_loan_period_payment_rate_change 0 3 16 -1 Table
m_wc_loan_product_payment_allocation_rule 0 3 8 -1 Table
m_rate 2 2 10 -1 Table
stretchy_parameter 2 1 12 -1 Table
m_tax_component 4 4 12 -1 Table
batch_step_execution 1 1 19 424 Table
m_account_transfer_transaction 0 6 14 -1 Table
m_share_account_transactions 2 1 11 -1 Table
m_wc_loan_transaction 4 5 17 -1 Table
m_loan 38 18 151 -1 Table
m_wc_loan_charge 2 2 20 -1 Table
m_savings_account_interest_rate_chart 1 1 7 -1 Table
oauth_client_details 0 0 11 -1 Table
m_journal_entry_aggregation_tracking 0 3 9 -1 Table
m_share_account_charge 1 2 19 -1 Table
oauth_refresh_token 0 0 3 -1 Table
m_share_account_charge_paid_by 0 2 4 -1 Table
m_template 1 0 5 -1 Table
m_calendar 2 2 20 -1 Table
m_survey_components 0 1 6 -1 Table
m_template_m_templatemappers 0 0 2 -1 Table
c_configuration 0 0 8 79 Table
m_provisioning_criteria 3 2 6 -1 Table
databasechangelog 0 0 14 2065 Table
m_external_event_configuration 10 0 2 189 Table
m_trial_balance 0 0 6 -1 Table
m_import_document 0 2 10 -1 Table
m_wc_loan 14 15 59 -1 Table
m_loanproduct_provisioning_mapping 0 2 3 -1 Table
m_loan_originator 2 4 10 -1 Table
m_savings_product_charge 0 2 2 -1 Table
m_loan_account_locks 0 1 7 -1 Table
m_loan_reamortization_parameter 0 1 8 -1 Table
glim_accounts 1 1 8 -1 Table
m_client_charge_paid_by 0 2 4 -1 Table
m_survey_questions 2 1 7 -1 Table
job 1 0 19 41 Table
m_payment_detail 5 1 7 -1 Table
m_floating_rates 2 2 10 -1 Table
m_calendar_instance 1 1 4 -1 Table
m_external_asset_owner_journal_entry_mapping 0 4 7 -1 Table
m_product_loan_floating_rates 0 2 8 -1 Table
m_appuser_previous_password 0 1 4 -1 Table
m_currency 1 0 7 164 Table
batch_job_execution 5 1 10 428 Table
m_command 0 0 18 -1 Table
sms_campaign 1 1 21 -1 Table
m_creditreport 0 1 4 -1 Table
m_loan_repayment_schedule_history 0 2 17 -1 Table
m_document 1 0 12 -1 Table
m_batch_business_steps 0 0 4 -1 Table
m_savings_account_transaction_tax_details 0 2 4 -1 Table
m_adhoc 0 2 14 -1 Table
m_fund 4 0 3 -1 Table
m_delinquency_bucket_mappings 0 2 8 -1 Table
m_external_asset_owner_transfer_loan_mapping 0 4 7 -1 Table
oauth_access_token 0 0 7 -1 Table
m_share_product_dividend_pay_out 1 3 10 -1 Table
m_product_loan 17 5 90 -1 Table
m_creditbureau_loanproduct_mapping 0 2 7 -1 Table
m_client_address 0 2 5 -1 Table
m_loan_officer_assignment_history 0 2 9 -1 Table
m_loan_term_variations 1 3 14 -1 Table
m_wc_loan_product_configurable_attributes 0 1 7 -1 Table
m_surveys 4 0 7 -1 Table
m_code_value 34 1 8 -1 Table
m_loan_charge_tax_details 0 2 4 -1 Table
m_loan_transaction_relation 0 3 9 -1 Table
m_client_collateral_management 1 2 4 -1 Table
ref_loan_transaction_processing_strategy 0 0 4 -1 Table
m_client_transaction 2 3 16 -1 Table
m_interest_rate_slab 1 1 10 -1 Table
m_staff_assignment_history 0 2 9 -1 Table
m_templatemappers 0 0 4 -1 Table
m_client_charge 1 2 16 -1 Table
m_loan_credit_allocation_rule 0 3 8 -1 Table
m_organisation_creditbureau 1 1 4 -1 Table
m_field_configuration 0 0 7 -1 Table
m_role_permission 0 2 2 -1 Table
m_tax_group_mappings 0 4 9 -1 Table
m_loan_approved_amount_history 0 3 8 -1 Table
m_product_loan_charge 0 2 2 -1 Table
m_external_asset_owner_transfer 2 5 17 -1 Table
m_group_client 0 2 2 -1 Table
m_loan_tranche_charges 0 2 3 -1 Table
m_portfolio_command_source 0 2 32 -1 Table
m_product_loan_configurable_attributes 0 1 10 -1 Table
m_role 2 0 4 -1 Table
m_delinquency_bucket 5 0 8 -1 Table
m_loan_product_credit_allocation_rule 0 3 8 -1 Table
m_loan_reschedule_request_term_variations_mapping 0 2 3 -1 Table
m_appuser 167 2 23 -1 Table
m_creditbureau_token 0 0 7 -1 Table
twofactor_configuration 0 0 3 -1 Table
batch_job_instance 1 0 4 398 Table
databasechangeloglock 0 0 4 -1 Table
m_organisation_currency 0 0 7 -1 Table
m_client_attendance 0 2 4 -1 Table