Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,201–5,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5201 | 3005201197128 | 2847 |
| 5202 | 3005202690223 | 2847 |
| 5203 | 3005203851426 | 2847 |
| 5204 | 3005204641171 | 2853 |
| 5205 | 3005205399568 | 2855 |
| 5206 | 3005206083937 | 2855 |
| 5207 | 3005207106425 | 2855 |
| 5208 | 3005208648958 | 2857 |
| 5209 | 3005209007845 | 2857 |
| 5210 | 3005210070879 | 2857 |
| 5211 | 3005211762433 | 2857 |
| 5212 | 3005212131215 | 2858 |
| 5213 | 3005213726294 | 2858 |
| 5214 | 3005214959376 | 2861 |
| 5215 | 3005215202353 | 2861 |
| 5216 | 3005216216202 | 2864 |
| 5217 | 3005217669393 | 2865 |
| 5218 | 3005218514938 | 2866 |
| 5219 | 3005219941838 | 2866 |
| 5220 | 3005220301940 | 2867 |
| 5221 | 3005221845087 | 2867 |
| 5222 | 3005222673247 | 2869 |
| 5223 | 3005223334671 | 2869 |
| 5224 | 3005224523582 | 2869 |
| 5225 | 3005225902963 | 2869 |
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;