Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,001–3,025 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3001 | 3003001683706 | 1693 |
| 3002 | 3003002935000 | 1693 |
| 3003 | 3003003310831 | 1694 |
| 3004 | 3003004365051 | 1694 |
| 3005 | 3003005786086 | 1696 |
| 3006 | 3003006228713 | 1696 |
| 3007 | 3003007887672 | 1696 |
| 3008 | 3003008482081 | 1696 |
| 3009 | 3003009275725 | 1697 |
| 3010 | 3003010954281 | 1697 |
| 3011 | 3003011168028 | 1699 |
| 3012 | 3003012101904 | 1702 |
| 3013 | 3003013115034 | 1703 |
| 3014 | 3003014612254 | 1703 |
| 3015 | 3003015145137 | 1704 |
| 3016 | 3003016190115 | 1704 |
| 3017 | 3003017619157 | 1705 |
| 3018 | 3003018346210 | 1705 |
| 3019 | 3003019821042 | 1706 |
| 3020 | 3003020449523 | 1707 |
| 3021 | 3003021428677 | 1707 |
| 3022 | 3003022380790 | 1707 |
| 3023 | 3003023089294 | 1709 |
| 3024 | 3003024577563 | 1709 |
| 3025 | 3003025398726 | 1711 |
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;