Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 951–975 of 9,842

ticket, page 39 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
951	3000951209243	516
952	3000952577168	516
953	3000953312001	518
954	3000954303976	518
955	3000955663299	521
956	3000956588467	521
957	3000957954070	521
958	3000958987670	523
959	3000959508403	523
960	3000960750833	523
961	3000961629039	523
962	3000962699683	524
963	3000963669517	526
964	3000964321607	527
965	3000965091253	528
966	3000966707785	528
967	3000967611161	528
968	3000968412120	529
969	3000969833258	529
970	3000970678812	529
971	3000971504734	531
972	3000972030732	533
973	3000973192841	533
974	3000974414648	534
975	3000975842761	536

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;