m_savings_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_client.default_savings_product FK_m_client_m_savings_productR
m_deposit_product_interest_rate_chart.deposit_product_id FKDPIRC00000000000001R
m_deposit_product_recurring_detail.savings_product_id FKDPRD00000000000001R
m_deposit_product_term_and_preclosure.savings_product_id FKDPTP00000000000001R
m_savings_account.product_id FKSA00000000000003R
m_savings_product_charge.savings_product_id m_savings_product_charge_ibfk_2R
name VARCHAR 100 null
short_name VARCHAR 4 null
description VARCHAR 500 √ NULL
deposit_type_enum SMALLINT 5 100
currency_code VARCHAR 3 null
currency_digits SMALLINT 5 null
currency_multiplesof SMALLINT 5 √ NULL
nominal_annual_interest_rate DECIMAL 19,6 null
interest_compounding_period_enum SMALLINT 5 null
interest_posting_period_enum SMALLINT 5 4
interest_calculation_type_enum SMALLINT 5 null
interest_calculation_days_in_year_type_enum SMALLINT 5 null
min_required_opening_balance DECIMAL 19,6 √ NULL
lockin_period_frequency DECIMAL 19,6 √ NULL
lockin_period_frequency_enum SMALLINT 5 √ NULL
accounting_type SMALLINT 5 null
withdrawal_fee_amount DECIMAL 19,6 √ NULL
withdrawal_fee_type_enum SMALLINT 5 √ NULL
withdrawal_fee_for_transfer BIT 1 √ b'1'
allow_overdraft BIT 1 b'0'
overdraft_limit DECIMAL 19,6 √ NULL
nominal_annual_interest_rate_overdraft DECIMAL 19,6 √ 0.000000
min_overdraft_for_interest_calculation DECIMAL 19,6 √ 0.000000
min_required_balance DECIMAL 19,6 √ NULL
enforce_min_required_balance BIT 1 b'0'
min_balance_for_interest_calculation DECIMAL 19,6 √ NULL
withhold_tax BIT 1 b'0'
tax_group_id BIGINT 19 √ NULL
m_tax_group.id FK_savings_product_tax_groupR
is_dormancy_tracking_active BIT 1 √ NULL
days_to_inactive INT 10 √ NULL
days_to_dormancy INT 10 √ NULL
days_to_escheat INT 10 √ NULL
max_allowed_lien_limit DECIMAL 19,6 √ NULL
is_lien_allowed BIT 1 b'0'

Indexes

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

Relationships

Close relationships within degrees of separation