Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,051–8,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8051 | 3008051546207 | 4302 |
| 8052 | 3008052952898 | 4302 |
| 8053 | 3008053991572 | 4302 |
| 8054 | 3008054913653 | 4302 |
| 8055 | 3008055783372 | 4302 |
| 8056 | 3008056126138 | 4303 |
| 8057 | 3008057641229 | 4304 |
| 8058 | 3008058126755 | 4304 |
| 8059 | 3008059892472 | 4304 |
| 8060 | 3008060223227 | 4304 |
| 8061 | 3008061395427 | 4306 |
| 8062 | 3008062792025 | 4306 |
| 8063 | 3008063737040 | 4307 |
| 8064 | 3008064176269 | 4307 |
| 8065 | 3008065754286 | 4307 |
| 8066 | 3008066601304 | 4307 |
| 8067 | 3008067477595 | 4308 |
| 8068 | 3008068783813 | 4308 |
| 8069 | 3008069823396 | 4308 |
| 8070 | 3008070271034 | 4308 |
| 8071 | 3008071708269 | 4309 |
| 8072 | 3008072355404 | 4309 |
| 8073 | 3008073480292 | 4311 |
| 8074 | 3008074455798 | 4311 |
| 8075 | 3008075743874 | 4311 |
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;