Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 1,376–1,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 1376 | 3001376374439 | 768 |
| 1377 | 3001377862378 | 768 |
| 1378 | 3001378635970 | 768 |
| 1379 | 3001379837207 | 768 |
| 1380 | 3001380099405 | 768 |
| 1381 | 3001381164167 | 768 |
| 1382 | 3001382888935 | 768 |
| 1383 | 3001383423101 | 768 |
| 1384 | 3001384455104 | 768 |
| 1385 | 3001385136192 | 768 |
| 1386 | 3001386563111 | 768 |
| 1387 | 3001387416967 | 768 |
| 1388 | 3001388013582 | 768 |
| 1389 | 3001389050801 | 768 |
| 1390 | 3001390700931 | 768 |
| 1391 | 3001391052315 | 768 |
| 1392 | 3001392078626 | 768 |
| 1393 | 3001393554438 | 768 |
| 1394 | 3001394453364 | 768 |
| 1395 | 3001395136724 | 768 |
| 1396 | 3001396197551 | 768 |
| 1397 | 3001397881150 | 768 |
| 1398 | 3001398321244 | 768 |
| 1399 | 3001399742740 | 768 |
| 1400 | 3001400716433 | 768 |
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;