Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,376–7,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7376 | 3007376337806 | 4029 |
| 7377 | 3007377458467 | 4030 |
| 7378 | 3007378497360 | 4031 |
| 7379 | 3007379293536 | 4032 |
| 7380 | 3007380833352 | 4034 |
| 7381 | 3007381450137 | 4034 |
| 7382 | 3007382569520 | 4039 |
| 7383 | 3007383740522 | 4040 |
| 7384 | 3007384138350 | 4040 |
| 7385 | 3007385226720 | 4041 |
| 7386 | 3007386625938 | 4042 |
| 7387 | 3007387417781 | 4042 |
| 7388 | 3007388793111 | 4043 |
| 7389 | 3007389812117 | 4044 |
| 7390 | 3007390851071 | 4044 |
| 7391 | 3007391092970 | 4044 |
| 7392 | 3007392578917 | 4044 |
| 7393 | 3007393582443 | 4044 |
| 7394 | 3007394110702 | 4044 |
| 7395 | 3007395882872 | 4044 |
| 7396 | 3007396578859 | 4044 |
| 7397 | 3007397561140 | 4044 |
| 7398 | 3007398700770 | 4044 |
| 7399 | 3007399200042 | 4044 |
| 7400 | 3007400336289 | 4044 |
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;