Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,176–1,200 of 9,842

ticket, page 48 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1176	3001176516736	643
1177	3001177627247	644
1178	3001178364047	646
1179	3001179530595	647
1180	3001180273067	647
1181	3001181856079	648
1182	3001182223154	648
1183	3001183333293	649
1184	3001184793645	649
1185	3001185793615	650
1186	3001186133852	652
1187	3001187579766	652
1188	3001188615016	653
1189	3001189428579	653
1190	3001190387991	655
1191	3001191280666	657
1192	3001192065840	657
1193	3001193167221	658
1194	3001194314438	659
1195	3001195299608	659
1196	3001196593702	661
1197	3001197759251	661
1198	3001198349000	661
1199	3001199334214	661
1200	3001200380350	663

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;