Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,776–2,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2776 | 3002776593412 | 1558 |
| 2777 | 3002777089843 | 1559 |
| 2778 | 3002778687123 | 1559 |
| 2779 | 3002779552067 | 1560 |
| 2780 | 3002780287934 | 1561 |
| 2781 | 3002781551464 | 1561 |
| 2782 | 3002782861629 | 1564 |
| 2783 | 3002783621656 | 1565 |
| 2784 | 3002784910347 | 1565 |
| 2785 | 3002785490862 | 1566 |
| 2786 | 3002786966166 | 1567 |
| 2787 | 3002787063709 | 1568 |
| 2788 | 3002788509195 | 1568 |
| 2789 | 3002789907410 | 1569 |
| 2790 | 3002790853891 | 1570 |
| 2791 | 3002791441748 | 1570 |
| 2792 | 3002792731257 | 1570 |
| 2793 | 3002793872664 | 1571 |
| 2794 | 3002794602960 | 1571 |
| 2795 | 3002795783883 | 1572 |
| 2796 | 3002796427738 | 1572 |
| 2797 | 3002797415754 | 1572 |
| 2798 | 3002798536141 | 1573 |
| 2799 | 3002799204182 | 1573 |
| 2800 | 3002800436852 | 1573 |
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;