Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,976–5,000 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4976 | 3004976332305 | 2778 |
| 4977 | 3004977851102 | 2778 |
| 4978 | 3004978749322 | 2778 |
| 4979 | 3004979754189 | 2779 |
| 4980 | 3004980407494 | 2779 |
| 4981 | 3004981432660 | 2780 |
| 4982 | 3004982878516 | 2780 |
| 4983 | 3004983895678 | 2780 |
| 4984 | 3004984425869 | 2780 |
| 4985 | 3004985876089 | 2780 |
| 4986 | 3004986648097 | 2781 |
| 4987 | 3004987000984 | 2781 |
| 4988 | 3004988620615 | 2782 |
| 4989 | 3004989163413 | 2782 |
| 4990 | 3004990075697 | 2784 |
| 4991 | 3004991968436 | 2784 |
| 4992 | 3004992640016 | 2785 |
| 4993 | 3004993733762 | 2786 |
| 4994 | 3004994068761 | 2786 |
| 4995 | 3004995563294 | 2786 |
| 4996 | 3004996745202 | 2786 |
| 4997 | 3004997376771 | 2786 |
| 4998 | 3004998791652 | 2786 |
| 4999 | 3004999710568 | 2786 |
| 5000 | 3005000574586 | 2786 |
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;