Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,376–6,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6376 | 3006376041356 | 3514 |
| 6377 | 3006377699856 | 3514 |
| 6378 | 3006378149497 | 3514 |
| 6379 | 3006379972309 | 3514 |
| 6380 | 3006380267704 | 3514 |
| 6381 | 3006381205123 | 3514 |
| 6382 | 3006382244381 | 3514 |
| 6383 | 3006383754969 | 3514 |
| 6384 | 3006384946961 | 3514 |
| 6385 | 3006385168979 | 3514 |
| 6386 | 3006386029039 | 3514 |
| 6387 | 3006387642577 | 3514 |
| 6388 | 3006388613463 | 3514 |
| 6389 | 3006389234270 | 3514 |
| 6390 | 3006390380811 | 3515 |
| 6391 | 3006391836586 | 3515 |
| 6392 | 3006392377776 | 3515 |
| 6393 | 3006393742856 | 3515 |
| 6394 | 3006394856185 | 3518 |
| 6395 | 3006395571279 | 3518 |
| 6396 | 3006396544598 | 3521 |
| 6397 | 3006397754562 | 3522 |
| 6398 | 3006398471159 | 3522 |
| 6399 | 3006399539294 | 3522 |
| 6400 | 3006400211682 | 3522 |
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;