Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,201–2,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2201 | 3002201934180 | 1206 |
| 2202 | 3002202219229 | 1208 |
| 2203 | 3002203970311 | 1208 |
| 2204 | 3002204150336 | 1208 |
| 2205 | 3002205144400 | 1210 |
| 2206 | 3002206955202 | 1210 |
| 2207 | 3002207680866 | 1210 |
| 2208 | 3002208182976 | 1211 |
| 2209 | 3002209304230 | 1212 |
| 2210 | 3002210460477 | 1212 |
| 2211 | 3002211670409 | 1212 |
| 2212 | 3002212467690 | 1212 |
| 2213 | 3002213507031 | 1212 |
| 2214 | 3002214006326 | 1212 |
| 2215 | 3002215218028 | 1212 |
| 2216 | 3002216196180 | 1212 |
| 2217 | 3002217620170 | 1212 |
| 2218 | 3002218771121 | 1212 |
| 2219 | 3002219472367 | 1212 |
| 2220 | 3002220057441 | 1212 |
| 2221 | 3002221166057 | 1212 |
| 2222 | 3002222426279 | 1212 |
| 2223 | 3002223017078 | 1212 |
| 2224 | 3002224043827 | 1212 |
| 2225 | 3002225049754 | 1212 |
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;