Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,201–6,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6201 | 3006201240935 | 3417 |
| 6202 | 3006202342689 | 3418 |
| 6203 | 3006203299680 | 3419 |
| 6204 | 3006204162684 | 3419 |
| 6205 | 3006205901174 | 3419 |
| 6206 | 3006206211541 | 3419 |
| 6207 | 3006207629770 | 3420 |
| 6208 | 3006208234235 | 3421 |
| 6209 | 3006209234806 | 3421 |
| 6210 | 3006210325161 | 3421 |
| 6211 | 3006211227575 | 3421 |
| 6212 | 3006212808249 | 3421 |
| 6213 | 3006213661747 | 3424 |
| 6214 | 3006214440661 | 3427 |
| 6215 | 3006215721785 | 3428 |
| 6216 | 3006216794227 | 3429 |
| 6217 | 3006217187015 | 3429 |
| 6218 | 3006218943510 | 3429 |
| 6219 | 3006219891763 | 3430 |
| 6220 | 3006220327999 | 3430 |
| 6221 | 3006221963835 | 3431 |
| 6222 | 3006222881781 | 3431 |
| 6223 | 3006223800973 | 3434 |
| 6224 | 3006224170445 | 3435 |
| 6225 | 3006225774249 | 3436 |
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;