m_loan_term_variations

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_loan_reschedule_request_term_variations_mapping.loan_term_variations_id FK__m_loan_term_variations R
loan_id int8 19 null
m_loan.id FK_loan_id_m_loan_id R
term_type int2 5 null
applicable_date date 13 null
decimal_value numeric 19,6 √ NULL::numeric
date_value date 13 √ null
is_specific_to_installment bool 1 false
applied_on_loan_status int2 5 null
is_active bool 1 true
parent_id int8 19 √ null
created_on_utc timestamptz 35,6 √ null
created_by int8 19 √ null
m_appuser.id FK_loan_term_variations_created_by R
last_modified_by int8 19 √ null
m_appuser.id FK_loan_term_variations_last_modified_by R
last_modified_on_utc timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_loan_term_variations_pkey Primary key Asc id
FK_loan_id_m_loan_id Performance Asc loan_id

Relationships

Close relationships within degrees of separation