Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,851–2,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2851 | 3002851221185 | 1616 |
| 2852 | 3002852918747 | 1618 |
| 2853 | 3002853857528 | 1618 |
| 2854 | 3002854858207 | 1619 |
| 2855 | 3002855138615 | 1623 |
| 2856 | 3002856636279 | 1624 |
| 2857 | 3002857570280 | 1624 |
| 2858 | 3002858875326 | 1625 |
| 2859 | 3002859450957 | 1625 |
| 2860 | 3002860128439 | 1625 |
| 2861 | 3002861554746 | 1625 |
| 2862 | 3002862413261 | 1626 |
| 2863 | 3002863674024 | 1626 |
| 2864 | 3002864999221 | 1629 |
| 2865 | 3002865841666 | 1630 |
| 2866 | 3002866947807 | 1632 |
| 2867 | 3002867333722 | 1632 |
| 2868 | 3002868089926 | 1632 |
| 2869 | 3002869410876 | 1632 |
| 2870 | 3002870697845 | 1633 |
| 2871 | 3002871782504 | 1633 |
| 2872 | 3002872697949 | 1633 |
| 2873 | 3002873615932 | 1635 |
| 2874 | 3002874828282 | 1635 |
| 2875 | 3002875185661 | 1635 |
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;