Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,576–5,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5576 | 3005576335366 | 3115 |
| 5577 | 3005577154416 | 3115 |
| 5578 | 3005578180911 | 3118 |
| 5579 | 3005579977023 | 3118 |
| 5580 | 3005580491374 | 3118 |
| 5581 | 3005581071105 | 3118 |
| 5582 | 3005582152970 | 3120 |
| 5583 | 3005583313842 | 3121 |
| 5584 | 3005584002496 | 3123 |
| 5585 | 3005585240232 | 3124 |
| 5586 | 3005586385262 | 3124 |
| 5587 | 3005587315055 | 3126 |
| 5588 | 3005588311399 | 3127 |
| 5589 | 3005589626116 | 3127 |
| 5590 | 3005590666744 | 3128 |
| 5591 | 3005591265676 | 3128 |
| 5592 | 3005592315880 | 3128 |
| 5593 | 3005593772803 | 3128 |
| 5594 | 3005594948227 | 3128 |
| 5595 | 3005595663973 | 3128 |
| 5596 | 3005596735201 | 3128 |
| 5597 | 3005597490159 | 3128 |
| 5598 | 3005598542288 | 3128 |
| 5599 | 3005599241327 | 3128 |
| 5600 | 3005600147701 | 3128 |
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;