m_loan

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_account_transfer_details.from_loan_account_id FK_m_account_transfer_details_from_loan_account R
m_account_transfer_details.to_loan_account_id FK_m_account_transfer_details_to_loan_account R
m_external_asset_owner_transfer.loan_id FK_external_asset_owner_transfer_loan_id R
m_external_asset_owner_transfer_loan_mapping.loan_id FK_external_asset_owner_transfer_loan_mapping_loan_id R
m_guarantor.loan_id FK_m_guarantor_m_loan R
m_loan_account_locks.loan_id fk_loan_id R
m_loan_amortization_allocation_mapping.loan_id FK_laam_loan_id R
m_loan_approved_amount_history.loan_id FK_loan_approved_amount_history_loan_id R
m_loan_arrears_aging.loan_id m_loan_arrears_aging_ibfk_1 R
m_loan_buy_down_fee_balance.loan_id FK_loan_buy_down_fees_balance_loan_id R
m_loan_capitalized_income_balance.loan_id FK_loan_capitalized_income_balance_loan_id R
m_loan_charge.loan_id m_loan_charge_ibfk_2 R
m_loan_collateral.loan_id FK_collateral_m_loan R
m_loan_collateral_management.loan_id fkLoan C
m_loan_credit_allocation_rule.loan_id m_loan_credit_allocation_rule_fk R
m_loan_delinquency_action.loan_id FK_m_loan_delinquency_action_loan R
m_loan_delinquency_tag_history.loan_id FK_m_delinquency_tags_loan R
m_loan_disbursement_detail.loan_id FK_loan_disbursement_detail_loan_id R
m_loan_installment_delinquency_tag.loan_id FK_m_delinquency_installment_tags_loan R
m_loan_officer_assignment_history.loan_id fk_m_loan_officer_assignment_history_0001 R
m_loan_originator_mapping.loan_id FK_loan_originator_mapping_loan R
m_loan_payment_allocation_rule.loan_id m_loan_payment_allocation_rule_fk R
m_loan_progressive_model.loan_id fk_m_loan_progressive_model_on_loan R
m_loan_rate.loan_id fk_m_loan_rate_loan R
m_loan_recalculation_details.loan_id FK_m_loan_m_loan_recalculation_details R
m_loan_repayment_schedule.loan_id fk488b92aa40be0710 R
m_loan_repayment_schedule_history.loan_id m_loan_repayment_schedule_history_ibfk_1 R
m_loan_reschedule_request.loan_id m_loan_reschedule_request_ibfk_1 R
m_loan_status_change_history.loan_id m_loan_status_change_history_fk R
m_loan_term_variations.loan_id FK_loan_id_m_loan_id R
m_loan_topup.closure_loan_id m_loan_topup_FK_closure_loan_id R
m_loan_topup.loan_id m_loan_topup_FK_loan_id R
m_loan_tranche_charges.loan_id FK_m_loan_tranche_charges_m_loan R
m_loan_transaction.loan_id fkcfcea42640be0710 R
m_note.loan_id fk7c9708940be0710 R
m_portfolio_account_associations.linked_loan_account_id linked_loan_fk R
m_portfolio_account_associations.loan_account_id account_association_loan_fk R
m_repayment_with_post_dated_checks.loan_id fkloanrepayment C
account_no varchar 20 null
external_id varchar 100 √ null
client_id int8 19 √ null
m_client.id fkb6f935d87179a0cb R
group_id int8 19 √ null
m_group.id m_loan_ibfk_1 R
glim_id int8 19 √ null
glim_accounts.id FK_glim_id R
product_id int8 19 √ null
m_product_loan.id fkb6f935d8c8d4b434 R
fund_id int8 19 √ null
m_fund.id fk7c885877240145 R
loan_officer_id int8 19 √ null
m_staff.id FK_m_loan_m_staff R
loanpurpose_cv_id int4 10 √ null
m_code_value.id FK_m_loanpurpose_codevalue R
loan_status_id int2 5 null
loan_type_enum int2 5 null
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
principal_amount_proposed numeric 19,6 null
principal_amount numeric 19,6 null
approved_principal numeric 19,6 null
net_disbursal_amount numeric 19,6 null
arrearstolerance_amount numeric 19,6 √ NULL::numeric
is_floating_interest_rate bool 1 √ false
interest_rate_differential numeric 19,6 √ 0
nominal_interest_rate_per_period numeric 19,6 √ NULL::numeric
interest_period_frequency_enum int2 5 √ null
annual_nominal_interest_rate numeric 19,6 √ NULL::numeric
interest_method_enum int2 5 null
interest_calculated_in_period_enum int2 5 1
allow_partial_period_interest_calcualtion bool 1 false
term_frequency int2 5 0
term_period_frequency_enum int2 5 2
repay_every int2 5 null
repayment_period_frequency_enum int2 5 null
number_of_repayments int2 5 null
grace_on_principal_periods int2 5 √ null
recurring_moratorium_principal_periods int2 5 √ null
grace_on_interest_periods int2 5 √ null
grace_interest_free_periods int2 5 √ null
amortization_method_enum int2 5 null
submittedon_date date 13 √ null
approvedon_date date 13 √ null
approvedon_userid int8 19 √ null
m_appuser.id FK_approvedon_userid R
expected_disbursedon_date date 13 √ null
expected_firstrepaymenton_date date 13 √ null
interest_calculated_from_date date 13 √ null
disbursedon_date date 13 √ null
disbursedon_userid int8 19 √ null
m_appuser.id FK_disbursedon_userid R
expected_maturedon_date date 13 √ null
maturedon_date date 13 √ null
closedon_date date 13 √ null
closedon_userid int8 19 √ null
m_appuser.id FK_closedon_userid R
total_charges_due_at_disbursement_derived numeric 19,6 √ NULL::numeric
principal_disbursed_derived numeric 19,6 0
principal_repaid_derived numeric 19,6 0
principal_writtenoff_derived numeric 19,6 0
principal_outstanding_derived numeric 19,6 0
interest_charged_derived numeric 19,6 0
interest_repaid_derived numeric 19,6 0
interest_waived_derived numeric 19,6 0
interest_writtenoff_derived numeric 19,6 0
interest_outstanding_derived numeric 19,6 0
fee_charges_charged_derived numeric 19,6 0
fee_charges_repaid_derived numeric 19,6 0
fee_charges_waived_derived numeric 19,6 0
fee_charges_writtenoff_derived numeric 19,6 0
fee_charges_outstanding_derived numeric 19,6 0
penalty_charges_charged_derived numeric 19,6 0
penalty_charges_repaid_derived numeric 19,6 0
penalty_charges_waived_derived numeric 19,6 0
penalty_charges_writtenoff_derived numeric 19,6 0
penalty_charges_outstanding_derived numeric 19,6 0
total_expected_repayment_derived numeric 19,6 0
total_repayment_derived numeric 19,6 0
total_expected_costofloan_derived numeric 19,6 0
total_costofloan_derived numeric 19,6 0
total_waived_derived numeric 19,6 0
total_writtenoff_derived numeric 19,6 0
total_outstanding_derived numeric 19,6 0
total_overpaid_derived numeric 19,6 √ NULL::numeric
rejectedon_date date 13 √ null
rejectedon_userid int8 19 √ null
m_appuser.id FK_rejectedon_userid R
rescheduledon_date date 13 √ null
rescheduledon_userid int8 19 √ null
withdrawnon_date date 13 √ null
withdrawnon_userid int8 19 √ null
m_appuser.id FK_withdrawnon_userid R
writtenoffon_date date 13 √ null
loan_transaction_strategy_id int8 19 √ null
sync_disbursement_with_meeting bool 1 √ null
loan_counter int2 5 √ null
loan_product_counter int2 5 √ null
fixed_emi_amount numeric 19,6 √ NULL::numeric
max_outstanding_loan_balance numeric 19,6 √ NULL::numeric
grace_on_arrears_ageing int2 5 √ null
is_npa bool 1 false
total_recovered_derived numeric 19,6 √ NULL::numeric
accrued_till date 13 √ null
interest_recalcualated_on date 13 √ null
days_in_month_enum int2 5 1
days_in_year_enum int2 5 1
interest_recalculation_enabled bool 1 false
guarantee_amount_derived numeric 19,6 √ NULL::numeric
create_standing_instruction_at_disbursement bool 1 √ null
version int4 10 1
writeoff_reason_cv_id int4 10 √ null
m_code_value.id FK_writeoffreason_m_loan_m_code_value R
loan_sub_status_id int2 5 √ null
is_topup bool 1 false
is_equal_amortization bool 1 false
fixed_principal_percentage_per_installment numeric 5,2 √ NULL::numeric
created_on_utc timestamptz 35,6 null
created_by int8 19 null
m_appuser.id FK_loan_created_by R
last_modified_by int8 19 null
m_appuser.id FK_loan_last_modified_by R
last_modified_on_utc timestamptz 35,6 null
principal_adjustments_derived numeric 19,6 0
is_fraud bool 1 false
loan_transaction_strategy_code varchar 100 '-'::character varying
loan_transaction_strategy_name varchar 100 '-'::character varying
last_closed_business_date date 13 √ null
overpaidon_date date 13 √ null
is_charged_off bool 1 false
charged_off_on_date date 13 √ null
charge_off_reason_cv_id int8 19 √ null
charged_off_by_userid int8 19 √ null
enable_down_payment bool 1 false
disbursed_amount_percentage_for_down_payment numeric 9,6 √ NULL::numeric
enable_installment_level_delinquency bool 1 false
enable_accrual_activity_posting bool 1 false
days_in_year_custom_strategy varchar 100 √ null
enable_income_capitalization bool 1 false
capitalized_income_calculation_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
capitalized_income_strategy varchar 100 √ null
capitalized_income_type varchar 10 √ null
capitalized_income_derived numeric 19,6 0
capitalized_income_adjustment_derived numeric 19,6 0
total_principal_derived numeric 19,6 0
enable_buy_down_fee bool 1 false
buy_down_fee_calculation_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
buy_down_fee_strategy varchar 100 √ null
buy_down_fee_income_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
allow_full_term_for_tranche bool 1 false
repayment_start_date_type_enum int2 5 √ null
month_end_due_date_strategy varchar 100 √ null
enable_auto_repayment_for_down_payment bool 1 false
loan_schedule_type varchar 20 'CUMULATIVE'::character varying
loan_schedule_processing_type varchar 20 'HORIZONTAL'::character varying
fee_adjustments_derived numeric 19,6 0
penalty_adjustments_derived numeric 19,6 0
fixed_length int2 5 √ null
supported_interest_refund_types text 2147483647 √ null
charge_off_behaviour varchar 20 √ 'REGULAR'::character varying
interest_recognition_on_disbursement_date bool 1 false
installment_amount_in_multiples_of numeric 19,6 √ NULL::numeric
is_merchant_buy_down_fee bool 1 true

