account_transaction

0 rows


Description

Table represents the transactions of customers including purchases,deposits,withdrawals and reversals. More specific data is available for deposits, purchases (ticket_sales) and withdrawals under the relevant table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_transaction_id int8 19 null
account_transaction_reversed.account_transaction_id account_transaction_reversed_account_transaction_id_fkeyR
account_transaction_status_history.account_transaction_id account_transaction_status_history_account_transaction_id_fkeyR
deposit.account_transaction_id deposit_account_transaction_id_fkeyR
gift.account_transaction_id gift_account_transaction_id_fkeyR
reward_account_bucket_transaction.account_transaction_id reward_account_bucket_transaction_account_transaction_id_fkeyR
syndicate_dividend.account_transaction_id syndicate_dividend_account_transaction_id_fkeyR
ticket_dividend.account_transaction_id ticket_dividend_account_transaction_id_fkeyR
withdraw.account_transaction_id withdraw_account_transaction_id_fkeyR

Primary key: an identifier for this record
account_transaction_type_name text 2147483647 √ null

What kind of transaction this was: withdrawal|deposit|purchase_ticket|purchase_syndicate|reversal|
winning_ticket|winning_syndicate|id_verify|unknown|free_ticket|purchase_credit|winning_prize|purchase_membership
transaction_amount numeric 17,2 √ null

How much the transaction was. Negative amounts indicate money out of a customer balance
customer_id int4 10 √ null
customer.customer_id account_transaction_customer_id_fkeyR

Ref: many-to-one to customer
is_reversal bool 1 √ null

Was this transaction a reversal of a previous transaction of the same kind?
dim_lottery_id int4 10 √ null
dim_lottery.dim_lottery_id account_transaction_dim_lottery_id_fkeyR

Which lottery (if any) did this transaction apply to?
dim_transfer_method_id int4 10 √ null
dim_transfer_method.dim_transfer_method_id deposit_dim_transfer_method_id_fkeyR

See table dim_transfer_method

Indexes

Constraint Name Type Sort Column(s)
account_transaction_pkey Primary key Asc account_transaction_id
idx_account_transaction_dim_lottery_id Performance Asc dim_lottery_id
idx_account_transaction_dim_transfer_method_id Performance Asc dim_transfer_method_id

Relationships

Close relationships within degrees of separation