Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,026–2,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2026 | 3002026898933 | 1115 |
| 2027 | 3002027732699 | 1115 |
| 2028 | 3002028092770 | 1116 |
| 2029 | 3002029460759 | 1117 |
| 2030 | 3002030084151 | 1118 |
| 2031 | 3002031065216 | 1119 |
| 2032 | 3002032262779 | 1119 |
| 2033 | 3002033326359 | 1119 |
| 2034 | 3002034457014 | 1119 |
| 2035 | 3002035361296 | 1120 |
| 2036 | 3002036409954 | 1120 |
| 2037 | 3002037319749 | 1120 |
| 2038 | 3002038209328 | 1120 |
| 2039 | 3002039689944 | 1121 |
| 2040 | 3002040219265 | 1121 |
| 2041 | 3002041773550 | 1122 |
| 2042 | 3002042196546 | 1122 |
| 2043 | 3002043848738 | 1124 |
| 2044 | 3002044162893 | 1124 |
| 2045 | 3002045495958 | 1124 |
| 2046 | 3002046785226 | 1124 |
| 2047 | 3002047587265 | 1126 |
| 2048 | 3002048947976 | 1127 |
| 2049 | 3002049217898 | 1127 |
| 2050 | 3002050283383 | 1128 |
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;