Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,776–3,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3776 | 3003776073360 | 2075 |
| 3777 | 3003777192822 | 2076 |
| 3778 | 3003778633266 | 2076 |
| 3779 | 3003779827308 | 2078 |
| 3780 | 3003780057808 | 2078 |
| 3781 | 3003781835729 | 2078 |
| 3782 | 3003782142303 | 2078 |
| 3783 | 3003783837283 | 2081 |
| 3784 | 3003784691739 | 2081 |
| 3785 | 3003785307580 | 2081 |
| 3786 | 3003786320532 | 2081 |
| 3787 | 3003787632495 | 2081 |
| 3788 | 3003788590036 | 2081 |
| 3789 | 3003789140003 | 2081 |
| 3790 | 3003790251270 | 2081 |
| 3791 | 3003791096074 | 2081 |
| 3792 | 3003792252172 | 2081 |
| 3793 | 3003793399926 | 2081 |
| 3794 | 3003794842339 | 2081 |
| 3795 | 3003795374095 | 2081 |
| 3796 | 3003796342497 | 2081 |
| 3797 | 3003797885407 | 2081 |
| 3798 | 3003798241592 | 2081 |
| 3799 | 3003799252980 | 2081 |
| 3800 | 3003800233898 | 2081 |
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;