m_loan_charge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_loan_charge_paid_by.loan_charge_id FK__m_loan_charge R
m_loan_charge_tax_details.loan_charge_id fk_loan_charge_tax_details_charge R
m_loan_installment_charge.loan_charge_id FK_loan_charge_id_charge_schedule R
m_loan_overdue_installment_charge.loan_charge_id FK_m_loan_overdue_installment_charge_m_loan_charge R
m_loan_tranche_disbursement_charge.loan_charge_id FK_m_loan_tranche_disbursement_charge_m_loan_charge R
m_loan_transaction_relation.to_loan_charge_id FK_m_loan_charge_to_relation R
loan_id int8 19 null
m_loan.id m_loan_charge_ibfk_2 R
charge_id int8 19 null
m_charge.id m_loan_charge_ibfk_1 R
is_penalty bool 1 false
charge_time_enum int2 5 null
due_for_collection_as_of_date date 13 √ null
charge_calculation_enum int2 5 null
charge_payment_mode_enum int2 5 0
calculation_percentage numeric 19,6 √ NULL::numeric
calculation_on_amount numeric 19,6 √ NULL::numeric
charge_amount_or_percentage numeric 19,6 √ NULL::numeric
amount numeric 19,6 null
amount_paid_derived numeric 19,6 √ NULL::numeric
amount_waived_derived numeric 19,6 √ NULL::numeric
amount_writtenoff_derived numeric 19,6 √ NULL::numeric
amount_outstanding_derived numeric 19,6 0
is_paid_derived bool 1 false
waived bool 1 false
min_cap numeric 19,6 √ NULL::numeric
max_cap numeric 19,6 √ NULL::numeric
is_active bool 1 true
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
created_by int8 19 null
m_appuser.id FK_loan_charge_created_by R
last_modified_by int8 19 null
m_appuser.id FK_loan_charge_last_modified_by R
tax_amount numeric 19,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_loan_charge_pkey Primary key Asc id
charge_id Performance Asc charge_id
m_loan_charge_external_id_key Must be unique Asc external_id
m_loan_charge_ibfk_2 Performance Asc loan_id

Relationships

Close relationships within degrees of separation