Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,901–4,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4901 | 3004901437406 | 2724 |
| 4902 | 3004902462928 | 2726 |
| 4903 | 3004903027219 | 2726 |
| 4904 | 3004904356304 | 2726 |
| 4905 | 3004905030071 | 2726 |
| 4906 | 3004906357441 | 2727 |
| 4907 | 3004907108667 | 2729 |
| 4908 | 3004908655240 | 2729 |
| 4909 | 3004909008334 | 2729 |
| 4910 | 3004910947433 | 2729 |
| 4911 | 3004911554487 | 2732 |
| 4912 | 3004912915749 | 2733 |
| 4913 | 3004913822150 | 2733 |
| 4914 | 3004914400487 | 2734 |
| 4915 | 3004915680061 | 2734 |
| 4916 | 3004916603462 | 2736 |
| 4917 | 3004917584677 | 2736 |
| 4918 | 3004918629454 | 2736 |
| 4919 | 3004919749780 | 2738 |
| 4920 | 3004920442891 | 2738 |
| 4921 | 3004921191282 | 2741 |
| 4922 | 3004922514745 | 2741 |
| 4923 | 3004923618310 | 2741 |
| 4924 | 3004924582085 | 2742 |
| 4925 | 3004925491993 | 2747 |
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;