Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,101–3,125 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3101 | 3003101490771 | 1754 |
| 3102 | 3003102411666 | 1754 |
| 3103 | 3003103443306 | 1754 |
| 3104 | 3003104748550 | 1754 |
| 3105 | 3003105358393 | 1754 |
| 3106 | 3003106374009 | 1754 |
| 3107 | 3003107185921 | 1754 |
| 3108 | 3003108045609 | 1754 |
| 3109 | 3003109813634 | 1754 |
| 3110 | 3003110759468 | 1754 |
| 3111 | 3003111882244 | 1754 |
| 3112 | 3003112584434 | 1754 |
| 3113 | 3003113979586 | 1754 |
| 3114 | 3003114206638 | 1754 |
| 3115 | 3003115999850 | 1754 |
| 3116 | 3003116543628 | 1754 |
| 3117 | 3003117525938 | 1754 |
| 3118 | 3003118581211 | 1754 |
| 3119 | 3003119938817 | 1754 |
| 3120 | 3003120676293 | 1754 |
| 3121 | 3003121320147 | 1754 |
| 3122 | 3003122671312 | 1754 |
| 3123 | 3003123757346 | 1754 |
| 3124 | 3003124587086 | 1754 |
| 3125 | 3003125879755 | 1754 |
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;