Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,601–2,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2601 | 3002601201097 | 1474 |
| 2602 | 3002602005072 | 1476 |
| 2603 | 3002603638213 | 1477 |
| 2604 | 3002604112266 | 1477 |
| 2605 | 3002605909762 | 1477 |
| 2606 | 3002606859830 | 1479 |
| 2607 | 3002607207633 | 1479 |
| 2608 | 3002608940987 | 1479 |
| 2609 | 3002609690880 | 1479 |
| 2610 | 3002610840262 | 1481 |
| 2611 | 3002611791135 | 1482 |
| 2612 | 3002612935692 | 1482 |
| 2613 | 3002613147457 | 1486 |
| 2614 | 3002614181756 | 1486 |
| 2615 | 3002615085587 | 1486 |
| 2616 | 3002616809419 | 1487 |
| 2617 | 3002617181442 | 1489 |
| 2618 | 3002618416255 | 1489 |
| 2619 | 3002619578211 | 1490 |
| 2620 | 3002620191410 | 1490 |
| 2621 | 3002621439988 | 1490 |
| 2622 | 3002622937136 | 1490 |
| 2623 | 3002623024757 | 1490 |
| 2624 | 3002624194065 | 1492 |
| 2625 | 3002625621027 | 1492 |
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;