Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,976–4,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3976 | 3003976193384 | 2193 |
| 3977 | 3003977732242 | 2194 |
| 3978 | 3003978167778 | 2199 |
| 3979 | 3003979577624 | 2199 |
| 3980 | 3003980192590 | 2200 |
| 3981 | 3003981350892 | 2201 |
| 3982 | 3003982414779 | 2201 |
| 3983 | 3003983339020 | 2202 |
| 3984 | 3003984234082 | 2202 |
| 3985 | 3003985425841 | 2204 |
| 3986 | 3003986576497 | 2206 |
| 3987 | 3003987808740 | 2206 |
| 3988 | 3003988393446 | 2209 |
| 3989 | 3003989845709 | 2209 |
| 3990 | 3003990189392 | 2209 |
| 3991 | 3003991157046 | 2210 |
| 3992 | 3003992397849 | 2212 |
| 3993 | 3003993602815 | 2212 |
| 3994 | 3003994155188 | 2215 |
| 3995 | 3003995985234 | 2215 |
| 3996 | 3003996259157 | 2215 |
| 3997 | 3003997868915 | 2215 |
| 3998 | 3003998489332 | 2215 |
| 3999 | 3003999981276 | 2216 |
| 4000 | 3004000884098 | 2218 |
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;