Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,201–8,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8201 | 3008201114719 | 4404 |
| 8202 | 3008202733504 | 4404 |
| 8203 | 3008203101803 | 4406 |
| 8204 | 3008204633828 | 4406 |
| 8205 | 3008205104974 | 4408 |
| 8206 | 3008206618969 | 4408 |
| 8207 | 3008207393339 | 4410 |
| 8208 | 3008208210299 | 4411 |
| 8209 | 3008209399958 | 4411 |
| 8210 | 3008210820774 | 4411 |
| 8211 | 3008211858214 | 4413 |
| 8212 | 3008212026193 | 4413 |
| 8213 | 3008213939864 | 4414 |
| 8214 | 3008214203355 | 4414 |
| 8215 | 3008215474765 | 4414 |
| 8216 | 3008216652712 | 4415 |
| 8217 | 3008217933797 | 4415 |
| 8218 | 3008218831968 | 4416 |
| 8219 | 3008219796724 | 4416 |
| 8220 | 3008220043147 | 4416 |
| 8221 | 3008221786376 | 4418 |
| 8222 | 3008222318819 | 4418 |
| 8223 | 3008223919190 | 4419 |
| 8224 | 3008224488992 | 4419 |
| 8225 | 3008225105661 | 4419 |
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;