m_mandatory_savings_schedule

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
savings_account_id int8 19 null
m_savings_account.id fkmss0000000001 R
fromdate date 13 √ null
duedate date 13 null
installment int2 5 null
deposit_amount numeric 19,6 √ NULL::numeric
deposit_amount_completed_derived numeric 19,6 √ NULL::numeric
total_paid_in_advance_derived numeric 19,6 √ NULL::numeric
total_paid_late_derived numeric 19,6 √ NULL::numeric
completed_derived bool 1 null
obligations_met_on_date date 13 √ null
created_by int8 19 null
m_appuser.id FK_mandatory_savings_schedule_created_by R
created_date timestamp 29,6 √ null
lastmodified_date timestamp 29,6 √ null
last_modified_by int8 19 null
m_appuser.id FK_mandatory_savings_schedule_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
m_mandatory_savings_schedule_pkey Primary key Asc id
fkmss0000000001 Performance Asc savings_account_id

Relationships

Close relationships within degrees of separation