Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,476–2,500 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2476 | 3002476236412 | 1388 |
| 2477 | 3002477533893 | 1388 |
| 2478 | 3002478074055 | 1388 |
| 2479 | 3002479901666 | 1388 |
| 2480 | 3002480004210 | 1389 |
| 2481 | 3002481669606 | 1389 |
| 2482 | 3002482548629 | 1390 |
| 2483 | 3002483608013 | 1390 |
| 2484 | 3002484802045 | 1391 |
| 2485 | 3002485823273 | 1391 |
| 2486 | 3002486694625 | 1392 |
| 2487 | 3002487686075 | 1392 |
| 2488 | 3002488191236 | 1392 |
| 2489 | 3002489787969 | 1393 |
| 2490 | 3002490713398 | 1394 |
| 2491 | 3002491823442 | 1394 |
| 2492 | 3002492578271 | 1394 |
| 2493 | 3002493554378 | 1395 |
| 2494 | 3002494921501 | 1395 |
| 2495 | 3002495581848 | 1396 |
| 2496 | 3002496090292 | 1396 |
| 2497 | 3002497619767 | 1400 |
| 2498 | 3002498092319 | 1400 |
| 2499 | 3002499335897 | 1400 |
| 2500 | 3002500100364 | 1400 |
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;