Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,251–6,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6251 | 3006251035957 | 3447 |
| 6252 | 3006252172965 | 3447 |
| 6253 | 3006253221853 | 3450 |
| 6254 | 3006254294994 | 3450 |
| 6255 | 3006255465578 | 3450 |
| 6256 | 3006256887321 | 3450 |
| 6257 | 3006257502087 | 3451 |
| 6258 | 3006258435224 | 3451 |
| 6259 | 3006259024036 | 3452 |
| 6260 | 3006260443046 | 3453 |
| 6261 | 3006261379676 | 3453 |
| 6262 | 3006262455676 | 3455 |
| 6263 | 3006263374079 | 3456 |
| 6264 | 3006264086912 | 3456 |
| 6265 | 3006265651662 | 3456 |
| 6266 | 3006266558889 | 3457 |
| 6267 | 3006267793360 | 3457 |
| 6268 | 3006268452737 | 3458 |
| 6269 | 3006269568035 | 3458 |
| 6270 | 3006270510616 | 3459 |
| 6271 | 3006271152976 | 3460 |
| 6272 | 3006272145396 | 3460 |
| 6273 | 3006273434282 | 3461 |
| 6274 | 3006274351990 | 3461 |
| 6275 | 3006275355354 | 3462 |
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;