Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,551–6,575 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6551 | 3006551458455 | 3608 |
| 6552 | 3006552823368 | 3608 |
| 6553 | 3006553649880 | 3608 |
| 6554 | 3006554791925 | 3609 |
| 6555 | 3006555742712 | 3609 |
| 6556 | 3006556601941 | 3610 |
| 6557 | 3006557956474 | 3610 |
| 6558 | 3006558588801 | 3610 |
| 6559 | 3006559418287 | 3612 |
| 6560 | 3006560995653 | 3613 |
| 6561 | 3006561697309 | 3615 |
| 6562 | 3006562872990 | 3616 |
| 6563 | 3006563876373 | 3616 |
| 6564 | 3006564820680 | 3619 |
| 6565 | 3006565806744 | 3619 |
| 6566 | 3006566205606 | 3620 |
| 6567 | 3006567289971 | 3622 |
| 6568 | 3006568802465 | 3623 |
| 6569 | 3006569184621 | 3623 |
| 6570 | 3006570511849 | 3623 |
| 6571 | 3006571018312 | 3624 |
| 6572 | 3006572412924 | 3624 |
| 6573 | 3006573975061 | 3625 |
| 6574 | 3006574171654 | 3626 |
| 6575 | 3006575474965 | 3626 |
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;