Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,101–5,125 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5101 | 3005101149264 | 2817 |
| 5102 | 3005102119854 | 2817 |
| 5103 | 3005103634328 | 2817 |
| 5104 | 3005104510900 | 2817 |
| 5105 | 3005105641169 | 2817 |
| 5106 | 3005106672021 | 2817 |
| 5107 | 3005107568120 | 2817 |
| 5108 | 3005108887538 | 2817 |
| 5109 | 3005109366964 | 2817 |
| 5110 | 3005110421557 | 2817 |
| 5111 | 3005111936917 | 2817 |
| 5112 | 3005112815525 | 2817 |
| 5113 | 3005113796816 | 2817 |
| 5114 | 3005114877982 | 2817 |
| 5115 | 3005115073151 | 2817 |
| 5116 | 3005116143294 | 2817 |
| 5117 | 3005117871701 | 2817 |
| 5118 | 3005118948358 | 2817 |
| 5119 | 3005119628396 | 2817 |
| 5120 | 3005120793522 | 2817 |
| 5121 | 3005121892381 | 2817 |
| 5122 | 3005122519137 | 2817 |
| 5123 | 3005123448893 | 2818 |
| 5124 | 3005124374220 | 2819 |
| 5125 | 3005125057184 | 2819 |
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;