Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,576–8,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8576 | 3008576686534 | 4659 |
| 8577 | 3008577669901 | 4659 |
| 8578 | 3008578856937 | 4659 |
| 8579 | 3008579564054 | 4659 |
| 8580 | 3008580136977 | 4661 |
| 8581 | 3008581252436 | 4661 |
| 8582 | 3008582815165 | 4663 |
| 8583 | 3008583092648 | 4664 |
| 8584 | 3008584848133 | 4664 |
| 8585 | 3008585007061 | 4666 |
| 8586 | 3008586908947 | 4667 |
| 8587 | 3008587729526 | 4667 |
| 8588 | 3008588904953 | 4669 |
| 8589 | 3008589178579 | 4669 |
| 8590 | 3008590399210 | 4671 |
| 8591 | 3008591862696 | 4671 |
| 8592 | 3008592588488 | 4671 |
| 8593 | 3008593598022 | 4671 |
| 8594 | 3008594884086 | 4672 |
| 8595 | 3008595116520 | 4673 |
| 8596 | 3008596319124 | 4673 |
| 8597 | 3008597807741 | 4674 |
| 8598 | 3008598656502 | 4675 |
| 8599 | 3008599018862 | 4676 |
| 8600 | 3008600773233 | 4676 |
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;