Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,801–8,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8801 | 3008801729373 | 4802 |
| 8802 | 3008802176528 | 4802 |
| 8803 | 3008803075025 | 4802 |
| 8804 | 3008804087152 | 4802 |
| 8805 | 3008805887423 | 4803 |
| 8806 | 3008806622868 | 4803 |
| 8807 | 3008807571249 | 4803 |
| 8808 | 3008808010265 | 4804 |
| 8809 | 3008809697322 | 4804 |
| 8810 | 3008810435183 | 4805 |
| 8811 | 3008811388605 | 4805 |
| 8812 | 3008812212368 | 4805 |
| 8813 | 3008813097756 | 4805 |
| 8814 | 3008814082635 | 4805 |
| 8815 | 3008815361511 | 4806 |
| 8816 | 3008816540692 | 4806 |
| 8817 | 3008817189111 | 4807 |
| 8818 | 3008818305086 | 4807 |
| 8819 | 3008819474053 | 4807 |
| 8820 | 3008820704972 | 4808 |
| 8821 | 3008821962676 | 4808 |
| 8822 | 3008822883267 | 4810 |
| 8823 | 3008823866761 | 4810 |
| 8824 | 3008824619889 | 4812 |
| 8825 | 3008825779570 | 4812 |
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;