Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,926–4,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4926 | 3004926854824 | 2747 |
| 4927 | 3004927136168 | 2747 |
| 4928 | 3004928075895 | 2749 |
| 4929 | 3004929465581 | 2750 |
| 4930 | 3004930213680 | 2750 |
| 4931 | 3004931935950 | 2750 |
| 4932 | 3004932281940 | 2750 |
| 4933 | 3004933121217 | 2755 |
| 4934 | 3004934787819 | 2755 |
| 4935 | 3004935338947 | 2756 |
| 4936 | 3004936843545 | 2757 |
| 4937 | 3004937759373 | 2757 |
| 4938 | 3004938119878 | 2757 |
| 4939 | 3004939909226 | 2757 |
| 4940 | 3004940305041 | 2760 |
| 4941 | 3004941701444 | 2760 |
| 4942 | 3004942984086 | 2761 |
| 4943 | 3004943174887 | 2761 |
| 4944 | 3004944483836 | 2762 |
| 4945 | 3004945311461 | 2762 |
| 4946 | 3004946985981 | 2762 |
| 4947 | 3004947765922 | 2764 |
| 4948 | 3004948349390 | 2765 |
| 4949 | 3004949783000 | 2766 |
| 4950 | 3004950915195 | 2766 |
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;