Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,051–6,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6051 | 3006051892333 | 3341 |
| 6052 | 3006052885420 | 3342 |
| 6053 | 3006053937658 | 3342 |
| 6054 | 3006054051905 | 3343 |
| 6055 | 3006055281858 | 3343 |
| 6056 | 3006056546313 | 3344 |
| 6057 | 3006057505303 | 3344 |
| 6058 | 3006058664753 | 3344 |
| 6059 | 3006059494874 | 3344 |
| 6060 | 3006060287518 | 3346 |
| 6061 | 3006061651926 | 3346 |
| 6062 | 3006062443350 | 3348 |
| 6063 | 3006063827998 | 3348 |
| 6064 | 3006064425207 | 3349 |
| 6065 | 3006065198919 | 3349 |
| 6066 | 3006066815543 | 3350 |
| 6067 | 3006067744225 | 3350 |
| 6068 | 3006068608758 | 3351 |
| 6069 | 3006069860766 | 3351 |
| 6070 | 3006070155990 | 3352 |
| 6071 | 3006071793706 | 3353 |
| 6072 | 3006072854437 | 3354 |
| 6073 | 3006073723651 | 3357 |
| 6074 | 3006074122069 | 3357 |
| 6075 | 3006075264145 | 3358 |
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;