Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,226–2,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2226 | 3002226951878 | 1212 |
| 2227 | 3002227321354 | 1212 |
| 2228 | 3002228888533 | 1212 |
| 2229 | 3002229268373 | 1212 |
| 2230 | 3002230984225 | 1212 |
| 2231 | 3002231594850 | 1212 |
| 2232 | 3002232421453 | 1212 |
| 2233 | 3002233731471 | 1212 |
| 2234 | 3002234507669 | 1212 |
| 2235 | 3002235103998 | 1212 |
| 2236 | 3002236056955 | 1212 |
| 2237 | 3002237182355 | 1212 |
| 2238 | 3002238254922 | 1212 |
| 2239 | 3002239124485 | 1212 |
| 2240 | 3002240146868 | 1212 |
| 2241 | 3002241885457 | 1213 |
| 2242 | 3002242746238 | 1213 |
| 2243 | 3002243532709 | 1213 |
| 2244 | 3002244271321 | 1213 |
| 2245 | 3002245289059 | 1214 |
| 2246 | 3002246388536 | 1215 |
| 2247 | 3002247121626 | 1215 |
| 2248 | 3002248138792 | 1216 |
| 2249 | 3002249823381 | 1217 |
| 2250 | 3002250362322 | 1217 |
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;