Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,051–5,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5051 | 3005051661380 | 2806 |
| 5052 | 3005052460287 | 2807 |
| 5053 | 3005053416784 | 2808 |
| 5054 | 3005054996344 | 2808 |
| 5055 | 3005055309011 | 2808 |
| 5056 | 3005056754145 | 2808 |
| 5057 | 3005057658699 | 2809 |
| 5058 | 3005058662274 | 2809 |
| 5059 | 3005059935015 | 2809 |
| 5060 | 3005060982288 | 2812 |
| 5061 | 3005061506781 | 2813 |
| 5062 | 3005062363952 | 2813 |
| 5063 | 3005063306134 | 2813 |
| 5064 | 3005064238474 | 2813 |
| 5065 | 3005065971480 | 2814 |
| 5066 | 3005066620619 | 2815 |
| 5067 | 3005067280392 | 2817 |
| 5068 | 3005068875092 | 2817 |
| 5069 | 3005069235708 | 2817 |
| 5070 | 3005070320797 | 2817 |
| 5071 | 3005071237166 | 2817 |
| 5072 | 3005072572931 | 2817 |
| 5073 | 3005073643376 | 2817 |
| 5074 | 3005074821786 | 2817 |
| 5075 | 3005075371075 | 2817 |
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;