Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,901–7,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7901 | 3007901583488 | 4242 |
| 7902 | 3007902512302 | 4243 |
| 7903 | 3007903961323 | 4244 |
| 7904 | 3007904788048 | 4244 |
| 7905 | 3007905215523 | 4244 |
| 7906 | 3007906215608 | 4244 |
| 7907 | 3007907618558 | 4245 |
| 7908 | 3007908962907 | 4245 |
| 7909 | 3007909484175 | 4245 |
| 7910 | 3007910946253 | 4245 |
| 7911 | 3007911976899 | 4246 |
| 7912 | 3007912529958 | 4246 |
| 7913 | 3007913750624 | 4248 |
| 7914 | 3007914508314 | 4249 |
| 7915 | 3007915033352 | 4249 |
| 7916 | 3007916024127 | 4249 |
| 7917 | 3007917936737 | 4249 |
| 7918 | 3007918469002 | 4253 |
| 7919 | 3007919552075 | 4253 |
| 7920 | 3007920580004 | 4254 |
| 7921 | 3007921355722 | 4254 |
| 7922 | 3007922712840 | 4254 |
| 7923 | 3007923775637 | 4254 |
| 7924 | 3007924424238 | 4256 |
| 7925 | 3007925900872 | 4256 |
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;