Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,576–2,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2576 | 3002576939344 | 1450 |
| 2577 | 3002577408102 | 1450 |
| 2578 | 3002578638822 | 1450 |
| 2579 | 3002579797707 | 1451 |
| 2580 | 3002580340441 | 1451 |
| 2581 | 3002581800533 | 1460 |
| 2582 | 3002582878586 | 1460 |
| 2583 | 3002583680972 | 1461 |
| 2584 | 3002584277698 | 1462 |
| 2585 | 3002585992607 | 1462 |
| 2586 | 3002586105182 | 1462 |
| 2587 | 3002587523292 | 1463 |
| 2588 | 3002588104077 | 1463 |
| 2589 | 3002589319205 | 1468 |
| 2590 | 3002590640624 | 1468 |
| 2591 | 3002591476285 | 1468 |
| 2592 | 3002592080708 | 1469 |
| 2593 | 3002593452879 | 1469 |
| 2594 | 3002594598031 | 1470 |
| 2595 | 3002595851342 | 1470 |
| 2596 | 3002596367173 | 1471 |
| 2597 | 3002597277300 | 1471 |
| 2598 | 3002598482930 | 1474 |
| 2599 | 3002599902775 | 1474 |
| 2600 | 3002600324641 | 1474 |
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;