Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,776–5,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5776 | 3005776784333 | 3215 |
| 5777 | 3005777759939 | 3215 |
| 5778 | 3005778411282 | 3215 |
| 5779 | 3005779414521 | 3216 |
| 5780 | 3005780317017 | 3216 |
| 5781 | 3005781906108 | 3216 |
| 5782 | 3005782550342 | 3216 |
| 5783 | 3005783604731 | 3218 |
| 5784 | 3005784700363 | 3218 |
| 5785 | 3005785972989 | 3220 |
| 5786 | 3005786009646 | 3220 |
| 5787 | 3005787756843 | 3224 |
| 5788 | 3005788367643 | 3225 |
| 5789 | 3005789682922 | 3225 |
| 5790 | 3005790455567 | 3225 |
| 5791 | 3005791979411 | 3225 |
| 5792 | 3005792101795 | 3228 |
| 5793 | 3005793245803 | 3229 |
| 5794 | 3005794442619 | 3229 |
| 5795 | 3005795779492 | 3230 |
| 5796 | 3005796392371 | 3230 |
| 5797 | 3005797443776 | 3236 |
| 5798 | 3005798741176 | 3236 |
| 5799 | 3005799957238 | 3238 |
| 5800 | 3005800418346 | 3238 |
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;