Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,076–5,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5076 | 3005076580238 | 2817 |
| 5077 | 3005077392049 | 2817 |
| 5078 | 3005078505960 | 2817 |
| 5079 | 3005079312795 | 2817 |
| 5080 | 3005080057626 | 2817 |
| 5081 | 3005081110962 | 2817 |
| 5082 | 3005082222415 | 2817 |
| 5083 | 3005083009263 | 2817 |
| 5084 | 3005084336663 | 2817 |
| 5085 | 3005085702765 | 2817 |
| 5086 | 3005086171373 | 2817 |
| 5087 | 3005087634731 | 2817 |
| 5088 | 3005088108600 | 2817 |
| 5089 | 3005089724839 | 2817 |
| 5090 | 3005090705583 | 2817 |
| 5091 | 3005091877401 | 2817 |
| 5092 | 3005092556445 | 2817 |
| 5093 | 3005093582314 | 2817 |
| 5094 | 3005094939254 | 2817 |
| 5095 | 3005095238831 | 2817 |
| 5096 | 3005096862405 | 2817 |
| 5097 | 3005097347112 | 2817 |
| 5098 | 3005098442265 | 2817 |
| 5099 | 3005099878755 | 2817 |
| 5100 | 3005100444755 | 2817 |
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;