Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,076–6,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6076 | 3006076815369 | 3358 |
| 6077 | 3006077335846 | 3358 |
| 6078 | 3006078581149 | 3359 |
| 6079 | 3006079655770 | 3359 |
| 6080 | 3006080678047 | 3359 |
| 6081 | 3006081021390 | 3361 |
| 6082 | 3006082890867 | 3362 |
| 6083 | 3006083926141 | 3365 |
| 6084 | 3006084015302 | 3365 |
| 6085 | 3006085458618 | 3365 |
| 6086 | 3006086211809 | 3365 |
| 6087 | 3006087032066 | 3365 |
| 6088 | 3006088066141 | 3367 |
| 6089 | 3006089151630 | 3367 |
| 6090 | 3006090844923 | 3368 |
| 6091 | 3006091265538 | 3368 |
| 6092 | 3006092082576 | 3368 |
| 6093 | 3006093744779 | 3369 |
| 6094 | 3006094459958 | 3369 |
| 6095 | 3006095367382 | 3369 |
| 6096 | 3006096357097 | 3369 |
| 6097 | 3006097601736 | 3370 |
| 6098 | 3006098326827 | 3370 |
| 6099 | 3006099293228 | 3371 |
| 6100 | 3006100494100 | 3374 |
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;