Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,351–9,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9351 | 3009351858875 | 5026 |
| 9352 | 3009352648723 | 5026 |
| 9353 | 3009353824308 | 5028 |
| 9354 | 3009354178586 | 5028 |
| 9355 | 3009355958873 | 5028 |
| 9356 | 3009356724762 | 5028 |
| 9357 | 3009357328913 | 5029 |
| 9358 | 3009358002137 | 5029 |
| 9359 | 3009359823247 | 5030 |
| 9360 | 3009360336399 | 5030 |
| 9361 | 3009361199976 | 5030 |
| 9362 | 3009362805385 | 5033 |
| 9363 | 3009363502689 | 5034 |
| 9364 | 3009364434582 | 5034 |
| 9365 | 3009365140142 | 5034 |
| 9366 | 3009366660122 | 5036 |
| 9367 | 3009367607386 | 5036 |
| 9368 | 3009368048407 | 5037 |
| 9369 | 3009369829411 | 5037 |
| 9370 | 3009370603931 | 5038 |
| 9371 | 3009371523994 | 5040 |
| 9372 | 3009372264293 | 5040 |
| 9373 | 3009373555709 | 5041 |
| 9374 | 3009374814286 | 5041 |
| 9375 | 3009375682453 | 5042 |
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;