Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,726–5,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5726 | 3005726759765 | 3191 |
| 5727 | 3005727536336 | 3191 |
| 5728 | 3005728552151 | 3191 |
| 5729 | 3005729303904 | 3191 |
| 5730 | 3005730076436 | 3191 |
| 5731 | 3005731760169 | 3191 |
| 5732 | 3005732767961 | 3191 |
| 5733 | 3005733669663 | 3191 |
| 5734 | 3005734131536 | 3191 |
| 5735 | 3005735017840 | 3191 |
| 5736 | 3005736322222 | 3191 |
| 5737 | 3005737529742 | 3191 |
| 5738 | 3005738412630 | 3192 |
| 5739 | 3005739299124 | 3192 |
| 5740 | 3005740187271 | 3193 |
| 5741 | 3005741247320 | 3194 |
| 5742 | 3005742760453 | 3194 |
| 5743 | 3005743654096 | 3194 |
| 5744 | 3005744233111 | 3194 |
| 5745 | 3005745253320 | 3196 |
| 5746 | 3005746284314 | 3196 |
| 5747 | 3005747500526 | 3196 |
| 5748 | 3005748699399 | 3197 |
| 5749 | 3005749333156 | 3197 |
| 5750 | 3005750032274 | 3198 |
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;