m_wc_loan_delinquency_range_schedule

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_wc_loan_range_delinquency_tag.range_id fk_m_wc_loan_range_delinquency_tag_on_range R
wc_loan_id int8 19 null
m_wc_loan.id FK_wc_delinquency_range_schedule_loan R
period_number int4 10 null
from_date date 13 null
to_date date 13 null
expected_amount numeric 19,6 √ null
numeric 19,6 √ null
outstanding_amount numeric 19,6 √ null
min_payment_criteria_met bool 1 √ null
created_by int8 19 null
m_appuser.id FK_wc_delinquency_range_schedule_created_by R
last_modified_by int8 19 null
m_appuser.id FK_wc_delinquency_range_schedule_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
delinquent_days int8 19 √ null
delinquent_amount numeric 19,6 √ null
version int4 10 0
base_expected_amount numeric 19,6 √ null
reset bool 1 false

Indexes

Constraint Name Type Sort Column(s)
m_wc_loan_delinquency_range_schedule_pkey Primary key Asc id
IND_wc_delinquency_range_schedule_loan_id Performance Asc wc_loan_id
uc_wc_delinquency_range_schedule_loan_period Must be unique Asc/Asc wc_loan_id + period_number

Relationships

Close relationships within degrees of separation