Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,226–8,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8226 | 3008226137584 | 4420 |
| 8227 | 3008227298134 | 4420 |
| 8228 | 3008228443815 | 4421 |
| 8229 | 3008229529754 | 4421 |
| 8230 | 3008230044522 | 4421 |
| 8231 | 3008231326697 | 4422 |
| 8232 | 3008232649941 | 4422 |
| 8233 | 3008233203771 | 4424 |
| 8234 | 3008234980441 | 4424 |
| 8235 | 3008235225323 | 4424 |
| 8236 | 3008236536123 | 4425 |
| 8237 | 3008237940308 | 4425 |
| 8238 | 3008238461679 | 4426 |
| 8239 | 3008239510736 | 4426 |
| 8240 | 3008240180713 | 4427 |
| 8241 | 3008241306450 | 4427 |
| 8242 | 3008242424822 | 4428 |
| 8243 | 3008243941977 | 4428 |
| 8244 | 3008244781380 | 4429 |
| 8245 | 3008245348560 | 4430 |
| 8246 | 3008246834129 | 4430 |
| 8247 | 3008247644489 | 4430 |
| 8248 | 3008248401878 | 4430 |
| 8249 | 3008249115708 | 4431 |
| 8250 | 3008250630978 | 4431 |
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;