Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,426–3,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3426 | 3003426664242 | 1876 |
| 3427 | 3003427481023 | 1876 |
| 3428 | 3003428915762 | 1876 |
| 3429 | 3003429929573 | 1876 |
| 3430 | 3003430417057 | 1876 |
| 3431 | 3003431684961 | 1876 |
| 3432 | 3003432665545 | 1876 |
| 3433 | 3003433123552 | 1876 |
| 3434 | 3003434505447 | 1876 |
| 3435 | 3003435455752 | 1876 |
| 3436 | 3003436220459 | 1876 |
| 3437 | 3003437912519 | 1876 |
| 3438 | 3003438903936 | 1876 |
| 3439 | 3003439228289 | 1876 |
| 3440 | 3003440348881 | 1876 |
| 3441 | 3003441819460 | 1876 |
| 3442 | 3003442508528 | 1876 |
| 3443 | 3003443566406 | 1876 |
| 3444 | 3003444008090 | 1876 |
| 3445 | 3003445626805 | 1876 |
| 3446 | 3003446866100 | 1876 |
| 3447 | 3003447662961 | 1876 |
| 3448 | 3003448027651 | 1876 |
| 3449 | 3003449871268 | 1876 |
| 3450 | 3003450217655 | 1876 |
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;