Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,826–7,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7826 | 3007826537555 | 4219 |
| 7827 | 3007827553674 | 4219 |
| 7828 | 3007828505235 | 4219 |
| 7829 | 3007829077807 | 4219 |
| 7830 | 3007830851675 | 4219 |
| 7831 | 3007831041448 | 4219 |
| 7832 | 3007832025528 | 4219 |
| 7833 | 3007833649591 | 4219 |
| 7834 | 3007834003495 | 4219 |
| 7835 | 3007835488607 | 4219 |
| 7836 | 3007836649282 | 4219 |
| 7837 | 3007837136380 | 4219 |
| 7838 | 3007838227516 | 4219 |
| 7839 | 3007839543121 | 4219 |
| 7840 | 3007840718330 | 4219 |
| 7841 | 3007841473912 | 4219 |
| 7842 | 3007842926953 | 4219 |
| 7843 | 3007843752495 | 4219 |
| 7844 | 3007844189497 | 4219 |
| 7845 | 3007845411377 | 4219 |
| 7846 | 3007846643120 | 4219 |
| 7847 | 3007847912058 | 4219 |
| 7848 | 3007848258967 | 4219 |
| 7849 | 3007849354290 | 4219 |
| 7850 | 3007850547298 | 4219 |
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;