Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,351–1,375 of 9,842

ticket, page 55 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1351	3001351408244	743
1352	3001352487540	743
1353	3001353468217	744
1354	3001354606198	744
1355	3001355448589	746
1356	3001356713432	750
1357	3001357136812	751
1358	3001358109563	751
1359	3001359985555	752
1360	3001360029750	755
1361	3001361572466	757
1362	3001362174745	758
1363	3001363817794	758
1364	3001364757397	759
1365	3001365512434	759
1366	3001366862821	759
1367	3001367630570	759
1368	3001368273647	759
1369	3001369416382	760
1370	3001370481457	760
1371	3001371847248	764
1372	3001372830715	766
1373	3001373466782	767
1374	3001374718886	768
1375	3001375239625	768

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;