Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,276–8,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8276 | 3008276969846 | 4453 |
| 8277 | 3008277257811 | 4454 |
| 8278 | 3008278053401 | 4455 |
| 8279 | 3008279544297 | 4455 |
| 8280 | 3008280765903 | 4457 |
| 8281 | 3008281769917 | 4457 |
| 8282 | 3008282548556 | 4458 |
| 8283 | 3008283546392 | 4459 |
| 8284 | 3008284464175 | 4461 |
| 8285 | 3008285604552 | 4461 |
| 8286 | 3008286623777 | 4462 |
| 8287 | 3008287364438 | 4462 |
| 8288 | 3008288352542 | 4462 |
| 8289 | 3008289712439 | 4464 |
| 8290 | 3008290558508 | 4464 |
| 8291 | 3008291896415 | 4464 |
| 8292 | 3008292117853 | 4465 |
| 8293 | 3008293883133 | 4465 |
| 8294 | 3008294731954 | 4465 |
| 8295 | 3008295626804 | 4466 |
| 8296 | 3008296891434 | 4466 |
| 8297 | 3008297159817 | 4470 |
| 8298 | 3008298733324 | 4471 |
| 8299 | 3008299700351 | 4472 |
| 8300 | 3008300395517 | 4473 |
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;