Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 976–1,000 of 9,842

ticket, page 40 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
976	3000976393460	537
977	3000977491057	537
978	3000978545343	537
979	3000979626759	538
980	3000980240603	538
981	3000981064175	538
982	3000982337463	538
983	3000983550868	539
984	3000984736980	539
985	3000985198067	541
986	3000986024412	541
987	3000987118192	543
988	3000988909865	544
989	3000989439082	545
990	3000990857065	547
991	3000991598468	548
992	3000992773262	550
993	3000993638884	550
994	3000994191088	550
995	3000995613273	550
996	3000996995097	551
997	3000997054689	551
998	3000998799196	551
999	3000999475260	553
1000	3001000709712	554

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;