Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,426–8,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8426 | 3008426263651 | 4556 |
| 8427 | 3008427948262 | 4562 |
| 8428 | 3008428101580 | 4562 |
| 8429 | 3008429596008 | 4563 |
| 8430 | 3008430738438 | 4564 |
| 8431 | 3008431101635 | 4564 |
| 8432 | 3008432564319 | 4564 |
| 8433 | 3008433340036 | 4565 |
| 8434 | 3008434316814 | 4565 |
| 8435 | 3008435143066 | 4566 |
| 8436 | 3008436993624 | 4568 |
| 8437 | 3008437950122 | 4568 |
| 8438 | 3008438028277 | 4569 |
| 8439 | 3008439972711 | 4569 |
| 8440 | 3008440806688 | 4569 |
| 8441 | 3008441933487 | 4569 |
| 8442 | 3008442004753 | 4570 |
| 8443 | 3008443150502 | 4570 |
| 8444 | 3008444563185 | 4573 |
| 8445 | 3008445553327 | 4573 |
| 8446 | 3008446908097 | 4573 |
| 8447 | 3008447784536 | 4573 |
| 8448 | 3008448034324 | 4574 |
| 8449 | 3008449847100 | 4574 |
| 8450 | 3008450103211 | 4574 |
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;