Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,926–5,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5926 | 3005926083651 | 3296 |
| 5927 | 3005927723772 | 3296 |
| 5928 | 3005928243500 | 3296 |
| 5929 | 3005929675801 | 3296 |
| 5930 | 3005930381039 | 3296 |
| 5931 | 3005931126888 | 3296 |
| 5932 | 3005932159070 | 3296 |
| 5933 | 3005933530076 | 3296 |
| 5934 | 3005934618076 | 3296 |
| 5935 | 3005935916324 | 3296 |
| 5936 | 3005936608368 | 3296 |
| 5937 | 3005937881892 | 3297 |
| 5938 | 3005938306368 | 3297 |
| 5939 | 3005939834834 | 3299 |
| 5940 | 3005940614337 | 3301 |
| 5941 | 3005941444940 | 3301 |
| 5942 | 3005942158386 | 3302 |
| 5943 | 3005943398557 | 3302 |
| 5944 | 3005944790861 | 3302 |
| 5945 | 3005945510161 | 3302 |
| 5946 | 3005946639074 | 3304 |
| 5947 | 3005947589359 | 3304 |
| 5948 | 3005948563251 | 3304 |
| 5949 | 3005949269321 | 3304 |
| 5950 | 3005950892336 | 3305 |
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;