Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,601–5,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5601 | 3005601817934 | 3128 |
| 5602 | 3005602883744 | 3128 |
| 5603 | 3005603956900 | 3128 |
| 5604 | 3005604396225 | 3128 |
| 5605 | 3005605011486 | 3128 |
| 5606 | 3005606945640 | 3128 |
| 5607 | 3005607094606 | 3128 |
| 5608 | 3005608327295 | 3128 |
| 5609 | 3005609420965 | 3128 |
| 5610 | 3005610457348 | 3128 |
| 5611 | 3005611598006 | 3128 |
| 5612 | 3005612975516 | 3128 |
| 5613 | 3005613914565 | 3128 |
| 5614 | 3005614160189 | 3128 |
| 5615 | 3005615157680 | 3128 |
| 5616 | 3005616556480 | 3128 |
| 5617 | 3005617546286 | 3128 |
| 5618 | 3005618067652 | 3128 |
| 5619 | 3005619262445 | 3128 |
| 5620 | 3005620562577 | 3128 |
| 5621 | 3005621582439 | 3128 |
| 5622 | 3005622874142 | 3128 |
| 5623 | 3005623461222 | 3128 |
| 5624 | 3005624333245 | 3128 |
| 5625 | 3005625642600 | 3128 |
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;