m_loan_repayment_schedule_history

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
loan_id BIGINT 19 null
m_loan.id m_loan_repayment_schedule_history_ibfk_1R
loan_reschedule_request_id BIGINT 19 √ NULL
m_loan_reschedule_request.id m_loan_repayment_schedule_history_ibfk_2R
fromdate DATE 10 √ NULL
duedate DATE 10 null
installment SMALLINT 5 null
principal_amount DECIMAL 19,6 √ NULL
interest_amount DECIMAL 19,6 √ NULL
fee_charges_amount DECIMAL 19,6 √ NULL
penalty_charges_amount DECIMAL 19,6 √ NULL
createdby_id BIGINT 19 √ NULL
created_date DATETIME 19 √ NULL
lastmodified_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL
version INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
loan_id Performance Asc loan_id
loan_reschedule_request_id Performance Asc loan_reschedule_request_id

Relationships

Close relationships within degrees of separation