m_savings_product

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_client.default_savings_product FK_m_client_m_savings_product R
m_deposit_product_interest_rate_chart.deposit_product_id fkdpirc00000000000001 R
m_deposit_product_recurring_detail.savings_product_id fkdprd00000000000001 R
m_deposit_product_term_and_preclosure.savings_product_id fkdptp00000000000001 R
m_savings_account.product_id fksa00000000000003 R
m_savings_product_charge.savings_product_id m_savings_product_charge_ibfk_2 R
name varchar 100 null
short_name varchar 4 null
description varchar 500 √ null
deposit_type_enum int2 5 100
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
nominal_annual_interest_rate numeric 19,6 null
interest_compounding_period_enum int2 5 null
interest_posting_period_enum int2 5 4
interest_calculation_type_enum int2 5 null
interest_calculation_days_in_year_type_enum int2 5 null
min_required_opening_balance numeric 19,6 √ NULL::numeric
lockin_period_frequency numeric 19,6 √ NULL::numeric
lockin_period_frequency_enum int2 5 √ null
accounting_type int2 5 null
withdrawal_fee_amount numeric 19,6 √ NULL::numeric
withdrawal_fee_type_enum int2 5 √ null
withdrawal_fee_for_transfer bool 1 √ true
allow_overdraft bool 1 false
overdraft_limit numeric 19,6 √ NULL::numeric
nominal_annual_interest_rate_overdraft numeric 19,6 √ 0
min_overdraft_for_interest_calculation numeric 19,6 √ 0
min_required_balance numeric 19,6 √ NULL::numeric
enforce_min_required_balance bool 1 false
min_balance_for_interest_calculation numeric 19,6 √ NULL::numeric
withhold_tax bool 1 false
tax_group_id int8 19 √ null
m_tax_group.id FK_savings_product_tax_group R
is_dormancy_tracking_active bool 1 √ null
days_to_inactive int4 10 √ null
days_to_dormancy int4 10 √ null
days_to_escheat int4 10 √ null
max_allowed_lien_limit numeric 19,6 √ NULL::numeric
is_lien_allowed bool 1 false

Indexes

Constraint Name Type Sort Column(s)
m_savings_product_pkey Primary key Asc id
FK_savings_product_tax_group Performance Asc tax_group_id
m_savings_product_name_key Must be unique Asc name
m_savings_product_short_name_key Must be unique Asc short_name

Relationships

Close relationships within degrees of separation