Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,926–7,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7926 | 3007926946649 | 4259 |
| 7927 | 3007927914180 | 4259 |
| 7928 | 3007928315179 | 4259 |
| 7929 | 3007929753536 | 4259 |
| 7930 | 3007930888720 | 4262 |
| 7931 | 3007931574318 | 4262 |
| 7932 | 3007932541822 | 4263 |
| 7933 | 3007933558096 | 4263 |
| 7934 | 3007934152685 | 4263 |
| 7935 | 3007935598376 | 4263 |
| 7936 | 3007936920861 | 4263 |
| 7937 | 3007937555192 | 4263 |
| 7938 | 3007938097054 | 4263 |
| 7939 | 3007939643972 | 4263 |
| 7940 | 3007940516624 | 4263 |
| 7941 | 3007941699871 | 4263 |
| 7942 | 3007942830388 | 4263 |
| 7943 | 3007943609693 | 4263 |
| 7944 | 3007944520202 | 4263 |
| 7945 | 3007945723872 | 4263 |
| 7946 | 3007946057034 | 4263 |
| 7947 | 3007947257474 | 4263 |
| 7948 | 3007948052774 | 4263 |
| 7949 | 3007949412494 | 4263 |
| 7950 | 3007950132783 | 4263 |
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;