Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,476–8,500 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8476 | 3008476357205 | 4591 |
| 8477 | 3008477746648 | 4591 |
| 8478 | 3008478977848 | 4591 |
| 8479 | 3008479191718 | 4591 |
| 8480 | 3008480782356 | 4591 |
| 8481 | 3008481664569 | 4591 |
| 8482 | 3008482173822 | 4591 |
| 8483 | 3008483416830 | 4591 |
| 8484 | 3008484841118 | 4591 |
| 8485 | 3008485282625 | 4591 |
| 8486 | 3008486651100 | 4591 |
| 8487 | 3008487990480 | 4591 |
| 8488 | 3008488898871 | 4591 |
| 8489 | 3008489544934 | 4591 |
| 8490 | 3008490239722 | 4591 |
| 8491 | 3008491891535 | 4591 |
| 8492 | 3008492213338 | 4591 |
| 8493 | 3008493985585 | 4591 |
| 8494 | 3008494210990 | 4592 |
| 8495 | 3008495157153 | 4592 |
| 8496 | 3008496638083 | 4595 |
| 8497 | 3008497959760 | 4596 |
| 8498 | 3008498925184 | 4596 |
| 8499 | 3008499968061 | 4596 |
| 8500 | 3008500051787 | 4597 |
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;