Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,526–7,550 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7526 | 3007526112825 | 4075 |
| 7527 | 3007527099456 | 4076 |
| 7528 | 3007528579244 | 4076 |
| 7529 | 3007529878571 | 4076 |
| 7530 | 3007530136948 | 4076 |
| 7531 | 3007531734691 | 4078 |
| 7532 | 3007532611199 | 4078 |
| 7533 | 3007533965186 | 4078 |
| 7534 | 3007534433606 | 4078 |
| 7535 | 3007535300696 | 4078 |
| 7536 | 3007536062681 | 4078 |
| 7537 | 3007537548441 | 4078 |
| 7538 | 3007538262284 | 4078 |
| 7539 | 3007539447147 | 4078 |
| 7540 | 3007540145759 | 4078 |
| 7541 | 3007541015129 | 4078 |
| 7542 | 3007542735563 | 4078 |
| 7543 | 3007543379512 | 4078 |
| 7544 | 3007544352004 | 4078 |
| 7545 | 3007545752070 | 4078 |
| 7546 | 3007546300901 | 4078 |
| 7547 | 3007547629208 | 4078 |
| 7548 | 3007548988941 | 4078 |
| 7549 | 3007549954540 | 4078 |
| 7550 | 3007550855618 | 4078 |
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;