Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,401–4,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4401 | 3004401633304 | 2464 |
| 4402 | 3004402624949 | 2464 |
| 4403 | 3004403094583 | 2466 |
| 4404 | 3004404237087 | 2466 |
| 4405 | 3004405738466 | 2466 |
| 4406 | 3004406091998 | 2466 |
| 4407 | 3004407129810 | 2468 |
| 4408 | 3004408748894 | 2469 |
| 4409 | 3004409645985 | 2470 |
| 4410 | 3004410512671 | 2470 |
| 4411 | 3004411334096 | 2472 |
| 4412 | 3004412483915 | 2472 |
| 4413 | 3004413255791 | 2473 |
| 4414 | 3004414859034 | 2473 |
| 4415 | 3004415545138 | 2474 |
| 4416 | 3004416553938 | 2474 |
| 4417 | 3004417165819 | 2475 |
| 4418 | 3004418229979 | 2475 |
| 4419 | 3004419901816 | 2476 |
| 4420 | 3004420273234 | 2476 |
| 4421 | 3004421793471 | 2477 |
| 4422 | 3004422823493 | 2478 |
| 4423 | 3004423715462 | 2478 |
| 4424 | 3004424002599 | 2478 |
| 4425 | 3004425603212 | 2478 |
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;