Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,276–1,300 of 9,842

ticket, page 52 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1276	3001276542989	685
1277	3001277164991	685
1278	3001278070819	685
1279	3001279987200	687
1280	3001280735096	688
1281	3001281606234	688
1282	3001282632398	688
1283	3001283992331	688
1284	3001284374069	688
1285	3001285687583	690
1286	3001286333777	691
1287	3001287371030	692
1288	3001288182769	692
1289	3001289013361	692
1290	3001290131978	696
1291	3001291554114	697
1292	3001292961748	697
1293	3001293735745	697
1294	3001294465440	697
1295	3001295718901	701
1296	3001296196331	701
1297	3001297678262	702
1298	3001298144364	702
1299	3001299543884	707
1300	3001300016581	709

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;