Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,226–4,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4226 | 3004226093551 | 2343 |
| 4227 | 3004227277488 | 2343 |
| 4228 | 3004228706481 | 2343 |
| 4229 | 3004229854237 | 2343 |
| 4230 | 3004230950782 | 2343 |
| 4231 | 3004231367392 | 2343 |
| 4232 | 3004232989111 | 2343 |
| 4233 | 3004233875433 | 2343 |
| 4234 | 3004234474117 | 2343 |
| 4235 | 3004235733848 | 2343 |
| 4236 | 3004236192969 | 2343 |
| 4237 | 3004237834189 | 2343 |
| 4238 | 3004238447470 | 2343 |
| 4239 | 3004239484102 | 2344 |
| 4240 | 3004240477453 | 2344 |
| 4241 | 3004241249825 | 2345 |
| 4242 | 3004242959255 | 2345 |
| 4243 | 3004243647242 | 2346 |
| 4244 | 3004244814233 | 2346 |
| 4245 | 3004245064661 | 2347 |
| 4246 | 3004246663147 | 2347 |
| 4247 | 3004247459833 | 2347 |
| 4248 | 3004248362404 | 2349 |
| 4249 | 3004249605884 | 2350 |
| 4250 | 3004250304627 | 2354 |
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;