Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,001–6,025 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6001 | 3006001333635 | 3312 |
| 6002 | 3006002768289 | 3312 |
| 6003 | 3006003868328 | 3312 |
| 6004 | 3006004065453 | 3312 |
| 6005 | 3006005161346 | 3312 |
| 6006 | 3006006223019 | 3312 |
| 6007 | 3006007116073 | 3312 |
| 6008 | 3006008207666 | 3312 |
| 6009 | 3006009495353 | 3312 |
| 6010 | 3006010621487 | 3312 |
| 6011 | 3006011512044 | 3312 |
| 6012 | 3006012028237 | 3312 |
| 6013 | 3006013128647 | 3312 |
| 6014 | 3006014927520 | 3312 |
| 6015 | 3006015857121 | 3316 |
| 6016 | 3006016886733 | 3317 |
| 6017 | 3006017880009 | 3317 |
| 6018 | 3006018177957 | 3318 |
| 6019 | 3006019583225 | 3318 |
| 6020 | 3006020926879 | 3318 |
| 6021 | 3006021315229 | 3319 |
| 6022 | 3006022309176 | 3321 |
| 6023 | 3006023259915 | 3322 |
| 6024 | 3006024024453 | 3322 |
| 6025 | 3006025904353 | 3323 |
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;