m_loan_reschedule_request

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_loan_repayment_schedule_history.loan_reschedule_request_id m_loan_repayment_schedule_history_ibfk_2 R
m_loan_reschedule_request_term_variations_mapping.loan_reschedule_request_id FK__m_loan_reschedule_request R
loan_id int8 19 null
m_loan.id m_loan_reschedule_request_ibfk_1 R
status_enum int2 5 null
reschedule_from_installment int2 5 null

Rescheduling will start from this installment
reschedule_from_date date 13 null

Rescheduling will start from the installment with due date similar to this date.
recalculate_interest bool 1 √ null

If set to 1, interest will be recalculated starting from the reschedule period.
reschedule_reason_cv_id int4 10 √ null
m_code_value.id m_loan_reschedule_request_ibfk_2 R

ID of code value of reason for rescheduling
reschedule_reason_comment varchar 500 √ null

Text provided in addition to the reason code value
submitted_on_date date 13 null
submitted_by_user_id int8 19 null
m_appuser.id m_loan_reschedule_request_ibfk_3 R
approved_on_date date 13 √ null
approved_by_user_id int8 19 √ null
m_appuser.id m_loan_reschedule_request_ibfk_4 R
rejected_on_date date 13 √ null
rejected_by_user_id int8 19 √ null
m_appuser.id m_loan_reschedule_request_ibfk_5 R

Indexes

Constraint Name Type Sort Column(s)
m_loan_reschedule_request_pkey Primary key Asc id
approved_by_user_id Performance Asc approved_by_user_id
loan_reschedule_request_loan_id Performance Asc loan_id
rejected_by_user_id Performance Asc rejected_by_user_id
reschedule_reason_cv_id Performance Asc reschedule_reason_cv_id
submitted_by_user_id Performance Asc submitted_by_user_id

Relationships

Close relationships within degrees of separation