m_wc_loan

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_wc_loan_amortization_model.loan_id fk_m_wc_loan_amort_model_loan R
m_wc_loan_balance.wc_loan_id FK_m_wc_loan_balance_loan R
m_wc_loan_breach_action.wc_loan_id FK_wc_loan_breach_action_loan R
m_wc_loan_breach_schedule.wc_loan_id FK_wc_breach_schedule_loan R
m_wc_loan_delinquency_action.wc_loan_id FK_wc_loan_delinquency_action_loan R
m_wc_loan_delinquency_range_schedule.wc_loan_id FK_wc_delinquency_range_schedule_loan R
m_wc_loan_disbursement_detail.wc_loan_id FK_m_wc_loan_disbursement_detail_loan R
m_wc_loan_near_breach_action.wc_loan_id fk_wc_near_breach_action_loan R
m_wc_loan_note.wc_loan_id FK_m_wc_loan_note_loan R
m_wc_loan_originator_mapping.loan_id FK_wc_loan_originator_mapping_wc_loan R
m_wc_loan_payment_allocation_rule.wc_loan_id m_wc_loan_payment_allocation_rule_loan_fk R
m_wc_loan_period_payment_rate_change.wc_loan_id fk_wc_rate_change_loan R
m_wc_loan_range_delinquency_tag.loan_id fk_m_wc_loan_range_delinquency_tag_on_loan R
m_wc_loan_transaction.wc_loan_id FK_m_wc_loan_transaction_loan R
version int4 10 null
created_by int8 19 null
m_appuser.id FK_m_wc_loan_created_by R
last_modified_by int8 19 null
m_appuser.id FK_m_wc_loan_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
loan_status_id int2 5 0
last_closed_business_date date 13 √ null
account_no varchar 20 √ null
external_id varchar 100 √ null
disbursedon_date date 13 √ null
client_id int8 19 √ null
m_client.id FK_m_wc_loan_client R
fund_id int8 19 √ null
m_fund.id FK_m_wc_loan_fund R
product_id int8 19 null
m_wc_loan_product.id FK_m_wc_loan_product R
submittedon_date date 13 √ null
rejectedon_date date 13 √ null
rejectedon_userid int8 19 √ null
m_appuser.id FK_m_wc_loan_rejected_by R
approvedon_date date 13 √ null
approvedon_userid int8 19 √ null
m_appuser.id FK_m_wc_loan_approved_by R
closedon_date date 13 √ null
closedon_userid int8 19 √ null
m_appuser.id FK_m_wc_loan_closed_by R
expected_maturedon_date date 13 √ null
maturedon_date date 13 √ null
principal_amount_proposed numeric 19,6 null
approved_principal numeric 19,6 null
currency_code varchar 3 √ NULL::character varying
currency_digits int2 5 √ null
currency_multiplesof int2 5 √ null
principal_amount numeric 19,6 √ NULL::numeric
period_payment_rate numeric 19,6 √ NULL::numeric
repayment_every int4 10 √ null
repayment_frequency_enum varchar 50 √ NULL::character varying
amortization_type varchar 50 √ NULL::character varying
npv_day_count int4 10 √ null
discount numeric 19,6 √ NULL::numeric
delinquency_bucket_classification_id int8 19 √ null
m_delinquency_bucket.id FK_m_wc_loan_delinquency_bucket R
loan_counter int4 10 √ null
loan_product_counter int4 10 √ null
delinquency_grace_days int4 10 √ null
delinquency_start_type varchar 20 √ null
wc_loan_product_id int8 19 √ null
m_wc_loan_product.id FK_wc_loan_product R
breach_id int8 19 √ null
m_wc_breach_configuration.id FK_m_wc_loan_breach_cfg R
near_breach_id int8 19 √ null
m_wc_near_breach.id FK_m_wc_loan_near_breach R
discount_proposed numeric 19,6 √ null
discount_approved numeric 19,6 √ null
total_payment_volume numeric 19,6 √ null
breach_grace_days int4 10 √ null
breach_start_type varchar 20 √ null
is_charged_off bool 1 false
charged_off_on_date date 13 √ null
charge_off_reason_cv_id int4 10 √ null
m_code_value.id FK_m_wc_loan_charge_off_reason R
charged_off_by_userid int8 19 √ null
m_appuser.id FK_m_wc_loan_charged_off_by R
is_fraud bool 1 false
written_off_on_date date 13 √ null
write_off_reason_cv_id int4 10 √ null
m_code_value.id FK_m_wc_loan_write_off_reason R
overpaid_on_date date 13 √ null
payment_amount_calculation_strategy varchar 20 'TPV'::character varying
annual_eir numeric 19,6 √ null
payment_amount numeric 19,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_wc_loan_pkey Primary key Asc id
IND_m_wc_loan_client_id Performance Asc client_id
IND_m_wc_loan_external_id Performance Asc external_id
IND_m_wc_loan_loan_status_id Performance Asc loan_status_id
IND_m_wc_loan_product_id Performance Asc product_id
m_wc_loan_external_id_key Must be unique Asc external_id
wc_loan_account_no_UNIQUE Must be unique Asc account_no

Check Constraints

Constraint Name Constraint
m_wc_loan_product_id_not_null1 product_id IS NOT NULL

Relationships

Close relationships within degrees of separation