m_loan_repayment_schedule_history

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
loan_id int8 19 null
m_loan.id m_loan_repayment_schedule_history_ibfk_1 R
loan_reschedule_request_id int8 19 √ null
m_loan_reschedule_request.id m_loan_repayment_schedule_history_ibfk_2 R
fromdate date 13 √ null
duedate date 13 null
installment int2 5 null
principal_amount numeric 19,6 √ NULL::numeric
interest_amount numeric 19,6 √ NULL::numeric
fee_charges_amount numeric 19,6 √ NULL::numeric
penalty_charges_amount numeric 19,6 √ NULL::numeric
createdby_id int8 19 √ null
created_date timestamp 29,6 √ null
lastmodified_date timestamp 29,6 √ null
lastmodifiedby_id int8 19 √ null
version int4 10 null
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
m_loan_repayment_schedule_history_pkey 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