syndicate_sales

-1 rows


Description

For commercial lotteries. Table represents customer syndicate share purchases

Columns

Column Type Size Nulls Auto Default Children Parents Comments
checkout_id int4 10 √ null

Deprecated
syndicate_share_id int4 10 null
syndicate_dividend.customer_id syndicate_dividend_syndicate_share_id_fkey R
syndicate_dividend.syndicate_share_id Implied Constraint R
syndicate_share_status_history.syndicate_share_id syndicate_share_status_history_syndicate_share_id_fkey R

Primary key: an identifier for this record
lottery_names text 2147483647 √ null

Lotteries this sale applies to
game_offer_names text 2147483647 √ null

Name of the game offers which apply to this lottery
is_autoplay bool 1 √ null

Was this purchase an autoplay?
syndicate_share_count int4 10 √ null

How many shares are in this purchase
sales numeric 17,2 √ null

Cost of this purchase
syndicate_session_id int4 10 √ null
syndicate_session_sales.syndicate_session_id syndicate_sales_syndicate_session_id_fkey R

Ref: syndicate_session_sales
dim_pricing_id int4 10 null
dim_pricing.dim_pricing_id syndicate_sales_dim_pricing_id_fkey R

Ref: see table dim_pricing
checkout_encoded_id text 2147483647 √ null

External reference to the checkout in which this purchase was made

Indexes

Constraint Name Type Sort Column(s)
syndicate_sales_pkey Primary key Asc syndicate_share_id
idx_syndicate_sales_checkout_id_tk Performance Asc checkout_id
idx_syndicate_sales_dim_lottery_names_tk Performance Asc lottery_names
idx_syndicate_sales_dim_pricing_id_tk Performance Asc dim_pricing_id
idx_syndicate_sales_is_autoplay_tk Performance Asc is_autoplay
idx_syndicate_sales_syndicate_session_id_tk Performance Asc syndicate_session_id

Relationships

Close relationships within degrees of separation