Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,301–8,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8301 | 3008301553489 | 4474 |
| 8302 | 3008302271561 | 4475 |
| 8303 | 3008303630913 | 4475 |
| 8304 | 3008304165857 | 4476 |
| 8305 | 3008305592866 | 4476 |
| 8306 | 3008306499664 | 4477 |
| 8307 | 3008307994277 | 4477 |
| 8308 | 3008308426735 | 4478 |
| 8309 | 3008309165550 | 4478 |
| 8310 | 3008310855150 | 4480 |
| 8311 | 3008311320299 | 4480 |
| 8312 | 3008312897646 | 4481 |
| 8313 | 3008313861918 | 4482 |
| 8314 | 3008314963083 | 4482 |
| 8315 | 3008315901872 | 4483 |
| 8316 | 3008316002663 | 4483 |
| 8317 | 3008317226229 | 4484 |
| 8318 | 3008318925478 | 4484 |
| 8319 | 3008319872388 | 4485 |
| 8320 | 3008320211405 | 4488 |
| 8321 | 3008321117104 | 4488 |
| 8322 | 3008322226572 | 4489 |
| 8323 | 3008323089915 | 4489 |
| 8324 | 3008324494854 | 4492 |
| 8325 | 3008325303297 | 4493 |
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;