Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,501–2,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2501 | 3002501641577 | 1400 |
| 2502 | 3002502423204 | 1401 |
| 2503 | 3002503175639 | 1401 |
| 2504 | 3002504913540 | 1402 |
| 2505 | 3002505463567 | 1402 |
| 2506 | 3002506774715 | 1402 |
| 2507 | 3002507484187 | 1402 |
| 2508 | 3002508511346 | 1402 |
| 2509 | 3002509356039 | 1406 |
| 2510 | 3002510315017 | 1406 |
| 2511 | 3002511593690 | 1408 |
| 2512 | 3002512066276 | 1408 |
| 2513 | 3002513746686 | 1408 |
| 2514 | 3002514619836 | 1408 |
| 2515 | 3002515469973 | 1408 |
| 2516 | 3002516102569 | 1409 |
| 2517 | 3002517538665 | 1409 |
| 2518 | 3002518316280 | 1409 |
| 2519 | 3002519264913 | 1414 |
| 2520 | 3002520288006 | 1415 |
| 2521 | 3002521317832 | 1415 |
| 2522 | 3002522799226 | 1417 |
| 2523 | 3002523527961 | 1418 |
| 2524 | 3002524105166 | 1418 |
| 2525 | 3002525732991 | 1418 |
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;