Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,876–7,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7876 | 3007876909941 | 4221 |
| 7877 | 3007877044754 | 4221 |
| 7878 | 3007878870834 | 4222 |
| 7879 | 3007879494095 | 4222 |
| 7880 | 3007880133239 | 4222 |
| 7881 | 3007881777734 | 4222 |
| 7882 | 3007882713282 | 4225 |
| 7883 | 3007883949397 | 4225 |
| 7884 | 3007884146172 | 4227 |
| 7885 | 3007885624781 | 4227 |
| 7886 | 3007886189014 | 4230 |
| 7887 | 3007887832271 | 4230 |
| 7888 | 3007888133869 | 4232 |
| 7889 | 3007889920785 | 4232 |
| 7890 | 3007890317797 | 4234 |
| 7891 | 3007891143748 | 4235 |
| 7892 | 3007892150094 | 4235 |
| 7893 | 3007893531293 | 4235 |
| 7894 | 3007894678714 | 4236 |
| 7895 | 3007895136763 | 4239 |
| 7896 | 3007896448379 | 4239 |
| 7897 | 3007897084548 | 4239 |
| 7898 | 3007898925382 | 4239 |
| 7899 | 3007899551768 | 4239 |
| 7900 | 3007900254314 | 4242 |
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;