Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,101–6,125 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6101 | 3006101776884 | 3377 |
| 6102 | 3006102421008 | 3377 |
| 6103 | 3006103523599 | 3377 |
| 6104 | 3006104652710 | 3378 |
| 6105 | 3006105206809 | 3378 |
| 6106 | 3006106464609 | 3380 |
| 6107 | 3006107250827 | 3380 |
| 6108 | 3006108917574 | 3381 |
| 6109 | 3006109037339 | 3381 |
| 6110 | 3006110706976 | 3382 |
| 6111 | 3006111935989 | 3382 |
| 6112 | 3006112304971 | 3383 |
| 6113 | 3006113210531 | 3383 |
| 6114 | 3006114769547 | 3384 |
| 6115 | 3006115013184 | 3384 |
| 6116 | 3006116232618 | 3385 |
| 6117 | 3006117958146 | 3385 |
| 6118 | 3006118596008 | 3385 |
| 6119 | 3006119646634 | 3385 |
| 6120 | 3006120083518 | 3386 |
| 6121 | 3006121816284 | 3386 |
| 6122 | 3006122410778 | 3386 |
| 6123 | 3006123329468 | 3386 |
| 6124 | 3006124549412 | 3386 |
| 6125 | 3006125996987 | 3386 |
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;