Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,076–7,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7076 | 3007076693435 | 3879 |
| 7077 | 3007077972281 | 3879 |
| 7078 | 3007078185268 | 3879 |
| 7079 | 3007079033232 | 3879 |
| 7080 | 3007080882281 | 3883 |
| 7081 | 3007081003877 | 3884 |
| 7082 | 3007082602543 | 3884 |
| 7083 | 3007083858670 | 3885 |
| 7084 | 3007084746012 | 3886 |
| 7085 | 3007085590201 | 3887 |
| 7086 | 3007086861776 | 3887 |
| 7087 | 3007087735314 | 3887 |
| 7088 | 3007088180128 | 3887 |
| 7089 | 3007089568969 | 3887 |
| 7090 | 3007090493588 | 3887 |
| 7091 | 3007091437508 | 3887 |
| 7092 | 3007092659707 | 3887 |
| 7093 | 3007093691843 | 3887 |
| 7094 | 3007094954968 | 3887 |
| 7095 | 3007095783178 | 3887 |
| 7096 | 3007096508967 | 3887 |
| 7097 | 3007097444014 | 3887 |
| 7098 | 3007098006863 | 3887 |
| 7099 | 3007099299024 | 3887 |
| 7100 | 3007100046318 | 3887 |
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;