Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,976–3,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2976 | 3002976457374 | 1686 |
| 2977 | 3002977490798 | 1686 |
| 2978 | 3002978814396 | 1686 |
| 2979 | 3002979402146 | 1686 |
| 2980 | 3002980460697 | 1686 |
| 2981 | 3002981394831 | 1686 |
| 2982 | 3002982109777 | 1686 |
| 2983 | 3002983400781 | 1686 |
| 2984 | 3002984021560 | 1686 |
| 2985 | 3002985199091 | 1686 |
| 2986 | 3002986244169 | 1686 |
| 2987 | 3002987563034 | 1686 |
| 2988 | 3002988274771 | 1686 |
| 2989 | 3002989676405 | 1686 |
| 2990 | 3002990710169 | 1686 |
| 2991 | 3002991329408 | 1688 |
| 2992 | 3002992892281 | 1688 |
| 2993 | 3002993105571 | 1689 |
| 2994 | 3002994740085 | 1689 |
| 2995 | 3002995731543 | 1690 |
| 2996 | 3002996601327 | 1690 |
| 2997 | 3002997990819 | 1691 |
| 2998 | 3002998786649 | 1692 |
| 2999 | 3002999820267 | 1692 |
| 3000 | 3003000578843 | 1693 |
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;