Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,576–7,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7576 | 3007576145094 | 4080 |
| 7577 | 3007577058138 | 4080 |
| 7578 | 3007578241283 | 4081 |
| 7579 | 3007579468815 | 4082 |
| 7580 | 3007580796909 | 4082 |
| 7581 | 3007581822427 | 4084 |
| 7582 | 3007582826839 | 4084 |
| 7583 | 3007583030731 | 4084 |
| 7584 | 3007584980047 | 4084 |
| 7585 | 3007585921884 | 4084 |
| 7586 | 3007586592589 | 4087 |
| 7587 | 3007587298087 | 4088 |
| 7588 | 3007588807244 | 4089 |
| 7589 | 3007589890555 | 4090 |
| 7590 | 3007590795078 | 4090 |
| 7591 | 3007591565058 | 4090 |
| 7592 | 3007592025872 | 4091 |
| 7593 | 3007593496887 | 4091 |
| 7594 | 3007594504966 | 4093 |
| 7595 | 3007595169182 | 4093 |
| 7596 | 3007596553983 | 4094 |
| 7597 | 3007597629826 | 4094 |
| 7598 | 3007598499730 | 4095 |
| 7599 | 3007599355189 | 4095 |
| 7600 | 3007600053393 | 4097 |
Table definition
CREATE TABLE ticket (
ticket_id INTEGER PRIMARY KEY,
barcode TEXT NOT NULL UNIQUE CHECK (length(barcode) = 13 AND barcode NOT GLOB '*[^0-9]*'),
order_id INTEGER NOT NULL REFERENCES purchase_order (order_id)
) STRICT;