Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,376–4,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4376 | 3004376419493 | 2442 |
| 4377 | 3004377067683 | 2442 |
| 4378 | 3004378492906 | 2444 |
| 4379 | 3004379288520 | 2446 |
| 4380 | 3004380428339 | 2446 |
| 4381 | 3004381736808 | 2448 |
| 4382 | 3004382798143 | 2450 |
| 4383 | 3004383197444 | 2450 |
| 4384 | 3004384190671 | 2451 |
| 4385 | 3004385455529 | 2452 |
| 4386 | 3004386543304 | 2453 |
| 4387 | 3004387563055 | 2453 |
| 4388 | 3004388331155 | 2453 |
| 4389 | 3004389776579 | 2453 |
| 4390 | 3004390454233 | 2455 |
| 4391 | 3004391169384 | 2456 |
| 4392 | 3004392899824 | 2456 |
| 4393 | 3004393049569 | 2459 |
| 4394 | 3004394208315 | 2460 |
| 4395 | 3004395980236 | 2460 |
| 4396 | 3004396087554 | 2461 |
| 4397 | 3004397903536 | 2461 |
| 4398 | 3004398575369 | 2461 |
| 4399 | 3004399883598 | 2461 |
| 4400 | 3004400154492 | 2462 |
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;