Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,551–8,575 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8551 | 3008551626172 | 4634 |
| 8552 | 3008552177594 | 4637 |
| 8553 | 3008553829296 | 4637 |
| 8554 | 3008554967047 | 4638 |
| 8555 | 3008555154273 | 4638 |
| 8556 | 3008556437021 | 4640 |
| 8557 | 3008557754740 | 4640 |
| 8558 | 3008558368365 | 4643 |
| 8559 | 3008559783912 | 4644 |
| 8560 | 3008560003221 | 4648 |
| 8561 | 3008561332482 | 4650 |
| 8562 | 3008562823241 | 4650 |
| 8563 | 3008563813819 | 4650 |
| 8564 | 3008564427283 | 4650 |
| 8565 | 3008565810294 | 4651 |
| 8566 | 3008566606939 | 4651 |
| 8567 | 3008567379738 | 4653 |
| 8568 | 3008568105128 | 4653 |
| 8569 | 3008569517801 | 4653 |
| 8570 | 3008570166882 | 4654 |
| 8571 | 3008571257843 | 4654 |
| 8572 | 3008572783266 | 4654 |
| 8573 | 3008573088254 | 4655 |
| 8574 | 3008574121472 | 4657 |
| 8575 | 3008575263566 | 4657 |
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;