Indexes

Constraint Name Type Sort Column(s)
m_loan_pkey Primary key Asc id
fk7c885877240145 Performance Asc fund_id
FK_approvedon_userid Performance Asc approvedon_userid
FK_closedon_userid Performance Asc closedon_userid
FK_disbursedon_userid Performance Asc disbursedon_userid
FK_glim_id Performance Asc glim_id
FK_loan_expected_maturedon_date Performance Asc expected_maturedon_date
FK_loan_last_closed_business_date Performance Asc last_closed_business_date
FK_loan_ltp_strategy Performance Asc loan_transaction_strategy_id
FK_loan_overpaidon_date Performance Asc overpaidon_date
FK_loan_status_id Performance Asc loan_status_id
fk_m_group_client_001_idx Performance Asc/Asc group_id + client_id
FK_m_loan_m_staff Performance Asc loan_officer_id
FK_m_loanpurpose_codevalue Performance Asc loanpurpose_cv_id
FK_rejectedon_userid Performance Asc rejectedon_userid
FK_withdrawnon_userid Performance Asc withdrawnon_userid
FK_writeoffreason_m_loan_m_code_value Performance Asc writeoff_reason_cv_id
fkb6f935d87179a0cb Performance Asc client_id
fkb6f935d8c8d4b434 Performance Asc product_id
group_id Performance Asc group_id
m_loan_account_no_key Must be unique Asc account_no
m_loan_external_id_key Must be unique Asc external_id

Relationships

Close relationships within degrees of separation