Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,901–2,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2901 | 3002901183174 | 1646 |
| 2902 | 3002902889925 | 1647 |
| 2903 | 3002903506606 | 1647 |
| 2904 | 3002904834963 | 1647 |
| 2905 | 3002905018003 | 1647 |
| 2906 | 3002906158485 | 1648 |
| 2907 | 3002907458076 | 1648 |
| 2908 | 3002908033473 | 1648 |
| 2909 | 3002909595164 | 1650 |
| 2910 | 3002910621157 | 1650 |
| 2911 | 3002911308113 | 1652 |
| 2912 | 3002912503714 | 1652 |
| 2913 | 3002913472962 | 1653 |
| 2914 | 3002914760746 | 1653 |
| 2915 | 3002915908846 | 1654 |
| 2916 | 3002916885287 | 1654 |
| 2917 | 3002917692953 | 1655 |
| 2918 | 3002918801481 | 1655 |
| 2919 | 3002919892818 | 1659 |
| 2920 | 3002920518263 | 1663 |
| 2921 | 3002921486407 | 1663 |
| 2922 | 3002922240483 | 1664 |
| 2923 | 3002923669557 | 1664 |
| 2924 | 3002924238719 | 1664 |
| 2925 | 3002925217121 | 1664 |
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;