Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,276–6,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6276 | 3006276272319 | 3462 |
| 6277 | 3006277291294 | 3464 |
| 6278 | 3006278785392 | 3466 |
| 6279 | 3006279391849 | 3466 |
| 6280 | 3006280283254 | 3467 |
| 6281 | 3006281004000 | 3467 |
| 6282 | 3006282084711 | 3468 |
| 6283 | 3006283157811 | 3468 |
| 6284 | 3006284658480 | 3469 |
| 6285 | 3006285183713 | 3469 |
| 6286 | 3006286581083 | 3471 |
| 6287 | 3006287769431 | 3471 |
| 6288 | 3006288684999 | 3471 |
| 6289 | 3006289038218 | 3471 |
| 6290 | 3006290210270 | 3471 |
| 6291 | 3006291038545 | 3473 |
| 6292 | 3006292187614 | 3473 |
| 6293 | 3006293177381 | 3473 |
| 6294 | 3006294348281 | 3474 |
| 6295 | 3006295554938 | 3474 |
| 6296 | 3006296234049 | 3475 |
| 6297 | 3006297591184 | 3475 |
| 6298 | 3006298208254 | 3476 |
| 6299 | 3006299626839 | 3477 |
| 6300 | 3006300955808 | 3478 |
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;