Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,151–6,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6151 | 3006151859598 | 3386 |
| 6152 | 3006152415166 | 3386 |
| 6153 | 3006153701697 | 3386 |
| 6154 | 3006154692978 | 3386 |
| 6155 | 3006155003073 | 3386 |
| 6156 | 3006156816751 | 3386 |
| 6157 | 3006157353643 | 3386 |
| 6158 | 3006158460961 | 3386 |
| 6159 | 3006159967608 | 3386 |
| 6160 | 3006160156936 | 3386 |
| 6161 | 3006161905835 | 3386 |
| 6162 | 3006162099841 | 3386 |
| 6163 | 3006163275399 | 3386 |
| 6164 | 3006164211355 | 3386 |
| 6165 | 3006165481533 | 3386 |
| 6166 | 3006166019020 | 3389 |
| 6167 | 3006167495248 | 3389 |
| 6168 | 3006168316505 | 3390 |
| 6169 | 3006169425876 | 3390 |
| 6170 | 3006170112158 | 3391 |
| 6171 | 3006171242746 | 3393 |
| 6172 | 3006172530188 | 3394 |
| 6173 | 3006173646487 | 3394 |
| 6174 | 3006174772668 | 3397 |
| 6175 | 3006175479238 | 3397 |
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;