wager_cancelled

-1 rows


Description

Table represent wager cancellations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
wager_id int8 19 null

Ref: one-to-one see table wager
wager_cancelled_on timestamptz 35,6 √ null

Date this wager was cancelled
wager_cost numeric 15,5 √ null

Cost of the wager
wager_commission numeric 15,5 √ null

How much commission was made on this wager
wager_slip_fee numeric 15,5 √ null

Deprecated: the ‘flagfall’ charged for the wager
entry_count int4 10 √ null

How many entries were purchased as part of this wager
dim_lottery_id int4 10 √ null
dim_lottery.dim_lottery_id wager_cancelled_dim_lottery_id_fkey R

Ref: see table dim_lottery
dim_provider_id int4 10 √ null
dim_provider.dim_provider_id wager_cancelled_dim_provider_id_fkey R

Ref: see table dim_provider
is_syndicate bool 1 √ null

Is this wager part of a syndicate purchase?
dim_pricing_id int4 10 null
dim_pricing.dim_pricing_id wager_cancelled_dim_pricing_id_fkey R

Ref: see table dim_pricing
dim_channel_id int4 10 √ null
dim_channel.dim_channel_id wager_cancelled_dim_channel_id_fkey R

Ref: see table dim_channel
is_vip bool 1 √ null
dim_affiliate_id int4 10 √ null
dim_affiliate.dim_affiliate_id wager_cancelled_dim_affiliate_id_fkey R

Ref: see table dim_affiliate
dim_recurring_purchase_type_id int4 10 √ null
dim_recurring_purchase_type.dim_recurring_purchase_type_id wager_cancelled_dim_recurring_purchase_type_id_fkey R

lookup on dimension table dim_recurring_purchase_type
ticket_id int4 10 √ null
ticket_sales.ticket_id wager_cancelled_ticket_id_fkey R
wager_serial text 2147483647 √ null

Serial number from provider
initial_dim_channel_id int4 10 √ null
dim_channel.dim_channel_id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
wager_cancelled_pkey Primary key Asc wager_id
idx_wager_cancelled_dim_affiliate_id Performance Asc dim_affiliate_id
idx_wager_cancelled_dim_channel_id Performance Asc dim_channel_id
idx_wager_cancelled_dim_pricing_id_tk Performance Asc dim_pricing_id
idx_wager_cancelled_dim_recurring_purchase_type_id Performance Asc dim_recurring_purchase_type_id
idx_wager_cancelled_initial_dim_channel_id Performance Asc initial_dim_channel_id
idx_wager_cancelled_is_vip Performance Asc is_vip
idx_wager_cancelled_lottery_id_tk Performance Asc dim_lottery_id
idx_wager_cancelled_provider_id_tk Performance Asc dim_provider_id
idx_wager_cancelled_ticket_id Performance Asc ticket_id
idx_wager_cancelled_wager_cancelled_on_tk Performance Asc wager_cancelled_on

Relationships

Close relationships within degrees of separation