Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,651–9,675 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9651 | 3009651879358 | 5264 |
| 9652 | 3009652993486 | 5265 |
| 9653 | 3009653871219 | 5266 |
| 9654 | 3009654843748 | 5267 |
| 9655 | 3009655347166 | 5267 |
| 9656 | 3009656318167 | 5268 |
| 9657 | 3009657474035 | 5268 |
| 9658 | 3009658615236 | 5269 |
| 9659 | 3009659049101 | 5273 |
| 9660 | 3009660272403 | 5273 |
| 9661 | 3009661631544 | 5273 |
| 9662 | 3009662915242 | 5274 |
| 9663 | 3009663008257 | 5274 |
| 9664 | 3009664657875 | 5275 |
| 9665 | 3009665444184 | 5275 |
| 9666 | 3009666256316 | 5276 |
| 9667 | 3009667952767 | 5276 |
| 9668 | 3009668605078 | 5276 |
| 9669 | 3009669319855 | 5278 |
| 9670 | 3009670883431 | 5278 |
| 9671 | 3009671662094 | 5278 |
| 9672 | 3009672871660 | 5278 |
| 9673 | 3009673439890 | 5279 |
| 9674 | 3009674326093 | 5279 |
| 9675 | 3009675013167 | 5280 |
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;