m_wc_loan_charge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_wc_loan_charge_paid_by.wc_loan_charge_id fk_wc_charge_paid_by_charge R
m_wc_loan_transaction_relation.to_loan_charge_id fk_m_wc_loan_transaction_relation_on_to_loan_charge R
loan_id int8 19 null
charge_id int8 19 null
is_penalty bool 1 false
charge_time_type int2 5 null
charge_calculation_type int2 5 null
charge_payment_mode int2 5 0
amount_paid numeric 19,6 √ NULL::numeric
amount numeric 19,6 √ NULL::numeric
is_paid bool 1 false
is_active bool 1 true
due_date date 13 √ null
created_by int8 19 null
m_appuser.id FK_wc_loan_charge_created_by R
last_modified_by int8 19 null
m_appuser.id FK_wc_loan_charge_last_modified_by R
external_id varchar 100 √ null
submitted_on_date date 13 null
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
amount_written_off numeric 19,6 0
amount_waived numeric 19,6 0

Indexes

Constraint Name Type Sort Column(s)
m_wc_loan_charge_pkey Primary key Asc id
m_wc_loan_charge_external_id_key Must be unique Asc external_id

Relationships

Close relationships within degrees of separation