m_share_account_transactions

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.share_transaction_id FK_acc_gl_journal_entry_m_share_account_transaction R
m_share_account_charge_paid_by.share_transaction_id m_share_account_transactions_charge_mapping_ibfk1 R
account_id int8 19 null
m_share_account.id m_share_account_purchased_shares_ibfk_1 R
transaction_date date 13 √ null
total_shares int8 19 √ null
unit_price numeric 10,2 √ NULL::numeric
amount numeric 20,2 √ NULL::numeric
charge_amount numeric 20,2 √ NULL::numeric
amount_paid numeric 20,2 √ NULL::numeric
status_enum int2 5 300
type_enum int2 5 √ null
is_active bool 1 true

Indexes

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

Relationships

Close relationships within degrees of separation