Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,451–7,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7451 | 3007451760898 | 4051 |
| 7452 | 3007452939681 | 4052 |
| 7453 | 3007453765608 | 4053 |
| 7454 | 3007454343095 | 4053 |
| 7455 | 3007455015135 | 4053 |
| 7456 | 3007456423695 | 4053 |
| 7457 | 3007457203449 | 4055 |
| 7458 | 3007458690841 | 4056 |
| 7459 | 3007459984232 | 4056 |
| 7460 | 3007460719021 | 4059 |
| 7461 | 3007461710983 | 4059 |
| 7462 | 3007462500880 | 4059 |
| 7463 | 3007463130306 | 4059 |
| 7464 | 3007464055130 | 4060 |
| 7465 | 3007465306247 | 4060 |
| 7466 | 3007466409780 | 4061 |
| 7467 | 3007467979228 | 4061 |
| 7468 | 3007468115400 | 4062 |
| 7469 | 3007469494176 | 4062 |
| 7470 | 3007470199336 | 4065 |
| 7471 | 3007471789520 | 4065 |
| 7472 | 3007472454980 | 4067 |
| 7473 | 3007473644619 | 4070 |
| 7474 | 3007474024337 | 4071 |
| 7475 | 3007475922894 | 4073 |
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;