Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,401–8,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8401 | 3008401358326 | 4541 |
| 8402 | 3008402724752 | 4541 |
| 8403 | 3008403242651 | 4541 |
| 8404 | 3008404475497 | 4542 |
| 8405 | 3008405102806 | 4542 |
| 8406 | 3008406702067 | 4542 |
| 8407 | 3008407331184 | 4544 |
| 8408 | 3008408481449 | 4544 |
| 8409 | 3008409164201 | 4545 |
| 8410 | 3008410321358 | 4545 |
| 8411 | 3008411171486 | 4546 |
| 8412 | 3008412925835 | 4547 |
| 8413 | 3008413337440 | 4547 |
| 8414 | 3008414720584 | 4547 |
| 8415 | 3008415415286 | 4547 |
| 8416 | 3008416174711 | 4548 |
| 8417 | 3008417152605 | 4548 |
| 8418 | 3008418774810 | 4548 |
| 8419 | 3008419070516 | 4548 |
| 8420 | 3008420612873 | 4553 |
| 8421 | 3008421643923 | 4554 |
| 8422 | 3008422593913 | 4554 |
| 8423 | 3008423852753 | 4556 |
| 8424 | 3008424364791 | 4556 |
| 8425 | 3008425907384 | 4556 |
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;