m_share_account_transactions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.share_transaction_id FK_acc_gl_journal_entry_m_share_account_transactionR
m_share_account_charge_paid_by.share_transaction_id m_share_account_transactions_charge_mapping_ibfk1R
account_id BIGINT 19 null
m_share_account.id m_share_account_purchased_shares_ibfk_1R
transaction_date DATE 10 √ NULL
total_shares BIGINT 19 √ NULL
unit_price DECIMAL 10,2 √ NULL
amount DECIMAL 20,2 √ NULL
charge_amount DECIMAL 20,2 √ NULL
amount_paid DECIMAL 20,2 √ NULL
status_enum SMALLINT 5 300
type_enum SMALLINT 5 √ NULL
is_active BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
m_share_account_purchased_shares_ibfk_1 Performance Asc account_id

Relationships

Close relationships within degrees of separation