Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,576–4,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4576 | 3004576593533 | 2547 |
| 4577 | 3004577898559 | 2548 |
| 4578 | 3004578889970 | 2548 |
| 4579 | 3004579160180 | 2548 |
| 4580 | 3004580795872 | 2548 |
| 4581 | 3004581238843 | 2549 |
| 4582 | 3004582390747 | 2549 |
| 4583 | 3004583990994 | 2549 |
| 4584 | 3004584928989 | 2549 |
| 4585 | 3004585707380 | 2549 |
| 4586 | 3004586850552 | 2552 |
| 4587 | 3004587365930 | 2552 |
| 4588 | 3004588910778 | 2554 |
| 4589 | 3004589217234 | 2554 |
| 4590 | 3004590933990 | 2555 |
| 4591 | 3004591507372 | 2555 |
| 4592 | 3004592624737 | 2555 |
| 4593 | 3004593365233 | 2555 |
| 4594 | 3004594036821 | 2557 |
| 4595 | 3004595868118 | 2557 |
| 4596 | 3004596621182 | 2557 |
| 4597 | 3004597359477 | 2557 |
| 4598 | 3004598746089 | 2557 |
| 4599 | 3004599536347 | 2557 |
| 4600 | 3004600882754 | 2557 |
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;