Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,351–2,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2351 | 3002351598471 | 1294 |
| 2352 | 3002352885766 | 1294 |
| 2353 | 3002353135926 | 1297 |
| 2354 | 3002354347575 | 1298 |
| 2355 | 3002355408593 | 1298 |
| 2356 | 3002356760753 | 1298 |
| 2357 | 3002357166697 | 1300 |
| 2358 | 3002358665463 | 1300 |
| 2359 | 3002359881789 | 1301 |
| 2360 | 3002360403028 | 1302 |
| 2361 | 3002361827796 | 1302 |
| 2362 | 3002362642222 | 1302 |
| 2363 | 3002363511196 | 1303 |
| 2364 | 3002364191546 | 1304 |
| 2365 | 3002365194913 | 1304 |
| 2366 | 3002366674500 | 1305 |
| 2367 | 3002367218676 | 1305 |
| 2368 | 3002368002334 | 1306 |
| 2369 | 3002369978102 | 1306 |
| 2370 | 3002370447183 | 1306 |
| 2371 | 3002371120555 | 1307 |
| 2372 | 3002372066864 | 1308 |
| 2373 | 3002373915556 | 1310 |
| 2374 | 3002374511220 | 1310 |
| 2375 | 3002375344868 | 1311 |
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;