reward_account_bucket_transaction

0 rows


Description

Transactions for reward account buckets only. Positive amount = deposit. Negative amount = spend (e.g. ticket purchased using rewards).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_bucket_transaction_id int8 19 null
account_transaction_id int8 19 √ null
account_transaction.account_transaction_id reward_account_bucket_transaction_account_transaction_id_fkeyR
account_bucket_id int8 19 √ null
reward_account_bucket.account_bucket_id reward_account_bucket_transaction_account_bucket_id_fkeyR

Ref: reward_account_bucket.account_bucket_id
ticket_id int4 10 √ null
ticket_sales.ticket_id reward_account_bucket_transaction_ticket_id_fkeyR

Populated for purchase_ticket transactions; links to ticket_sales
account_transaction_timestamp timestamptz 35,6 √ null
account_bucket_transaction_amount numeric 15,2 √ null

Positive = deposit, negative = spend

Indexes

Constraint Name Type Sort Column(s)
reward_account_bucket_transaction_pkey Primary key Asc account_bucket_transaction_id

Relationships

Close relationships within degrees of separation