Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,851–4,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4851 | 3004851190024 | 2684 |
| 4852 | 3004852377784 | 2684 |
| 4853 | 3004853643540 | 2686 |
| 4854 | 3004854006086 | 2686 |
| 4855 | 3004855512411 | 2686 |
| 4856 | 3004856086536 | 2686 |
| 4857 | 3004857066494 | 2687 |
| 4858 | 3004858870379 | 2687 |
| 4859 | 3004859285810 | 2690 |
| 4860 | 3004860831707 | 2691 |
| 4861 | 3004861835779 | 2692 |
| 4862 | 3004862845407 | 2692 |
| 4863 | 3004863598381 | 2694 |
| 4864 | 3004864992092 | 2694 |
| 4865 | 3004865327161 | 2694 |
| 4866 | 3004866893450 | 2695 |
| 4867 | 3004867907324 | 2696 |
| 4868 | 3004868018439 | 2696 |
| 4869 | 3004869297485 | 2698 |
| 4870 | 3004870562256 | 2698 |
| 4871 | 3004871297284 | 2700 |
| 4872 | 3004872446337 | 2700 |
| 4873 | 3004873370302 | 2700 |
| 4874 | 3004874626760 | 2700 |
| 4875 | 3004875029139 | 2701 |
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;