m_savings_account_charge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_savings_account_charge_paid_by.savings_account_charge_id FK__m_savings_account_charge R
savings_account_id int8 19 null
m_savings_account.id m_savings_account_charge_ibfk_2 R
charge_id int8 19 null
m_charge.id m_savings_account_charge_ibfk_1 R
is_penalty bool 1 false
charge_time_enum int2 5 null
charge_due_date date 13 √ null
fee_on_month int2 5 √ null
fee_on_day int2 5 √ null
fee_interval int2 5 √ null
free_withdrawal_count int4 10 √ 0
charge_reset_date date 13 √ null
charge_calculation_enum int2 5 null
calculation_percentage numeric 19,6 √ NULL::numeric
calculation_on_amount numeric 19,6 √ NULL::numeric
amount numeric 19,6 null
amount_paid_derived numeric 19,6 √ NULL::numeric
amount_waived_derived numeric 19,6 √ NULL::numeric
amount_writtenoff_derived numeric 19,6 √ NULL::numeric
amount_outstanding_derived numeric 19,6 0
is_paid_derived bool 1 false
waived bool 1 false
is_active bool 1 true
inactivated_on_date date 13 √ null
created_by int8 19 null
m_appuser.id FK_savings_account_charge_created_by R
last_modified_by int8 19 null
m_appuser.id FK_savings_account_charge_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_savings_account_charge_pkey 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