Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,501–4,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4501 | 3004501071056 | 2500 |
| 4502 | 3004502152673 | 2500 |
| 4503 | 3004503689928 | 2501 |
| 4504 | 3004504435670 | 2502 |
| 4505 | 3004505725276 | 2502 |
| 4506 | 3004506461726 | 2502 |
| 4507 | 3004507310159 | 2503 |
| 4508 | 3004508110113 | 2503 |
| 4509 | 3004509499892 | 2503 |
| 4510 | 3004510009704 | 2503 |
| 4511 | 3004511639555 | 2503 |
| 4512 | 3004512232256 | 2504 |
| 4513 | 3004513336021 | 2504 |
| 4514 | 3004514795626 | 2504 |
| 4515 | 3004515389034 | 2505 |
| 4516 | 3004516418301 | 2505 |
| 4517 | 3004517192475 | 2505 |
| 4518 | 3004518016735 | 2505 |
| 4519 | 3004519708906 | 2505 |
| 4520 | 3004520863999 | 2506 |
| 4521 | 3004521677225 | 2510 |
| 4522 | 3004522798737 | 2510 |
| 4523 | 3004523140278 | 2511 |
| 4524 | 3004524217259 | 2514 |
| 4525 | 3004525312309 | 2515 |
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;