Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,801–9,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9801 | 3009801044464 | 5382 |
| 9802 | 3009802998525 | 5384 |
| 9803 | 3009803427510 | 5384 |
| 9804 | 3009804552572 | 5385 |
| 9805 | 3009805410661 | 5386 |
| 9806 | 3009806792832 | 5386 |
| 9807 | 3009807195505 | 5387 |
| 9808 | 3009808220886 | 5387 |
| 9809 | 3009809286349 | 5387 |
| 9810 | 3009810617096 | 5387 |
| 9811 | 3009811259219 | 5388 |
| 9812 | 3009812658246 | 5389 |
| 9813 | 3009813249152 | 5390 |
| 9814 | 3009814789517 | 5391 |
| 9815 | 3009815971847 | 5391 |
| 9816 | 3009816057310 | 5393 |
| 9817 | 3009817165662 | 5393 |
| 9818 | 3009818880899 | 5393 |
| 9819 | 3009819957859 | 5394 |
| 9820 | 3009820490412 | 5394 |
| 9821 | 3009821917138 | 5394 |
| 9822 | 3009822924858 | 5394 |
| 9823 | 3009823317274 | 5394 |
| 9824 | 3009824436733 | 5397 |
| 9825 | 3009825084795 | 5397 |
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;