Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,701–4,725 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4701 | 3004701049073 | 2596 |
| 4702 | 3004702181779 | 2596 |
| 4703 | 3004703197285 | 2596 |
| 4704 | 3004704333590 | 2596 |
| 4705 | 3004705868772 | 2596 |
| 4706 | 3004706154190 | 2596 |
| 4707 | 3004707286491 | 2596 |
| 4708 | 3004708283598 | 2596 |
| 4709 | 3004709269053 | 2596 |
| 4710 | 3004710500768 | 2596 |
| 4711 | 3004711002208 | 2596 |
| 4712 | 3004712754948 | 2596 |
| 4713 | 3004713791600 | 2596 |
| 4714 | 3004714506906 | 2596 |
| 4715 | 3004715301469 | 2596 |
| 4716 | 3004716226737 | 2596 |
| 4717 | 3004717803546 | 2596 |
| 4718 | 3004718829287 | 2596 |
| 4719 | 3004719572868 | 2596 |
| 4720 | 3004720389997 | 2596 |
| 4721 | 3004721012467 | 2596 |
| 4722 | 3004722745061 | 2596 |
| 4723 | 3004723724967 | 2596 |
| 4724 | 3004724286536 | 2596 |
| 4725 | 3004725283353 | 2596 |
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;