Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,176–8,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8176 | 3008176216947 | 4386 |
| 8177 | 3008177199137 | 4387 |
| 8178 | 3008178472770 | 4387 |
| 8179 | 3008179342828 | 4391 |
| 8180 | 3008180613398 | 4391 |
| 8181 | 3008181201582 | 4391 |
| 8182 | 3008182525604 | 4392 |
| 8183 | 3008183733301 | 4392 |
| 8184 | 3008184829939 | 4392 |
| 8185 | 3008185025461 | 4392 |
| 8186 | 3008186853951 | 4393 |
| 8187 | 3008187151405 | 4393 |
| 8188 | 3008188944152 | 4396 |
| 8189 | 3008189374603 | 4396 |
| 8190 | 3008190400690 | 4396 |
| 8191 | 3008191018600 | 4399 |
| 8192 | 3008192426645 | 4399 |
| 8193 | 3008193331060 | 4400 |
| 8194 | 3008194888147 | 4400 |
| 8195 | 3008195525105 | 4400 |
| 8196 | 3008196816271 | 4401 |
| 8197 | 3008197430922 | 4401 |
| 8198 | 3008198949222 | 4402 |
| 8199 | 3008199630879 | 4403 |
| 8200 | 3008200838608 | 4403 |
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;