Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,876–4,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4876 | 3004876774464 | 2701 |
| 4877 | 3004877938551 | 2702 |
| 4878 | 3004878357435 | 2702 |
| 4879 | 3004879584257 | 2705 |
| 4880 | 3004880612851 | 2705 |
| 4881 | 3004881106290 | 2707 |
| 4882 | 3004882627031 | 2707 |
| 4883 | 3004883782493 | 2707 |
| 4884 | 3004884732382 | 2707 |
| 4885 | 3004885086931 | 2708 |
| 4886 | 3004886055672 | 2708 |
| 4887 | 3004887009376 | 2709 |
| 4888 | 3004888901981 | 2710 |
| 4889 | 3004889405522 | 2710 |
| 4890 | 3004890757992 | 2712 |
| 4891 | 3004891150010 | 2712 |
| 4892 | 3004892964567 | 2714 |
| 4893 | 3004893911653 | 2715 |
| 4894 | 3004894305660 | 2715 |
| 4895 | 3004895421968 | 2716 |
| 4896 | 3004896586714 | 2716 |
| 4897 | 3004897301893 | 2717 |
| 4898 | 3004898471107 | 2719 |
| 4899 | 3004899907061 | 2719 |
| 4900 | 3004900062368 | 2720 |
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;