m_loan_reschedule_request

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_loan_repayment_schedule_history.loan_reschedule_request_id m_loan_repayment_schedule_history_ibfk_2R
m_loan_reschedule_request_term_variations_mapping.loan_reschedule_request_id FK__m_loan_reschedule_requestR
loan_id BIGINT 19 null
m_loan.id m_loan_reschedule_request_ibfk_1R
status_enum SMALLINT 5 null
reschedule_from_installment SMALLINT 5 √ NULL

Rescheduling will start from this installment
reschedule_from_date DATE 10 √ NULL

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

If set to 1, interest will be recalculated starting from the reschedule period.
reschedule_reason_cv_id INT 10 √ NULL
m_code_value.id m_loan_reschedule_request_ibfk_2R

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 10 null
submitted_by_user_id BIGINT 19 null
m_appuser.id m_loan_reschedule_request_ibfk_3R
approved_on_date DATE 10 √ NULL
approved_by_user_id BIGINT 19 √ NULL
m_appuser.id m_loan_reschedule_request_ibfk_4R
rejected_on_date DATE 10 √ NULL
rejected_by_user_id BIGINT 19 √ NULL
m_appuser.id m_loan_reschedule_request_ibfk_5R

Indexes

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