Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,001–9,025 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9001 | 3009001423017 | 4873 |
| 9002 | 3009002661093 | 4873 |
| 9003 | 3009003554090 | 4873 |
| 9004 | 3009004473977 | 4873 |
| 9005 | 3009005212936 | 4873 |
| 9006 | 3009006604040 | 4873 |
| 9007 | 3009007028178 | 4873 |
| 9008 | 3009008578005 | 4873 |
| 9009 | 3009009814996 | 4877 |
| 9010 | 3009010940517 | 4877 |
| 9011 | 3009011572353 | 4878 |
| 9012 | 3009012981373 | 4883 |
| 9013 | 3009013074466 | 4883 |
| 9014 | 3009014414369 | 4885 |
| 9015 | 3009015943220 | 4885 |
| 9016 | 3009016673613 | 4885 |
| 9017 | 3009017642984 | 4885 |
| 9018 | 3009018040268 | 4885 |
| 9019 | 3009019871899 | 4886 |
| 9020 | 3009020477586 | 4886 |
| 9021 | 3009021833061 | 4886 |
| 9022 | 3009022599403 | 4886 |
| 9023 | 3009023116194 | 4887 |
| 9024 | 3009024732824 | 4887 |
| 9025 | 3009025250795 | 4887 |
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;