Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,726–9,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9726 | 3009726390154 | 5316 |
| 9727 | 3009727567485 | 5316 |
| 9728 | 3009728258005 | 5316 |
| 9729 | 3009729707084 | 5316 |
| 9730 | 3009730416350 | 5316 |
| 9731 | 3009731307994 | 5317 |
| 9732 | 3009732871013 | 5318 |
| 9733 | 3009733432888 | 5318 |
| 9734 | 3009734900799 | 5319 |
| 9735 | 3009735417183 | 5319 |
| 9736 | 3009736469683 | 5320 |
| 9737 | 3009737844815 | 5322 |
| 9738 | 3009738793395 | 5322 |
| 9739 | 3009739472818 | 5322 |
| 9740 | 3009740576394 | 5325 |
| 9741 | 3009741403623 | 5326 |
| 9742 | 3009742394790 | 5327 |
| 9743 | 3009743587126 | 5327 |
| 9744 | 3009744630007 | 5327 |
| 9745 | 3009745371856 | 5328 |
| 9746 | 3009746554764 | 5332 |
| 9747 | 3009747485533 | 5332 |
| 9748 | 3009748475434 | 5332 |
| 9749 | 3009749089656 | 5332 |
| 9750 | 3009750364160 | 5333 |
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;