Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,776–4,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4776 | 3004776422555 | 2624 |
| 4777 | 3004777315531 | 2624 |
| 4778 | 3004778644797 | 2624 |
| 4779 | 3004779686521 | 2624 |
| 4780 | 3004780102042 | 2625 |
| 4781 | 3004781633520 | 2626 |
| 4782 | 3004782730869 | 2627 |
| 4783 | 3004783100710 | 2627 |
| 4784 | 3004784087000 | 2627 |
| 4785 | 3004785305492 | 2628 |
| 4786 | 3004786101201 | 2628 |
| 4787 | 3004787512512 | 2630 |
| 4788 | 3004788489535 | 2630 |
| 4789 | 3004789103756 | 2630 |
| 4790 | 3004790993054 | 2631 |
| 4791 | 3004791701197 | 2631 |
| 4792 | 3004792865885 | 2631 |
| 4793 | 3004793813135 | 2631 |
| 4794 | 3004794353315 | 2632 |
| 4795 | 3004795352662 | 2633 |
| 4796 | 3004796049152 | 2633 |
| 4797 | 3004797028371 | 2634 |
| 4798 | 3004798501813 | 2634 |
| 4799 | 3004799753614 | 2635 |
| 4800 | 3004800425443 | 2636 |
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;