Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,851–8,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8851 | 3008851634221 | 4828 |
| 8852 | 3008852834414 | 4830 |
| 8853 | 3008853461503 | 4830 |
| 8854 | 3008854770577 | 4831 |
| 8855 | 3008855023503 | 4831 |
| 8856 | 3008856425566 | 4832 |
| 8857 | 3008857362818 | 4832 |
| 8858 | 3008858370210 | 4832 |
| 8859 | 3008859478401 | 4835 |
| 8860 | 3008860111121 | 4835 |
| 8861 | 3008861071038 | 4835 |
| 8862 | 3008862530768 | 4835 |
| 8863 | 3008863251541 | 4835 |
| 8864 | 3008864551194 | 4836 |
| 8865 | 3008865538411 | 4836 |
| 8866 | 3008866437011 | 4837 |
| 8867 | 3008867493797 | 4837 |
| 8868 | 3008868429860 | 4840 |
| 8869 | 3008869438105 | 4841 |
| 8870 | 3008870906849 | 4842 |
| 8871 | 3008871033125 | 4843 |
| 8872 | 3008872546112 | 4843 |
| 8873 | 3008873446870 | 4844 |
| 8874 | 3008874939941 | 4844 |
| 8875 | 3008875611628 | 4845 |
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;