m_wc_loan_product

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_wc_loan.product_id FK_m_wc_loan_product R
m_wc_loan.wc_loan_product_id FK_wc_loan_product R
m_wc_loan_product_configurable_attributes.wc_loan_product_id m_wc_loan_product_configurable_attributes_fk R
m_wc_loan_product_payment_allocation_rule.wc_loan_product_id m_wc_loan_product_payment_allocation_rule_fk R
name varchar 100 null
short_name varchar 4 null
external_id varchar 100 √ null
fund_id int8 19 √ null
m_fund.id FK_wc_loan_product_fund R
start_date date 13 √ null
close_date date 13 √ null
description varchar 500 √ null
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
amortization_type varchar 50 null
delinquency_bucket_classification_id int8 19 √ null
m_delinquency_bucket.id FK_wc_loan_product_delinquency_bucket R
npv_day_count int4 10 null
min_principal_amount numeric 19,6 √ NULL::numeric
principal_amount numeric 19,6 null
max_principal_amount numeric 19,6 √ NULL::numeric
min_period_payment_rate numeric 19,6 √ NULL::numeric
period_payment_rate numeric 19,6 √ null
max_period_payment_rate numeric 19,6 √ NULL::numeric
discount numeric 19,6 √ NULL::numeric
repayment_every int4 10 null
repayment_frequency_enum varchar 50 null
delinquency_grace_days int4 10 √ null
delinquency_start_type varchar 20 √ null
breach_id int8 19 √ null
m_wc_breach_configuration.id FK_m_wc_loan_product_breach_cfg R
accounting_type varchar 20 'NONE'::character varying
near_breach_id int8 19 √ null
m_wc_near_breach.id FK_m_wc_loan_product_near_breach R
breach_grace_days int4 10 √ null
breach_start_type varchar 20 √ null
payment_amount_calculation_strategy varchar 20 'TPV'::character varying
annual_eir numeric 19,6 √ null
min_annual_eir numeric 19,6 √ null
max_annual_eir numeric 19,6 √ null
payment_amount numeric 19,6 √ null
min_payment_amount numeric 19,6 √ null
max_payment_amount numeric 19,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_wc_loan_product_pkey Primary key Asc id
IND_wc_loan_product_external_id Performance Asc external_id
IND_wc_loan_product_fund_id Performance Asc fund_id
m_wc_loan_product_external_id_key Must be unique Asc external_id
m_wc_loan_product_name_key Must be unique Asc name
m_wc_loan_product_short_name_key Must be unique Asc short_name

Relationships

Close relationships within degrees of separation