Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,476–5,500 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5476 | 3005476963772 | 3042 |
| 5477 | 3005477610465 | 3043 |
| 5478 | 3005478523152 | 3043 |
| 5479 | 3005479092518 | 3044 |
| 5480 | 3005480718811 | 3044 |
| 5481 | 3005481304563 | 3044 |
| 5482 | 3005482241483 | 3047 |
| 5483 | 3005483595840 | 3047 |
| 5484 | 3005484969144 | 3048 |
| 5485 | 3005485114369 | 3048 |
| 5486 | 3005486358745 | 3049 |
| 5487 | 3005487286417 | 3049 |
| 5488 | 3005488321814 | 3049 |
| 5489 | 3005489918956 | 3049 |
| 5490 | 3005490605839 | 3049 |
| 5491 | 3005491793615 | 3050 |
| 5492 | 3005492069952 | 3050 |
| 5493 | 3005493410028 | 3050 |
| 5494 | 3005494782870 | 3052 |
| 5495 | 3005495914540 | 3052 |
| 5496 | 3005496348857 | 3052 |
| 5497 | 3005497992956 | 3052 |
| 5498 | 3005498491978 | 3052 |
| 5499 | 3005499006236 | 3053 |
| 5500 | 3005500003902 | 3054 |
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;