m_loan_charge

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_loan_charge_paid_by.loan_charge_id FK__m_loan_chargeR
m_loan_installment_charge.loan_charge_id FK_loan_charge_id_charge_scheduleR
m_loan_overdue_installment_charge.loan_charge_id FK_m_loan_overdue_installment_charge_m_loan_chargeR
m_loan_tranche_disbursement_charge.loan_charge_id FK_m_loan_tranche_disbursement_charge_m_loan_chargeR
loan_id BIGINT 19 null
m_loan.id m_loan_charge_ibfk_2R
charge_id BIGINT 19 null
m_charge.id m_loan_charge_ibfk_1R
is_penalty BIT 1 b'0'
charge_time_enum SMALLINT 5 null
due_for_collection_as_of_date DATE 10 √ NULL
charge_calculation_enum SMALLINT 5 null
charge_payment_mode_enum SMALLINT 5 0
calculation_percentage DECIMAL 19,6 √ NULL
calculation_on_amount DECIMAL 19,6 √ NULL
charge_amount_or_percentage DECIMAL 19,6 √ NULL
amount DECIMAL 19,6 null
amount_paid_derived DECIMAL 19,6 √ NULL
amount_waived_derived DECIMAL 19,6 √ NULL
amount_writtenoff_derived DECIMAL 19,6 √ NULL
amount_outstanding_derived DECIMAL 19,6 0.000000
is_paid_derived BIT 1 b'0'
waived BIT 1 b'0'
min_cap DECIMAL 19,6 √ NULL
max_cap DECIMAL 19,6 √ NULL
is_active BIT 1 b'1'
external_id VARCHAR 100 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation