Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| dim_provider_id | int4 | 10 | √ | null |
|
|
Dimension lookup for provider name |
||||
| street_price | numeric | 15,5 | √ | null |
|
|
Total street price from wagers. |
||||
| syndicate_session_event_timestamp | timestamptz | 35,6 | √ | null |
|
|
When this occurred in JL. |
||||
| syndicate_session_id | int4 | 10 | √ | null |
|
|
From JL and for joining to syndicate_session_sales. |
||||
| syndicate_session_sales_history_timestamp | timestamptz | 35,6 | √ | now() |
|
|
This row was created. |
||||
| syndicate_session_status_id | int2 | 5 | √ | null |
|
|
From JL, for filtering. |
||||
| retail_price | numeric | 15,5 | √ | null |
|
|
AKA sales in other sales tables. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_syndicate_session_sales_history_dim_provider_id | Performance | Asc | dim_provider_id |
| idx_syndicate_session_sales_history_event_timestamp | Performance | Asc | syndicate_session_sales_history_timestamp |
| idx_syndicate_session_sales_history_syndicate_session_sales_id | Performance | Asc | syndicate_session_id |
| idx_syndicate_session_sales_history_syndicate_session_status_id | Performance | Asc | syndicate_session_status_id |
| idx_syndicate_session_sales_history_timestamp | Performance | Asc | syndicate_session_event_timestamp |
Relationships
Close relationships within degrees of separation
