m_charge

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_product_mapping.charge_id FK_acc_product_mapping_m_chargeR
m_client_charge.charge_id FK_m_client_charge_m_chargeR
m_loan_charge.charge_id m_loan_charge_ibfk_1R
m_loan_tranche_charges.charge_id FK_m_loan_tranche_charges_m_chargeR
m_product_loan_charge.charge_id m_product_loan_charge_ibfk_1R
m_savings_account_charge.charge_id m_savings_account_charge_ibfk_1R
m_savings_product_charge.charge_id m_savings_product_charge_ibfk_1R
m_share_account_charge.charge_id m_share_account_charge_ibfk_1R
m_share_product_charge.charge_id m_share_product_charge_ibfk_1R
name VARCHAR 100 √ NULL
currency_code VARCHAR 3 null
charge_applies_to_enum SMALLINT 5 null
charge_time_enum SMALLINT 5 null
charge_calculation_enum SMALLINT 5 null
charge_payment_mode_enum SMALLINT 5 √ NULL
amount DECIMAL 19,6 null
fee_on_day SMALLINT 5 √ NULL
fee_interval SMALLINT 5 √ NULL
fee_on_month SMALLINT 5 √ NULL
is_penalty BIT 1 b'0'
is_active BIT 1 null
is_deleted BIT 1 b'0'
min_cap DECIMAL 19,6 √ NULL
max_cap DECIMAL 19,6 √ NULL
fee_frequency SMALLINT 5 √ NULL
is_free_withdrawal BIT 1 b'0'
free_withdrawal_charge_frequency INT 10 √ 0
restart_frequency INT 10 √ 0
restart_frequency_enum INT 10 √ 0
is_payment_type BIT 1 √ b'0'
payment_type_id INT 10 √ NULL
m_payment_type.id FK_m_payment_detail_m_payment_typesR
income_or_liability_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_m_charge_acc_gl_accountR
tax_group_id BIGINT 19 √ NULL
m_tax_group.id FK_m_charge_m_tax_groupR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_charge_acc_gl_account Performance Asc income_or_liability_account_id
FK_m_charge_m_tax_group Performance Asc tax_group_id
FK_m_payment_detail_m_payment_types Performance Asc payment_type_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation