Tables

System table for PBJ platform. Table records the last updated timestamp for various tables on corresponding nodes which can be used to look up during ETL

Table represents customers communication preferences

For commercial lotteries. Table represents syndicate dividends

System table for PBJ platform. Table represents the update history for schema files

Table represents the status history of each account transaction. There may be several transaction statuses or states for each transaction over time

Table represents deposit specific data related to transactions

A dimension table to normalise draws for the lotteries

For commercial lotteries. Table represents customer syndicate share purchases

Table represents the withdrawals of customers

Dimension table for list of all available browsers (primarily used in customer_action)

Gift attributes — one row per gift

Table represents a dimension of a day. This is not locked to a timezone and is updated daily

A dimension table to normalise pricing types

Deprecated

A dimension table to normalise lotteries

Table represents the customers from the node databases

Track changing attribute of syndicate session sales.

A dimension table to normalise recurring purchase types

A dimension table to normalise PBJ sales and supplier channels

One row per reward bucket — a bucket is tied to a single reward deposit

System table which identifies consistency and possible missing data across the metrics database transactional tables

Status transitions for a gift purchase — one row per status change.

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

Table represents customers events

A dimension table to normalise commercial lottery syndicates

Table represents the account transactions that were reversed

Table represents the status history of each deposit

A dimension table to normalise commerical lottery product offers

Deprecated

Table represents ticket sales of customers

A dimension table to normalise customer event types

Deprecated: use dim_provider instead

Deprecated: use wager instead

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

Table represent wager cancellations

Table that represents migrated ticket sales.

Table represent the wager numbers and wager/purchase information of each ticket

For commercial lotteries. Table represents syndicate sessions that shares belong to

A dimension table to normalise commercial lottery providers

One row per update event on the node gift table. Receiver and deposit are only populated once the gift is sent successfully

A dimension table to normalise PBJ sales and supplier organisations

A dimension table to normalise deposit/withdraw transfer methods

Table represents the status history of each ticket sale

For commercial lotteries. Table represents ticket dividends

Deprecated

Table represents the status history of each recurring purchase

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

Table represents a dimension of the possible devices customer can use when accessing the site

A dimension table to normalise affiliate data

Deprecated: use ticket_sales instead

System table which identifies consistency and possible missing data across the metrics database transactional tables

Deprecated

For commercial lotteries. A dimension table to normalise prize divisions

Deprecated

A dimension table to normalise Autoplay/Subscription event types

A dimension table to normalise account transaction status data

For commercial lotteries. Table represents the status history of each syndicate share purchase

Table represents list of PBJ Administrators

Table represents the actions that a customer has taken on the website

Deprecated

Table represents the status history of each withdrawal

Table represents list of Autoplays/Subscriptions of customers

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

Deprecated: use wager instead

System table for PBJ platform. Table represents the release revision identifier

Table represents the recurring purchases events. Includes next anniversary dates and success/failures for every purchase attempt

Table represents transfers made by PBJ Administrators

For commercial lotteries. Table represents ticket prizes

Combines ticket sales data from migrated_ticket_sales (imported external tickets), and ticket_sales (current PBJ tickets)

View represents customers phone events