Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,526–5,550 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5526 | 3005526472183 | 3083 |
| 5527 | 3005527230735 | 3085 |
| 5528 | 3005528273669 | 3085 |
| 5529 | 3005529768811 | 3085 |
| 5530 | 3005530443388 | 3085 |
| 5531 | 3005531066564 | 3085 |
| 5532 | 3005532211407 | 3086 |
| 5533 | 3005533963717 | 3087 |
| 5534 | 3005534620360 | 3087 |
| 5535 | 3005535304283 | 3087 |
| 5536 | 3005536495244 | 3091 |
| 5537 | 3005537638779 | 3091 |
| 5538 | 3005538350302 | 3091 |
| 5539 | 3005539551130 | 3093 |
| 5540 | 3005540639739 | 3094 |
| 5541 | 3005541885249 | 3094 |
| 5542 | 3005542827969 | 3094 |
| 5543 | 3005543672000 | 3094 |
| 5544 | 3005544634425 | 3095 |
| 5545 | 3005545621558 | 3096 |
| 5546 | 3005546971288 | 3096 |
| 5547 | 3005547628625 | 3096 |
| 5548 | 3005548266061 | 3096 |
| 5549 | 3005549345259 | 3097 |
| 5550 | 3005550446385 | 3097 |
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;