syndicate_session_sales

-1 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_syndicate_id int4 10 √ null
dim_syndicate.dim_syndicate_id syndicate_session_sales_dim_syndicate_id_fkey R

Ref: see table dim_syndicate
syndicate_session_id int4 10 null
syndicate_sales.syndicate_session_id syndicate_sales_syndicate_session_id_fkey R
syndicate_session_sales_history.syndicate_session_id syndicate_session_sales_history_syndicate_session_id_fkey R
syndicate_wager.syndicate_session_id Implied Constraint R

Primary key: an identifier for this syndicate session
dim_lottery_id int4 10 √ null
dim_lottery.dim_lottery_id syndicate_session_sales_dim_lottery_id_fkey R

Ref: see table dim_lottery

Indexes

Constraint Name Type Sort Column(s)
syndicate_session_sales_pkey Primary key Asc syndicate_session_id
idx_syndicate_session_sales_dim_lottery_id Performance Asc dim_lottery_id
idx_syndicate_session_sales_dim_syndicate_id Performance Asc dim_syndicate_id

Relationships

Close relationships within degrees of separation