dim_lottery

-1 rows


Description

A dimension table to normalise lotteries

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_lottery_id int4 10 null
account_transaction.dim_lottery_id account_transaction_dim_lottery_id_fkey R
customer_communication_preference.dim_lottery_id customer_communication_preference_dim_lottery_id_fkey R
dim_draw.dim_lottery_id Implied Constraint R
prize.dim_lottery_id Implied Constraint R
recurring_purchase_status_history.dim_lottery_id Implied Constraint R
sales.dim_lottery_id Implied Constraint R
syndicate_dividend.dim_lottery_id syndicate_dividend_dim_lottery_id_fkey R
syndicate_session_sales.dim_lottery_id syndicate_session_sales_dim_lottery_id_fkey R
ticket_dividend.dim_lottery_id ticket_dividend_dim_lottery_id_fkey R
wager.dim_lottery_id wager_dim_lottery_id_fkey R
wager_cancelled.dim_lottery_id wager_cancelled_dim_lottery_id_fkey R

An identifier for this dimension
version int4 10 √ null

Version of this dimension as it applies to dim_lottery_id
date_from timestamp 29,6 √ null

When this dimension applies from
date_to timestamp 29,6 √ null

When this dimension applies to
lottery_names text 2147483647 √ null

An array of lottery names
lottery_type_name text 2147483647 √ null

Kind of lottery this is (e.g. Raffle)
game_offer_name text 2147483647 √ null

Name of the game offer which applies to this lottery

Indexes

Constraint Name Type Sort Column(s)
dim_lottery_pkey Primary key Asc dim_lottery_id
idx_dim_lottery_lookup Performance Asc/Asc/Asc lottery_names + lottery_type_name + game_offer_name
idx_dim_lottery_tk Performance Asc dim_lottery_id

Relationships

Close relationships within degrees of separation