m_savings_account_charge

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_savings_account_charge_paid_by.savings_account_charge_id FK__m_savings_account_chargeR
savings_account_id BIGINT 19 null
m_savings_account.id m_savings_account_charge_ibfk_2R
charge_id BIGINT 19 null
m_charge.id m_savings_account_charge_ibfk_1R
is_penalty BIT 1 b'0'
charge_time_enum SMALLINT 5 null
charge_due_date DATE 10 √ NULL
fee_on_month SMALLINT 5 √ NULL
fee_on_day SMALLINT 5 √ NULL
fee_interval SMALLINT 5 √ NULL
free_withdrawal_count INT 10 √ 0
charge_reset_date DATE 10 √ NULL
charge_calculation_enum SMALLINT 5 null
calculation_percentage DECIMAL 19,6 √ NULL
calculation_on_amount DECIMAL 19,6 √ NULL
amount DECIMAL 19,6 null
amount_paid_derived DECIMAL 19,6 √ NULL
amount_waived_derived DECIMAL 19,6 √ NULL
amount_writtenoff_derived DECIMAL 19,6 √ NULL
amount_outstanding_derived DECIMAL 19,6 0.000000
is_paid_derived BIT 1 b'0'
waived BIT 1 b'0'
is_active BIT 1 b'1'
inactivated_on_date DATE 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_savings_account_charge_charge Performance Asc charge_id
m_savings_account_charge_ibfk_2 Performance Asc savings_account_id

Relationships

Close relationships within degrees of separation