Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,176–6,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6176 | 3006176087930 | 3398 |
| 6177 | 3006177745129 | 3399 |
| 6178 | 3006178998128 | 3399 |
| 6179 | 3006179687877 | 3399 |
| 6180 | 3006180095091 | 3400 |
| 6181 | 3006181446261 | 3400 |
| 6182 | 3006182341201 | 3401 |
| 6183 | 3006183058694 | 3406 |
| 6184 | 3006184504456 | 3406 |
| 6185 | 3006185096279 | 3406 |
| 6186 | 3006186048238 | 3407 |
| 6187 | 3006187081501 | 3407 |
| 6188 | 3006188700618 | 3407 |
| 6189 | 3006189102852 | 3407 |
| 6190 | 3006190832129 | 3409 |
| 6191 | 3006191280944 | 3409 |
| 6192 | 3006192236481 | 3410 |
| 6193 | 3006193994739 | 3412 |
| 6194 | 3006194089566 | 3413 |
| 6195 | 3006195714189 | 3413 |
| 6196 | 3006196459166 | 3415 |
| 6197 | 3006197515008 | 3416 |
| 6198 | 3006198540015 | 3416 |
| 6199 | 3006199078078 | 3417 |
| 6200 | 3006200628237 | 3417 |
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;