Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,126–5,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5126 | 3005126315783 | 2821 |
| 5127 | 3005127621031 | 2824 |
| 5128 | 3005128614236 | 2824 |
| 5129 | 3005129972152 | 2826 |
| 5130 | 3005130993577 | 2827 |
| 5131 | 3005131034857 | 2827 |
| 5132 | 3005132478859 | 2828 |
| 5133 | 3005133248756 | 2828 |
| 5134 | 3005134983660 | 2830 |
| 5135 | 3005135600188 | 2830 |
| 5136 | 3005136556355 | 2832 |
| 5137 | 3005137058124 | 2832 |
| 5138 | 3005138847733 | 2833 |
| 5139 | 3005139203200 | 2833 |
| 5140 | 3005140568465 | 2834 |
| 5141 | 3005141737296 | 2834 |
| 5142 | 3005142603575 | 2836 |
| 5143 | 3005143745654 | 2836 |
| 5144 | 3005144080650 | 2836 |
| 5145 | 3005145511234 | 2836 |
| 5146 | 3005146190072 | 2839 |
| 5147 | 3005147080704 | 2839 |
| 5148 | 3005148708169 | 2840 |
| 5149 | 3005149466821 | 2840 |
| 5150 | 3005150525716 | 2843 |
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;