syndicate_share_status_history

-1 rows


Description

For commercial lotteries. Table represents the status history of each syndicate share purchase

Columns

Column Type Size Nulls Auto Default Children Parents Comments
syndicate_share_status_id int2 5 √ null

0: limbo; 5: creating; 10: pending; 20: buying; 30: purchased; 40: paid; 50: cancelling;60: cancelled; 70: failed
syndicate_share_id int4 10 √ null
syndicate_sales.syndicate_share_id syndicate_share_status_history_syndicate_share_id_fkey R

Ref: many-to-one to syndicate_sales
syndicate_share_status_history_timestamp timestamptz 35,6 √ null

When this status was applied

Indexes

Constraint Name Type Sort Column(s)
idx_syndicate_share_status_history_timestamp Performance Asc syndicate_share_status_history_timestamp
idx_syndicate_share_status_id Performance Asc syndicate_share_status_id

Relationships

Close relationships within degrees of separation