Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

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

ticket, page 45 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1101	3001101514271	634
1102	3001102088876	634
1103	3001103764530	634
1104	3001104290083	634
1105	3001105068437	634
1106	3001106930815	634
1107	3001107775617	634
1108	3001108616201	634
1109	3001109474728	634
1110	3001110119479	634
1111	3001111014353	634
1112	3001112584441	634
1113	3001113176966	634
1114	3001114617501	634
1115	3001115450272	634
1116	3001116836860	634
1117	3001117084380	634
1118	3001118303866	634
1119	3001119471598	634
1120	3001120690484	634
1121	3001121129473	634
1122	3001122888670	634
1123	3001123142720	634
1124	3001124625760	634
1125	3001125982292	634

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;