Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,151–7,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7151 | 3007151610071 | 3890 |
| 7152 | 3007152206104 | 3890 |
| 7153 | 3007153928697 | 3890 |
| 7154 | 3007154269892 | 3891 |
| 7155 | 3007155264742 | 3891 |
| 7156 | 3007156882920 | 3891 |
| 7157 | 3007157658246 | 3891 |
| 7158 | 3007158823157 | 3892 |
| 7159 | 3007159012186 | 3892 |
| 7160 | 3007160370602 | 3892 |
| 7161 | 3007161599694 | 3892 |
| 7162 | 3007162936494 | 3892 |
| 7163 | 3007163497966 | 3893 |
| 7164 | 3007164511021 | 3893 |
| 7165 | 3007165690824 | 3893 |
| 7166 | 3007166574642 | 3893 |
| 7167 | 3007167698643 | 3894 |
| 7168 | 3007168482170 | 3894 |
| 7169 | 3007169142780 | 3895 |
| 7170 | 3007170438814 | 3895 |
| 7171 | 3007171055645 | 3896 |
| 7172 | 3007172458130 | 3897 |
| 7173 | 3007173266781 | 3897 |
| 7174 | 3007174010630 | 3897 |
| 7175 | 3007175484337 | 3897 |
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;