Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,401–2,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2401 | 3002401625683 | 1329 |
| 2402 | 3002402116122 | 1329 |
| 2403 | 3002403375679 | 1329 |
| 2404 | 3002404422637 | 1329 |
| 2405 | 3002405187584 | 1331 |
| 2406 | 3002406980514 | 1332 |
| 2407 | 3002407018728 | 1336 |
| 2408 | 3002408614626 | 1336 |
| 2409 | 3002409043168 | 1337 |
| 2410 | 3002410773056 | 1338 |
| 2411 | 3002411521579 | 1339 |
| 2412 | 3002412313876 | 1339 |
| 2413 | 3002413726213 | 1339 |
| 2414 | 3002414504249 | 1339 |
| 2415 | 3002415116542 | 1340 |
| 2416 | 3002416689592 | 1340 |
| 2417 | 3002417860346 | 1340 |
| 2418 | 3002418817582 | 1340 |
| 2419 | 3002419302382 | 1340 |
| 2420 | 3002420987694 | 1345 |
| 2421 | 3002421489971 | 1345 |
| 2422 | 3002422838787 | 1345 |
| 2423 | 3002423933610 | 1346 |
| 2424 | 3002424033157 | 1348 |
| 2425 | 3002425317111 | 1350 |
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;