Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,951–6,975 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6951 | 3006951153219 | 3828 |
| 6952 | 3006952446051 | 3828 |
| 6953 | 3006953161048 | 3828 |
| 6954 | 3006954535869 | 3828 |
| 6955 | 3006955399671 | 3828 |
| 6956 | 3006956104779 | 3828 |
| 6957 | 3006957430115 | 3828 |
| 6958 | 3006958833871 | 3828 |
| 6959 | 3006959833686 | 3828 |
| 6960 | 3006960769008 | 3828 |
| 6961 | 3006961158833 | 3828 |
| 6962 | 3006962323615 | 3828 |
| 6963 | 3006963735997 | 3828 |
| 6964 | 3006964239055 | 3828 |
| 6965 | 3006965808697 | 3828 |
| 6966 | 3006966874001 | 3828 |
| 6967 | 3006967308629 | 3828 |
| 6968 | 3006968200627 | 3828 |
| 6969 | 3006969193870 | 3828 |
| 6970 | 3006970977123 | 3828 |
| 6971 | 3006971161789 | 3828 |
| 6972 | 3006972455483 | 3828 |
| 6973 | 3006973530062 | 3828 |
| 6974 | 3006974833683 | 3828 |
| 6975 | 3006975368893 | 3828 |
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;