Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,751–2,775 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2751 | 3002751421876 | 1545 |
| 2752 | 3002752259971 | 1546 |
| 2753 | 3002753146292 | 1547 |
| 2754 | 3002754862795 | 1547 |
| 2755 | 3002755494621 | 1549 |
| 2756 | 3002756250975 | 1549 |
| 2757 | 3002757127524 | 1549 |
| 2758 | 3002758080313 | 1549 |
| 2759 | 3002759874588 | 1549 |
| 2760 | 3002760527254 | 1550 |
| 2761 | 3002761448702 | 1552 |
| 2762 | 3002762181842 | 1552 |
| 2763 | 3002763682409 | 1552 |
| 2764 | 3002764672367 | 1552 |
| 2765 | 3002765567188 | 1552 |
| 2766 | 3002766905444 | 1553 |
| 2767 | 3002767268202 | 1554 |
| 2768 | 3002768378403 | 1554 |
| 2769 | 3002769135425 | 1556 |
| 2770 | 3002770925111 | 1557 |
| 2771 | 3002771891143 | 1557 |
| 2772 | 3002772432106 | 1557 |
| 2773 | 3002773085798 | 1557 |
| 2774 | 3002774389276 | 1558 |
| 2775 | 3002775306284 | 1558 |
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;