Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,726–6,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6726 | 3006726331534 | 3676 |
| 6727 | 3006727427059 | 3679 |
| 6728 | 3006728025253 | 3679 |
| 6729 | 3006729214050 | 3681 |
| 6730 | 3006730595236 | 3682 |
| 6731 | 3006731398062 | 3682 |
| 6732 | 3006732344791 | 3682 |
| 6733 | 3006733550953 | 3682 |
| 6734 | 3006734141954 | 3684 |
| 6735 | 3006735487389 | 3684 |
| 6736 | 3006736695551 | 3684 |
| 6737 | 3006737108278 | 3688 |
| 6738 | 3006738609405 | 3688 |
| 6739 | 3006739995211 | 3689 |
| 6740 | 3006740355383 | 3690 |
| 6741 | 3006741828309 | 3690 |
| 6742 | 3006742204797 | 3691 |
| 6743 | 3006743859723 | 3691 |
| 6744 | 3006744538638 | 3692 |
| 6745 | 3006745986298 | 3692 |
| 6746 | 3006746743862 | 3693 |
| 6747 | 3006747142378 | 3693 |
| 6748 | 3006748817800 | 3693 |
| 6749 | 3006749317928 | 3696 |
| 6750 | 3006750823988 | 3696 |
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;