m_mandatory_savings_schedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
savings_account_id BIGINT 19 null
m_savings_account.id FKMSS0000000001R
fromdate DATE 10 √ NULL
duedate DATE 10 null
installment SMALLINT 5 null
deposit_amount DECIMAL 19,6 √ NULL
deposit_amount_completed_derived DECIMAL 19,6 √ NULL
total_paid_in_advance_derived DECIMAL 19,6 √ NULL
total_paid_late_derived DECIMAL 19,6 √ NULL
completed_derived BIT 1 null
obligations_met_on_date DATE 10 √ NULL
createdby_id BIGINT 19 √ NULL
created_date DATETIME 19 √ NULL
lastmodified_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKMSS0000000001 Performance Asc savings_account_id

Relationships

Close relationships within degrees of separation