Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,976–8,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7976 | 3007976241369 | 4265 |
| 7977 | 3007977860667 | 4265 |
| 7978 | 3007978708531 | 4270 |
| 7979 | 3007979182080 | 4271 |
| 7980 | 3007980520023 | 4272 |
| 7981 | 3007981182253 | 4272 |
| 7982 | 3007982558313 | 4272 |
| 7983 | 3007983518133 | 4274 |
| 7984 | 3007984018741 | 4274 |
| 7985 | 3007985289772 | 4274 |
| 7986 | 3007986520846 | 4275 |
| 7987 | 3007987408308 | 4275 |
| 7988 | 3007988374643 | 4277 |
| 7989 | 3007989188224 | 4278 |
| 7990 | 3007990341975 | 4280 |
| 7991 | 3007991287573 | 4280 |
| 7992 | 3007992919685 | 4285 |
| 7993 | 3007993657686 | 4285 |
| 7994 | 3007994613267 | 4286 |
| 7995 | 3007995254321 | 4287 |
| 7996 | 3007996945806 | 4287 |
| 7997 | 3007997061143 | 4289 |
| 7998 | 3007998927900 | 4289 |
| 7999 | 3007999093020 | 4289 |
| 8000 | 3008000675563 | 4289 |
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;