m_share_account_charge

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_share_account_charge_paid_by.charge_transaction_id m_share_account_transactions_charge_mapping_ibfk2R
account_id BIGINT 19 null
m_share_account.id m_share_account_charge_ibfk_2R
charge_id BIGINT 19 null
m_charge.id m_share_account_charge_ibfk_1R
charge_time_enum SMALLINT 5 null
charge_calculation_enum SMALLINT 5 null
charge_payment_mode_enum SMALLINT 5 0
calculation_percentage DECIMAL 19,6 √ NULL
calculation_on_amount DECIMAL 19,6 √ NULL
charge_amount_or_percentage 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'
min_cap DECIMAL 19,6 √ NULL
max_cap DECIMAL 19,6 √ NULL
is_active BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_share_account_charge_charge Performance Asc charge_id
m_share_account_charge_ibfk_2 Performance Asc account_id

Relationships

Close relationships within degrees of separation