Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,851–6,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6851 | 3006851927739 | 3745 |
| 6852 | 3006852899179 | 3747 |
| 6853 | 3006853159342 | 3748 |
| 6854 | 3006854151015 | 3751 |
| 6855 | 3006855587988 | 3751 |
| 6856 | 3006856061112 | 3752 |
| 6857 | 3006857544328 | 3752 |
| 6858 | 3006858581717 | 3753 |
| 6859 | 3006859635567 | 3753 |
| 6860 | 3006860867530 | 3753 |
| 6861 | 3006861840937 | 3755 |
| 6862 | 3006862627862 | 3755 |
| 6863 | 3006863836032 | 3759 |
| 6864 | 3006864098918 | 3759 |
| 6865 | 3006865201811 | 3760 |
| 6866 | 3006866920109 | 3761 |
| 6867 | 3006867255606 | 3761 |
| 6868 | 3006868997242 | 3761 |
| 6869 | 3006869425458 | 3766 |
| 6870 | 3006870481615 | 3767 |
| 6871 | 3006871737217 | 3767 |
| 6872 | 3006872458698 | 3768 |
| 6873 | 3006873247390 | 3769 |
| 6874 | 3006874345614 | 3769 |
| 6875 | 3006875659932 | 3769 |
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;