Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,976–6,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5976 | 3005976567605 | 3312 |
| 5977 | 3005977105199 | 3312 |
| 5978 | 3005978852610 | 3312 |
| 5979 | 3005979344654 | 3312 |
| 5980 | 3005980618379 | 3312 |
| 5981 | 3005981423124 | 3312 |
| 5982 | 3005982170701 | 3312 |
| 5983 | 3005983164095 | 3312 |
| 5984 | 3005984830295 | 3312 |
| 5985 | 3005985173540 | 3312 |
| 5986 | 3005986713908 | 3312 |
| 5987 | 3005987399353 | 3312 |
| 5988 | 3005988139356 | 3312 |
| 5989 | 3005989893750 | 3312 |
| 5990 | 3005990523836 | 3312 |
| 5991 | 3005991158513 | 3312 |
| 5992 | 3005992077413 | 3312 |
| 5993 | 3005993948773 | 3312 |
| 5994 | 3005994175885 | 3312 |
| 5995 | 3005995124818 | 3312 |
| 5996 | 3005996490149 | 3312 |
| 5997 | 3005997251644 | 3312 |
| 5998 | 3005998036281 | 3312 |
| 5999 | 3005999828094 | 3312 |
| 6000 | 3006000205962 | 3312 |
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;