Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,026–5,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5026 | 3005026087170 | 2786 |
| 5027 | 3005027411796 | 2786 |
| 5028 | 3005028860412 | 2786 |
| 5029 | 3005029724316 | 2786 |
| 5030 | 3005030271553 | 2786 |
| 5031 | 3005031206480 | 2786 |
| 5032 | 3005032968187 | 2787 |
| 5033 | 3005033818543 | 2787 |
| 5034 | 3005034651675 | 2790 |
| 5035 | 3005035159334 | 2793 |
| 5036 | 3005036886981 | 2793 |
| 5037 | 3005037327625 | 2794 |
| 5038 | 3005038372082 | 2796 |
| 5039 | 3005039925038 | 2797 |
| 5040 | 3005040268661 | 2798 |
| 5041 | 3005041909556 | 2798 |
| 5042 | 3005042556659 | 2800 |
| 5043 | 3005043419134 | 2800 |
| 5044 | 3005044332513 | 2803 |
| 5045 | 3005045202363 | 2804 |
| 5046 | 3005046180846 | 2805 |
| 5047 | 3005047097169 | 2806 |
| 5048 | 3005048643479 | 2806 |
| 5049 | 3005049176968 | 2806 |
| 5050 | 3005050984093 | 2806 |
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;