Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,951–5,975 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5951 | 3005951596646 | 3306 |
| 5952 | 3005952609517 | 3306 |
| 5953 | 3005953705392 | 3306 |
| 5954 | 3005954692916 | 3307 |
| 5955 | 3005955102388 | 3307 |
| 5956 | 3005956527672 | 3308 |
| 5957 | 3005957849848 | 3310 |
| 5958 | 3005958427988 | 3310 |
| 5959 | 3005959558801 | 3311 |
| 5960 | 3005960011976 | 3312 |
| 5961 | 3005961604362 | 3312 |
| 5962 | 3005962590052 | 3312 |
| 5963 | 3005963739405 | 3312 |
| 5964 | 3005964402897 | 3312 |
| 5965 | 3005965467635 | 3312 |
| 5966 | 3005966454143 | 3312 |
| 5967 | 3005967930669 | 3312 |
| 5968 | 3005968593383 | 3312 |
| 5969 | 3005969030485 | 3312 |
| 5970 | 3005970271052 | 3312 |
| 5971 | 3005971073968 | 3312 |
| 5972 | 3005972910437 | 3312 |
| 5973 | 3005973525908 | 3312 |
| 5974 | 3005974586578 | 3312 |
| 5975 | 3005975139280 | 3312 |
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;