Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,001–7,025 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7001 | 3007001065073 | 3829 |
| 7002 | 3007002609705 | 3829 |
| 7003 | 3007003573440 | 3830 |
| 7004 | 3007004172745 | 3832 |
| 7005 | 3007005489131 | 3835 |
| 7006 | 3007006361502 | 3835 |
| 7007 | 3007007108104 | 3837 |
| 7008 | 3007008313184 | 3837 |
| 7009 | 3007009360473 | 3837 |
| 7010 | 3007010659745 | 3837 |
| 7011 | 3007011849039 | 3838 |
| 7012 | 3007012757763 | 3838 |
| 7013 | 3007013199532 | 3838 |
| 7014 | 3007014481625 | 3840 |
| 7015 | 3007015452321 | 3840 |
| 7016 | 3007016850639 | 3840 |
| 7017 | 3007017459621 | 3841 |
| 7018 | 3007018654679 | 3842 |
| 7019 | 3007019909931 | 3843 |
| 7020 | 3007020174297 | 3843 |
| 7021 | 3007021963939 | 3843 |
| 7022 | 3007022675563 | 3846 |
| 7023 | 3007023852478 | 3846 |
| 7024 | 3007024764354 | 3848 |
| 7025 | 3007025257024 | 3848 |
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;