Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,426–6,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6426 | 3006426480264 | 3544 |
| 6427 | 3006427403368 | 3544 |
| 6428 | 3006428120935 | 3544 |
| 6429 | 3006429919344 | 3544 |
| 6430 | 3006430754684 | 3545 |
| 6431 | 3006431002636 | 3545 |
| 6432 | 3006432095532 | 3545 |
| 6433 | 3006433375012 | 3545 |
| 6434 | 3006434308299 | 3547 |
| 6435 | 3006435576960 | 3548 |
| 6436 | 3006436798346 | 3548 |
| 6437 | 3006437420050 | 3549 |
| 6438 | 3006438403397 | 3549 |
| 6439 | 3006439408286 | 3549 |
| 6440 | 3006440492983 | 3549 |
| 6441 | 3006441009313 | 3550 |
| 6442 | 3006442344766 | 3551 |
| 6443 | 3006443591993 | 3552 |
| 6444 | 3006444604456 | 3552 |
| 6445 | 3006445312780 | 3552 |
| 6446 | 3006446359035 | 3552 |
| 6447 | 3006447233422 | 3553 |
| 6448 | 3006448330172 | 3554 |
| 6449 | 3006449797121 | 3556 |
| 6450 | 3006450550609 | 3556 |
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;