Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,426–2,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2426 | 3002426373532 | 1350 |
| 2427 | 3002427776744 | 1350 |
| 2428 | 3002428276012 | 1350 |
| 2429 | 3002429236093 | 1351 |
| 2430 | 3002430706228 | 1351 |
| 2431 | 3002431360443 | 1351 |
| 2432 | 3002432653169 | 1353 |
| 2433 | 3002433697127 | 1353 |
| 2434 | 3002434292851 | 1353 |
| 2435 | 3002435542836 | 1353 |
| 2436 | 3002436097772 | 1355 |
| 2437 | 3002437409385 | 1355 |
| 2438 | 3002438836436 | 1355 |
| 2439 | 3002439909545 | 1356 |
| 2440 | 3002440429256 | 1356 |
| 2441 | 3002441916087 | 1357 |
| 2442 | 3002442106500 | 1357 |
| 2443 | 3002443643823 | 1359 |
| 2444 | 3002444415177 | 1359 |
| 2445 | 3002445698485 | 1361 |
| 2446 | 3002446799974 | 1362 |
| 2447 | 3002447630320 | 1363 |
| 2448 | 3002448702171 | 1364 |
| 2449 | 3002449951780 | 1366 |
| 2450 | 3002450502111 | 1367 |
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;