Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,951–2,975 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2951 | 3002951635056 | 1684 |
| 2952 | 3002952355575 | 1686 |
| 2953 | 3002953156645 | 1686 |
| 2954 | 3002954300926 | 1686 |
| 2955 | 3002955246097 | 1686 |
| 2956 | 3002956765081 | 1686 |
| 2957 | 3002957638894 | 1686 |
| 2958 | 3002958309256 | 1686 |
| 2959 | 3002959854317 | 1686 |
| 2960 | 3002960645764 | 1686 |
| 2961 | 3002961889989 | 1686 |
| 2962 | 3002962259116 | 1686 |
| 2963 | 3002963662154 | 1686 |
| 2964 | 3002964898885 | 1686 |
| 2965 | 3002965149768 | 1686 |
| 2966 | 3002966797820 | 1686 |
| 2967 | 3002967855287 | 1686 |
| 2968 | 3002968772067 | 1686 |
| 2969 | 3002969993675 | 1686 |
| 2970 | 3002970291252 | 1686 |
| 2971 | 3002971330439 | 1686 |
| 2972 | 3002972312618 | 1686 |
| 2973 | 3002973137007 | 1686 |
| 2974 | 3002974408898 | 1686 |
| 2975 | 3002975371744 | 1686 |
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;