Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ticket_status_id | int2 | 5 | √ | null |
|
|
5: creating; 10: pending; 20: buying; 25: importing; 30: purchased; 40: paid; 50: cancelling; 60: cancelled; 70: failed |
||||
| ticket_id | int4 | 10 | √ | null |
|
|
Ticket to which this status applies |
||||
| ticket_status_history_timestamp | timestamptz | 35,6 | √ | null |
|
|
When the status was applied |
||||
| ticket_status_history_event_timestamp | timestamptz | 35,6 | √ | null |
|
|
When the event which caused the status happend |
||||
| dim_provider_id | int4 | 10 | √ | null |
|
|
Ref: see table dim_provider |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_ticket_status_history_dim_provider_id | Performance | Asc | dim_provider_id |
| idx_ticket_status_history_event_timestamp | Performance | Asc | ticket_status_history_event_timestamp |
| idx_ticket_status_history_ticket_id | Performance | Asc | ticket_id |
| idx_ticket_status_history_timestamp | Performance | Asc | ticket_status_history_timestamp |
| idx_ticket_status_id | Performance | Asc | ticket_status_id |
Relationships
Close relationships within degrees of separation
