Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,501–8,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8501 | 3008501263294 | 4597 |
| 8502 | 3008502162985 | 4599 |
| 8503 | 3008503023955 | 4600 |
| 8504 | 3008504177402 | 4601 |
| 8505 | 3008505247822 | 4602 |
| 8506 | 3008506845184 | 4604 |
| 8507 | 3008507268993 | 4605 |
| 8508 | 3008508115515 | 4607 |
| 8509 | 3008509083172 | 4608 |
| 8510 | 3008510367337 | 4611 |
| 8511 | 3008511315129 | 4611 |
| 8512 | 3008512186447 | 4612 |
| 8513 | 3008513265504 | 4613 |
| 8514 | 3008514374446 | 4613 |
| 8515 | 3008515044547 | 4614 |
| 8516 | 3008516472059 | 4614 |
| 8517 | 3008517919842 | 4615 |
| 8518 | 3008518392835 | 4617 |
| 8519 | 3008519557263 | 4617 |
| 8520 | 3008520170044 | 4619 |
| 8521 | 3008521636326 | 4619 |
| 8522 | 3008522466283 | 4619 |
| 8523 | 3008523280036 | 4621 |
| 8524 | 3008524289391 | 4621 |
| 8525 | 3008525947435 | 4621 |
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;