Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,451–4,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4451 | 3004451832180 | 2478 |
| 4452 | 3004452000478 | 2478 |
| 4453 | 3004453147864 | 2478 |
| 4454 | 3004454039845 | 2478 |
| 4455 | 3004455919240 | 2478 |
| 4456 | 3004456786205 | 2478 |
| 4457 | 3004457359635 | 2478 |
| 4458 | 3004458973621 | 2478 |
| 4459 | 3004459432889 | 2478 |
| 4460 | 3004460240270 | 2478 |
| 4461 | 3004461537805 | 2478 |
| 4462 | 3004462722187 | 2478 |
| 4463 | 3004463375195 | 2478 |
| 4464 | 3004464582409 | 2478 |
| 4465 | 3004465149080 | 2480 |
| 4466 | 3004466041831 | 2480 |
| 4467 | 3004467837206 | 2481 |
| 4468 | 3004468407952 | 2481 |
| 4469 | 3004469430384 | 2482 |
| 4470 | 3004470599547 | 2483 |
| 4471 | 3004471489074 | 2484 |
| 4472 | 3004472750272 | 2484 |
| 4473 | 3004473099614 | 2484 |
| 4474 | 3004474640434 | 2484 |
| 4475 | 3004475986692 | 2484 |
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;