Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,376–9,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9376 | 3009376967375 | 5042 |
| 9377 | 3009377683481 | 5043 |
| 9378 | 3009378262727 | 5044 |
| 9379 | 3009379860357 | 5045 |
| 9380 | 3009380123041 | 5045 |
| 9381 | 3009381037299 | 5048 |
| 9382 | 3009382859797 | 5049 |
| 9383 | 3009383311586 | 5050 |
| 9384 | 3009384793604 | 5051 |
| 9385 | 3009385887469 | 5053 |
| 9386 | 3009386153698 | 5053 |
| 9387 | 3009387208282 | 5053 |
| 9388 | 3009388710597 | 5054 |
| 9389 | 3009389886948 | 5054 |
| 9390 | 3009390937289 | 5054 |
| 9391 | 3009391257797 | 5054 |
| 9392 | 3009392152297 | 5054 |
| 9393 | 3009393813207 | 5058 |
| 9394 | 3009394758483 | 5058 |
| 9395 | 3009395469849 | 5059 |
| 9396 | 3009396504725 | 5060 |
| 9397 | 3009397591395 | 5061 |
| 9398 | 3009398228743 | 5061 |
| 9399 | 3009399553670 | 5062 |
| 9400 | 3009400222415 | 5062 |
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;