Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,326–9,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9326 | 3009326061077 | 5009 |
| 9327 | 3009327635560 | 5009 |
| 9328 | 3009328709626 | 5010 |
| 9329 | 3009329890259 | 5011 |
| 9330 | 3009330458323 | 5011 |
| 9331 | 3009331129107 | 5012 |
| 9332 | 3009332631743 | 5012 |
| 9333 | 3009333492008 | 5012 |
| 9334 | 3009334013983 | 5012 |
| 9335 | 3009335621963 | 5013 |
| 9336 | 3009336738153 | 5013 |
| 9337 | 3009337493061 | 5017 |
| 9338 | 3009338991174 | 5017 |
| 9339 | 3009339770817 | 5018 |
| 9340 | 3009340545017 | 5020 |
| 9341 | 3009341107892 | 5020 |
| 9342 | 3009342475489 | 5021 |
| 9343 | 3009343992535 | 5022 |
| 9344 | 3009344513714 | 5022 |
| 9345 | 3009345647371 | 5023 |
| 9346 | 3009346739966 | 5024 |
| 9347 | 3009347833083 | 5024 |
| 9348 | 3009348224839 | 5025 |
| 9349 | 3009349145706 | 5025 |
| 9350 | 3009350075922 | 5026 |
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;