m_wc_loan_balance

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
wc_loan_id int8 19 null
m_wc_loan.id FK_m_wc_loan_balance_loan R
principal_paid numeric 19,6 null
realized_income_from_discount_fee numeric 19,6 null
version int4 10 null
created_by int8 19 null
last_modified_by int8 19 null
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
overpayment_amount numeric 19,6 0
principal numeric 19,6 0
fee numeric 19,6 0
fee_paid numeric 19,6 0
penalty numeric 19,6 0
penalty_paid numeric 19,6 0
total_disbursement numeric 19,6 0
total_discount_fee numeric 19,6 0
total_discount_fee_adjustment numeric 19,6 0
breach_pastdue_amount numeric 19,6 0
principal_adjustment numeric 19,6 0
principal_written_off numeric 19,6 0
fee_written_off numeric 19,6 0
penalty_written_off numeric 19,6 0
total_recovered numeric 19,6 0
fee_waived numeric 19,6 0
penalty_waived numeric 19,6 0

Indexes

Constraint Name Type Sort Column(s)
m_wc_loan_balance_pkey Primary key Asc id
m_wc_loan_balance_wc_loan_id_key Must be unique Asc wc_loan_id

Relationships

Close relationships within degrees of separation