Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,951–4,975 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4951 | 3004951164680 | 2766 |
| 4952 | 3004952689720 | 2767 |
| 4953 | 3004953285064 | 2767 |
| 4954 | 3004954601657 | 2767 |
| 4955 | 3004955070291 | 2767 |
| 4956 | 3004956819017 | 2768 |
| 4957 | 3004957978408 | 2768 |
| 4958 | 3004958843891 | 2768 |
| 4959 | 3004959431645 | 2768 |
| 4960 | 3004960324298 | 2768 |
| 4961 | 3004961181223 | 2769 |
| 4962 | 3004962951931 | 2769 |
| 4963 | 3004963233129 | 2771 |
| 4964 | 3004964431273 | 2771 |
| 4965 | 3004965529016 | 2771 |
| 4966 | 3004966309185 | 2771 |
| 4967 | 3004967642583 | 2773 |
| 4968 | 3004968253828 | 2773 |
| 4969 | 3004969610971 | 2773 |
| 4970 | 3004970702368 | 2774 |
| 4971 | 3004971390316 | 2775 |
| 4972 | 3004972155043 | 2776 |
| 4973 | 3004973590042 | 2776 |
| 4974 | 3004974229649 | 2778 |
| 4975 | 3004975288186 | 2778 |
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;