Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,876–2,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2876 | 3002876846991 | 1635 |
| 2877 | 3002877741349 | 1637 |
| 2878 | 3002878489050 | 1637 |
| 2879 | 3002879316265 | 1638 |
| 2880 | 3002880363760 | 1638 |
| 2881 | 3002881826504 | 1638 |
| 2882 | 3002882916023 | 1639 |
| 2883 | 3002883415809 | 1639 |
| 2884 | 3002884404304 | 1641 |
| 2885 | 3002885141934 | 1641 |
| 2886 | 3002886884098 | 1641 |
| 2887 | 3002887202060 | 1642 |
| 2888 | 3002888982736 | 1642 |
| 2889 | 3002889648372 | 1643 |
| 2890 | 3002890520396 | 1643 |
| 2891 | 3002891545354 | 1643 |
| 2892 | 3002892393313 | 1643 |
| 2893 | 3002893008969 | 1645 |
| 2894 | 3002894484979 | 1645 |
| 2895 | 3002895134236 | 1645 |
| 2896 | 3002896231138 | 1645 |
| 2897 | 3002897495502 | 1646 |
| 2898 | 3002898783174 | 1646 |
| 2899 | 3002899837269 | 1646 |
| 2900 | 3002900786100 | 1646 |
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;