Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,151–4,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4151 | 3004151325661 | 2307 |
| 4152 | 3004152010430 | 2307 |
| 4153 | 3004153870398 | 2307 |
| 4154 | 3004154566832 | 2308 |
| 4155 | 3004155449318 | 2308 |
| 4156 | 3004156070635 | 2308 |
| 4157 | 3004157327864 | 2308 |
| 4158 | 3004158314810 | 2309 |
| 4159 | 3004159669082 | 2309 |
| 4160 | 3004160190361 | 2311 |
| 4161 | 3004161807177 | 2311 |
| 4162 | 3004162574774 | 2311 |
| 4163 | 3004163380275 | 2311 |
| 4164 | 3004164830196 | 2313 |
| 4165 | 3004165664836 | 2314 |
| 4166 | 3004166010733 | 2314 |
| 4167 | 3004167537417 | 2316 |
| 4168 | 3004168764135 | 2317 |
| 4169 | 3004169526999 | 2318 |
| 4170 | 3004170668023 | 2318 |
| 4171 | 3004171144719 | 2319 |
| 4172 | 3004172522649 | 2321 |
| 4173 | 3004173962472 | 2321 |
| 4174 | 3004174180582 | 2322 |
| 4175 | 3004175698213 | 2324 |
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;