Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,626–8,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8626 | 3008626907651 | 4676 |
| 8627 | 3008627180309 | 4676 |
| 8628 | 3008628789973 | 4676 |
| 8629 | 3008629272021 | 4676 |
| 8630 | 3008630337351 | 4676 |
| 8631 | 3008631803681 | 4678 |
| 8632 | 3008632667959 | 4679 |
| 8633 | 3008633518142 | 4680 |
| 8634 | 3008634254307 | 4680 |
| 8635 | 3008635762286 | 4681 |
| 8636 | 3008636714347 | 4683 |
| 8637 | 3008637582476 | 4684 |
| 8638 | 3008638420423 | 4684 |
| 8639 | 3008639939124 | 4684 |
| 8640 | 3008640492312 | 4687 |
| 8641 | 3008641342877 | 4688 |
| 8642 | 3008642529410 | 4688 |
| 8643 | 3008643052516 | 4688 |
| 8644 | 3008644256612 | 4688 |
| 8645 | 3008645043846 | 4691 |
| 8646 | 3008646419271 | 4691 |
| 8647 | 3008647154594 | 4691 |
| 8648 | 3008648963447 | 4692 |
| 8649 | 3008649511147 | 4692 |
| 8650 | 3008650708495 | 4693 |
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;