Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,676–9,700 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9676 | 3009676757383 | 5281 |
| 9677 | 3009677155030 | 5282 |
| 9678 | 3009678298873 | 5282 |
| 9679 | 3009679787472 | 5282 |
| 9680 | 3009680360970 | 5282 |
| 9681 | 3009681854492 | 5282 |
| 9682 | 3009682162378 | 5283 |
| 9683 | 3009683498934 | 5283 |
| 9684 | 3009684474708 | 5284 |
| 9685 | 3009685332532 | 5284 |
| 9686 | 3009686699578 | 5285 |
| 9687 | 3009687088946 | 5285 |
| 9688 | 3009688395802 | 5285 |
| 9689 | 3009689918537 | 5285 |
| 9690 | 3009690720403 | 5286 |
| 9691 | 3009691326312 | 5286 |
| 9692 | 3009692566235 | 5286 |
| 9693 | 3009693588496 | 5288 |
| 9694 | 3009694872107 | 5288 |
| 9695 | 3009695429006 | 5290 |
| 9696 | 3009696575720 | 5290 |
| 9697 | 3009697278097 | 5291 |
| 9698 | 3009698423288 | 5293 |
| 9699 | 3009699167183 | 5297 |
| 9700 | 3009700711007 | 5297 |
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;