Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,851–5,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5851 | 3005851318595 | 3271 |
| 5852 | 3005852922771 | 3271 |
| 5853 | 3005853107216 | 3271 |
| 5854 | 3005854456139 | 3271 |
| 5855 | 3005855759598 | 3271 |
| 5856 | 3005856430180 | 3271 |
| 5857 | 3005857101727 | 3271 |
| 5858 | 3005858281438 | 3271 |
| 5859 | 3005859161831 | 3271 |
| 5860 | 3005860543702 | 3271 |
| 5861 | 3005861313377 | 3271 |
| 5862 | 3005862666717 | 3271 |
| 5863 | 3005863251887 | 3271 |
| 5864 | 3005864197851 | 3271 |
| 5865 | 3005865233783 | 3272 |
| 5866 | 3005866425322 | 3272 |
| 5867 | 3005867145919 | 3272 |
| 5868 | 3005868998740 | 3274 |
| 5869 | 3005869280837 | 3274 |
| 5870 | 3005870562005 | 3276 |
| 5871 | 3005871596995 | 3276 |
| 5872 | 3005872675746 | 3278 |
| 5873 | 3005873690783 | 3281 |
| 5874 | 3005874571470 | 3281 |
| 5875 | 3005875026038 | 3282 |
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;