Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,026–4,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4026 | 3004026866408 | 2236 |
| 4027 | 3004027819830 | 2236 |
| 4028 | 3004028662988 | 2236 |
| 4029 | 3004029999383 | 2239 |
| 4030 | 3004030856620 | 2239 |
| 4031 | 3004031805472 | 2241 |
| 4032 | 3004032556590 | 2241 |
| 4033 | 3004033049024 | 2242 |
| 4034 | 3004034424269 | 2242 |
| 4035 | 3004035077177 | 2243 |
| 4036 | 3004036102420 | 2243 |
| 4037 | 3004037379173 | 2243 |
| 4038 | 3004038387827 | 2243 |
| 4039 | 3004039924295 | 2243 |
| 4040 | 3004040775993 | 2247 |
| 4041 | 3004041308869 | 2248 |
| 4042 | 3004042875144 | 2249 |
| 4043 | 3004043305744 | 2249 |
| 4044 | 3004044028611 | 2250 |
| 4045 | 3004045185241 | 2250 |
| 4046 | 3004046974589 | 2250 |
| 4047 | 3004047006722 | 2251 |
| 4048 | 3004048308004 | 2252 |
| 4049 | 3004049338541 | 2255 |
| 4050 | 3004050997583 | 2255 |
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;