Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,101–2,125 of 9,842

ticket, page 85 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2101	3002101331499	1167
2102	3002102065240	1167
2103	3002103691427	1167
2104	3002104028113	1167
2105	3002105216866	1168
2106	3002106190993	1168
2107	3002107834543	1168
2108	3002108587675	1169
2109	3002109334592	1169
2110	3002110627290	1169
2111	3002111437815	1170
2112	3002112430528	1170
2113	3002113663861	1171
2114	3002114038868	1171
2115	3002115464067	1171
2116	3002116086839	1171
2117	3002117442162	1172
2118	3002118177741	1172
2119	3002119417453	1173
2120	3002120690806	1174
2121	3002121479052	1174
2122	3002122020199	1178
2123	3002123733283	1178
2124	3002124649044	1179
2125	3002125572914	1179

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;