Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,351–8,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8351 | 3008351838724 | 4515 |
| 8352 | 3008352038326 | 4515 |
| 8353 | 3008353965724 | 4516 |
| 8354 | 3008354284428 | 4516 |
| 8355 | 3008355319765 | 4517 |
| 8356 | 3008356572666 | 4517 |
| 8357 | 3008357539410 | 4517 |
| 8358 | 3008358046203 | 4518 |
| 8359 | 3008359771386 | 4518 |
| 8360 | 3008360428332 | 4520 |
| 8361 | 3008361406503 | 4520 |
| 8362 | 3008362681242 | 4521 |
| 8363 | 3008363413822 | 4521 |
| 8364 | 3008364506410 | 4521 |
| 8365 | 3008365969020 | 4522 |
| 8366 | 3008366753380 | 4522 |
| 8367 | 3008367056535 | 4523 |
| 8368 | 3008368919378 | 4523 |
| 8369 | 3008369725917 | 4524 |
| 8370 | 3008370415819 | 4524 |
| 8371 | 3008371105931 | 4524 |
| 8372 | 3008372933195 | 4524 |
| 8373 | 3008373360488 | 4524 |
| 8374 | 3008374884204 | 4526 |
| 8375 | 3008375495177 | 4526 |
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;