Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,026–3,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3026 | 3003026656441 | 1711 |
| 3027 | 3003027133346 | 1711 |
| 3028 | 3003028519620 | 1713 |
| 3029 | 3003029361615 | 1713 |
| 3030 | 3003030432528 | 1713 |
| 3031 | 3003031583827 | 1714 |
| 3032 | 3003032158501 | 1714 |
| 3033 | 3003033140727 | 1714 |
| 3034 | 3003034610066 | 1714 |
| 3035 | 3003035827267 | 1715 |
| 3036 | 3003036940176 | 1715 |
| 3037 | 3003037424694 | 1717 |
| 3038 | 3003038487526 | 1717 |
| 3039 | 3003039000357 | 1718 |
| 3040 | 3003040358180 | 1719 |
| 3041 | 3003041254950 | 1719 |
| 3042 | 3003042792460 | 1720 |
| 3043 | 3003043306834 | 1722 |
| 3044 | 3003044706036 | 1722 |
| 3045 | 3003045654436 | 1722 |
| 3046 | 3003046302927 | 1722 |
| 3047 | 3003047889372 | 1725 |
| 3048 | 3003048789891 | 1728 |
| 3049 | 3003049778972 | 1729 |
| 3050 | 3003050929541 | 1729 |
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;