Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,826–4,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4826 | 3004826830318 | 2659 |
| 4827 | 3004827594851 | 2660 |
| 4828 | 3004828254374 | 2661 |
| 4829 | 3004829695154 | 2661 |
| 4830 | 3004830486956 | 2661 |
| 4831 | 3004831052971 | 2661 |
| 4832 | 3004832681706 | 2662 |
| 4833 | 3004833393304 | 2662 |
| 4834 | 3004834687374 | 2662 |
| 4835 | 3004835892711 | 2663 |
| 4836 | 3004836856780 | 2663 |
| 4837 | 3004837424691 | 2671 |
| 4838 | 3004838575210 | 2671 |
| 4839 | 3004839253009 | 2672 |
| 4840 | 3004840871207 | 2672 |
| 4841 | 3004841843017 | 2675 |
| 4842 | 3004842997120 | 2676 |
| 4843 | 3004843699290 | 2676 |
| 4844 | 3004844147111 | 2677 |
| 4845 | 3004845459766 | 2677 |
| 4846 | 3004846063081 | 2679 |
| 4847 | 3004847799712 | 2680 |
| 4848 | 3004848966477 | 2681 |
| 4849 | 3004849322839 | 2682 |
| 4850 | 3004850491550 | 2682 |
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;