Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,901–8,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8901 | 3008901789857 | 4862 |
| 8902 | 3008902586430 | 4862 |
| 8903 | 3008903123136 | 4862 |
| 8904 | 3008904110183 | 4862 |
| 8905 | 3008905407098 | 4862 |
| 8906 | 3008906839676 | 4862 |
| 8907 | 3008907310209 | 4862 |
| 8908 | 3008908585255 | 4862 |
| 8909 | 3008909464935 | 4862 |
| 8910 | 3008910621596 | 4862 |
| 8911 | 3008911999025 | 4862 |
| 8912 | 3008912661461 | 4862 |
| 8913 | 3008913533703 | 4862 |
| 8914 | 3008914994049 | 4862 |
| 8915 | 3008915042492 | 4862 |
| 8916 | 3008916185385 | 4862 |
| 8917 | 3008917892174 | 4862 |
| 8918 | 3008918934236 | 4862 |
| 8919 | 3008919632615 | 4862 |
| 8920 | 3008920510608 | 4862 |
| 8921 | 3008921218383 | 4862 |
| 8922 | 3008922053549 | 4862 |
| 8923 | 3008923210056 | 4862 |
| 8924 | 3008924129337 | 4862 |
| 8925 | 3008925848314 | 4862 |
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;