Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,976–9,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8976 | 3008976510978 | 4873 |
| 8977 | 3008977808857 | 4873 |
| 8978 | 3008978515273 | 4873 |
| 8979 | 3008979284206 | 4873 |
| 8980 | 3008980243924 | 4873 |
| 8981 | 3008981581837 | 4873 |
| 8982 | 3008982275581 | 4873 |
| 8983 | 3008983403728 | 4873 |
| 8984 | 3008984459564 | 4873 |
| 8985 | 3008985422749 | 4873 |
| 8986 | 3008986301536 | 4873 |
| 8987 | 3008987654276 | 4873 |
| 8988 | 3008988853649 | 4873 |
| 8989 | 3008989042639 | 4873 |
| 8990 | 3008990826137 | 4873 |
| 8991 | 3008991460725 | 4873 |
| 8992 | 3008992846236 | 4873 |
| 8993 | 3008993733699 | 4873 |
| 8994 | 3008994255042 | 4873 |
| 8995 | 3008995218291 | 4873 |
| 8996 | 3008996589895 | 4873 |
| 8997 | 3008997526301 | 4873 |
| 8998 | 3008998877154 | 4873 |
| 8999 | 3008999559532 | 4873 |
| 9000 | 3009000676782 | 4873 |
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;