Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,126–8,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8126 | 3008126914694 | 4349 |
| 8127 | 3008127379807 | 4349 |
| 8128 | 3008128629076 | 4350 |
| 8129 | 3008129644427 | 4350 |
| 8130 | 3008130810338 | 4350 |
| 8131 | 3008131934221 | 4351 |
| 8132 | 3008132037395 | 4351 |
| 8133 | 3008133236459 | 4355 |
| 8134 | 3008134784933 | 4356 |
| 8135 | 3008135558681 | 4356 |
| 8136 | 3008136647174 | 4358 |
| 8137 | 3008137639391 | 4358 |
| 8138 | 3008138824706 | 4358 |
| 8139 | 3008139979919 | 4358 |
| 8140 | 3008140374949 | 4358 |
| 8141 | 3008141329945 | 4362 |
| 8142 | 3008142234434 | 4362 |
| 8143 | 3008143278291 | 4364 |
| 8144 | 3008144017748 | 4365 |
| 8145 | 3008145171108 | 4365 |
| 8146 | 3008146075408 | 4366 |
| 8147 | 3008147761186 | 4367 |
| 8148 | 3008148116132 | 4367 |
| 8149 | 3008149523351 | 4368 |
| 8150 | 3008150418176 | 4369 |
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;