Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,001–5,025 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5001 | 3005001884843 | 2786 |
| 5002 | 3005002277106 | 2786 |
| 5003 | 3005003991175 | 2786 |
| 5004 | 3005004625795 | 2786 |
| 5005 | 3005005364089 | 2786 |
| 5006 | 3005006447640 | 2786 |
| 5007 | 3005007852735 | 2786 |
| 5008 | 3005008997517 | 2786 |
| 5009 | 3005009566610 | 2786 |
| 5010 | 3005010786160 | 2786 |
| 5011 | 3005011046691 | 2786 |
| 5012 | 3005012829550 | 2786 |
| 5013 | 3005013852346 | 2786 |
| 5014 | 3005014589472 | 2786 |
| 5015 | 3005015155378 | 2786 |
| 5016 | 3005016067052 | 2786 |
| 5017 | 3005017731800 | 2786 |
| 5018 | 3005018014156 | 2786 |
| 5019 | 3005019573203 | 2786 |
| 5020 | 3005020574691 | 2786 |
| 5021 | 3005021590934 | 2786 |
| 5022 | 3005022913369 | 2786 |
| 5023 | 3005023998388 | 2786 |
| 5024 | 3005024078901 | 2786 |
| 5025 | 3005025598095 | 2786 |
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;