Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,726–3,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3726 | 3003726644069 | 2043 |
| 3727 | 3003727131566 | 2044 |
| 3728 | 3003728359923 | 2045 |
| 3729 | 3003729875613 | 2045 |
| 3730 | 3003730539367 | 2046 |
| 3731 | 3003731820656 | 2048 |
| 3732 | 3003732904471 | 2048 |
| 3733 | 3003733353753 | 2049 |
| 3734 | 3003734885278 | 2049 |
| 3735 | 3003735501372 | 2051 |
| 3736 | 3003736049953 | 2051 |
| 3737 | 3003737821216 | 2053 |
| 3738 | 3003738999940 | 2053 |
| 3739 | 3003739140684 | 2053 |
| 3740 | 3003740935956 | 2053 |
| 3741 | 3003741827811 | 2054 |
| 3742 | 3003742828952 | 2056 |
| 3743 | 3003743849497 | 2056 |
| 3744 | 3003744445131 | 2056 |
| 3745 | 3003745706253 | 2056 |
| 3746 | 3003746324538 | 2056 |
| 3747 | 3003747221604 | 2057 |
| 3748 | 3003748761064 | 2058 |
| 3749 | 3003749979220 | 2058 |
| 3750 | 3003750102201 | 2058 |
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;