account_transaction_summary

1 rows


Description

Table represents daily summaries of account_transaction according to QLD timezone. Aggregated for performance reasons

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_transaction_type_name text 2147483647 √ null

What kind of transaction is being summarised: 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

Total amount of transactions of type <account_transaction_type_name> on date <account_transaction_summary_date>
dim_date_id int4 10 √ null
dim_date.dim_date_id account_transaction_summary_dim_date_id_fkeyR

Used for date indexing, applied to account_transaction_summary_date
account_transaction_summary_date date 13 √ null

Date of transactions summarised by this record
account_transaction_summary_timestamp timestamptz 35,6 √ now()

When this record was created

Indexes

Constraint Name Type Sort Column(s)
idx_account_transaction_summary_date Performance Asc account_transaction_summary_date
idx_account_transaction_summary_dim_date_id Performance Asc dim_date_id
idx_account_transaction_type_name Performance Asc account_transaction_type_name

Relationships

Close relationships within degrees of separation