Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| recurring_purchase_id | int4 | 10 | null |
|
|
Recurring purchase this status applies to |
|||||
| recurring_purchase_status_id | int2 | 5 | null |
|
|
10: recurring_status_active; 20: recurring_status_paused; 30: recurring_status_cancelled; |
|||||
| recurring_purchase_status_history_timestamp | timestamptz | 35,6 | null |
|
|
When this status was applied |
|||||
| recurring_purchase_status_history_event_timestamp | timestamptz | 35,6 | null |
|
|
When the event which caused this status was applied |
|||||
| dim_lottery_id | int4 | 10 | √ | null |
|
|
|||||
| equivalent_standard_games_count | int4 | 10 | √ | null |
|
|
|||||
| number_of_games | int4 | 10 | √ | null |
|
|
|||||
| game_offer_name | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_dim_lottery_id_tk | Performance | Asc | dim_lottery_id |
| idx_recurring_purchase_recurring_purchase_status_id | Performance | Asc | recurring_purchase_status_id |
| idx_recurring_purchase_status_history_event_timestamp | Performance | Asc | recurring_purchase_status_history_event_timestamp |
| idx_recurring_purchase_status_history_recurring_purchase_id | Performance | Asc | recurring_purchase_id |
| idx_recurring_purchase_status_history_timestamp | Performance | Asc | recurring_purchase_status_history_timestamp |
Relationships
Close relationships within degrees of separation
