syndicate_dividend

-1 rows


Description

For commercial lotteries. Table represents syndicate dividends

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id int4 10 √ null
syndicate_sales.syndicate_share_id syndicate_dividend_syndicate_share_id_fkey R
customer.customer_id syndicate_dividend_customer_id_fkey R

Ref: many-to-one to table customer
syndicate_share_id int4 10 √ null
syndicate_sales.syndicate_share_id Implied Constraint R

Primary Key: an identifier for this record
syndicate_share_count int4 10 √ null

How many shares apply to this dividend
draw_no int4 10 √ null

Draw number this dividend applies to (see also dim_draw)
dim_lottery_id int4 10 √ null
dim_lottery.dim_lottery_id syndicate_dividend_dim_lottery_id_fkey R

Ref: see table dim_lottery
dim_entry_offer_id int8 19 √ null
dim_entry_offer.dim_entry_offer_id syndicate_dividend_dim_entry_offer_id_fkey R

Ref: see table dim_entry_offer
share_prize numeric 14,2 √ null

Value of this dividend
dim_date_id int4 10 √ null
dim_date.dim_date_id syndicate_dividend_dim_date_id_fkey R

Used for date indexing, applied to the date this dividend was created
account_transaction_id int8 19 √ null
account_transaction.account_transaction_id syndicate_dividend_account_transaction_id_fkey R

Ref: the payout transaction in account_transaction

Indexes

Constraint Name Type Sort Column(s)
idx_syndicate_dividend_account_transaction_id Performance Asc account_transaction_id
idx_syndicate_dividend_customer_id Performance Asc customer_id
idx_syndicate_dividend_dim_date_id Performance Asc dim_date_id
idx_syndicate_dividend_dim_entry_offer_id Performance Asc dim_entry_offer_id
idx_syndicate_dividend_dim_lottery_id Performance Asc dim_lottery_id
idx_syndicate_dividend_draw_no Performance Asc draw_no

Relationships

Close relationships within degrees of separation