Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,926–8,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8926 | 3008926759826 | 4862 |
| 8927 | 3008927752749 | 4862 |
| 8928 | 3008928296516 | 4862 |
| 8929 | 3008929042524 | 4862 |
| 8930 | 3008930510345 | 4862 |
| 8931 | 3008931571560 | 4862 |
| 8932 | 3008932820172 | 4862 |
| 8933 | 3008933286258 | 4862 |
| 8934 | 3008934653960 | 4862 |
| 8935 | 3008935544770 | 4862 |
| 8936 | 3008936025679 | 4862 |
| 8937 | 3008937200697 | 4862 |
| 8938 | 3008938869868 | 4862 |
| 8939 | 3008939385823 | 4862 |
| 8940 | 3008940975562 | 4862 |
| 8941 | 3008941932752 | 4862 |
| 8942 | 3008942166776 | 4862 |
| 8943 | 3008943889857 | 4862 |
| 8944 | 3008944560336 | 4862 |
| 8945 | 3008945444402 | 4862 |
| 8946 | 3008946959899 | 4862 |
| 8947 | 3008947374977 | 4862 |
| 8948 | 3008948006016 | 4863 |
| 8949 | 3008949230803 | 4864 |
| 8950 | 3008950011711 | 4865 |
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;