Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,876–8,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8876 | 3008876894320 | 4845 |
| 8877 | 3008877483573 | 4846 |
| 8878 | 3008878385554 | 4846 |
| 8879 | 3008879383112 | 4848 |
| 8880 | 3008880353378 | 4848 |
| 8881 | 3008881866386 | 4848 |
| 8882 | 3008882515528 | 4848 |
| 8883 | 3008883592739 | 4850 |
| 8884 | 3008884090053 | 4850 |
| 8885 | 3008885047682 | 4851 |
| 8886 | 3008886963927 | 4851 |
| 8887 | 3008887288773 | 4851 |
| 8888 | 3008888473064 | 4852 |
| 8889 | 3008889878574 | 4852 |
| 8890 | 3008890243659 | 4854 |
| 8891 | 3008891838686 | 4856 |
| 8892 | 3008892995329 | 4856 |
| 8893 | 3008893675775 | 4856 |
| 8894 | 3008894728286 | 4856 |
| 8895 | 3008895422585 | 4859 |
| 8896 | 3008896111137 | 4859 |
| 8897 | 3008897529381 | 4859 |
| 8898 | 3008898616813 | 4859 |
| 8899 | 3008899928351 | 4859 |
| 8900 | 3008900375661 | 4861 |
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;