Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,701–8,725 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8701 | 3008701651361 | 4721 |
| 8702 | 3008702883658 | 4722 |
| 8703 | 3008703988558 | 4722 |
| 8704 | 3008704726641 | 4724 |
| 8705 | 3008705402745 | 4726 |
| 8706 | 3008706054874 | 4726 |
| 8707 | 3008707820737 | 4726 |
| 8708 | 3008708854870 | 4726 |
| 8709 | 3008709486187 | 4728 |
| 8710 | 3008710207466 | 4729 |
| 8711 | 3008711635596 | 4731 |
| 8712 | 3008712134492 | 4733 |
| 8713 | 3008713545363 | 4733 |
| 8714 | 3008714640223 | 4736 |
| 8715 | 3008715574741 | 4736 |
| 8716 | 3008716751170 | 4736 |
| 8717 | 3008717220436 | 4741 |
| 8718 | 3008718726586 | 4741 |
| 8719 | 3008719702134 | 4742 |
| 8720 | 3008720678206 | 4742 |
| 8721 | 3008721601007 | 4742 |
| 8722 | 3008722423377 | 4743 |
| 8723 | 3008723087936 | 4745 |
| 8724 | 3008724452839 | 4745 |
| 8725 | 3008725141018 | 4745 |
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;