Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,601–3,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3601 | 3003601566431 | 1981 |
| 3602 | 3003602157058 | 1981 |
| 3603 | 3003603077391 | 1982 |
| 3604 | 3003604457559 | 1982 |
| 3605 | 3003605977623 | 1983 |
| 3606 | 3003606492235 | 1983 |
| 3607 | 3003607847559 | 1985 |
| 3608 | 3003608184293 | 1985 |
| 3609 | 3003609309547 | 1986 |
| 3610 | 3003610329609 | 1988 |
| 3611 | 3003611736147 | 1988 |
| 3612 | 3003612627518 | 1989 |
| 3613 | 3003613190751 | 1989 |
| 3614 | 3003614080850 | 1989 |
| 3615 | 3003615238952 | 1992 |
| 3616 | 3003616452892 | 1992 |
| 3617 | 3003617765096 | 1992 |
| 3618 | 3003618703692 | 1993 |
| 3619 | 3003619059456 | 1996 |
| 3620 | 3003620648709 | 1996 |
| 3621 | 3003621804463 | 1996 |
| 3622 | 3003622725510 | 1996 |
| 3623 | 3003623902850 | 1996 |
| 3624 | 3003624910795 | 1998 |
| 3625 | 3003625040847 | 1998 |
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;