Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,401–7,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7401 | 3007401159190 | 4044 |
| 7402 | 3007402054344 | 4044 |
| 7403 | 3007403502844 | 4044 |
| 7404 | 3007404920387 | 4044 |
| 7405 | 3007405437340 | 4044 |
| 7406 | 3007406105450 | 4044 |
| 7407 | 3007407712087 | 4044 |
| 7408 | 3007408027579 | 4044 |
| 7409 | 3007409099902 | 4044 |
| 7410 | 3007410545589 | 4044 |
| 7411 | 3007411176137 | 4044 |
| 7412 | 3007412868200 | 4044 |
| 7413 | 3007413593746 | 4044 |
| 7414 | 3007414413422 | 4044 |
| 7415 | 3007415499115 | 4044 |
| 7416 | 3007416854377 | 4044 |
| 7417 | 3007417774584 | 4044 |
| 7418 | 3007418217593 | 4044 |
| 7419 | 3007419874557 | 4044 |
| 7420 | 3007420231148 | 4044 |
| 7421 | 3007421139197 | 4044 |
| 7422 | 3007422323035 | 4044 |
| 7423 | 3007423011515 | 4044 |
| 7424 | 3007424675855 | 4044 |
| 7425 | 3007425347567 | 4044 |
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;