Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 651–675 of 9,842

ticket, page 27 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
651	3000651118454	295
652	3000652633448	295
653	3000653910204	295
654	3000654356845	297
655	3000655687349	298
656	3000656873496	300
657	3000657945549	301
658	3000658036932	301
659	3000659900579	304
660	3000660379234	304
661	3000661565659	304
662	3000662195782	304
663	3000663746485	310
664	3000664576430	310
665	3000665514803	310
666	3000666143071	310
667	3000667110904	311
668	3000668072336	311
669	3000669583461	311
670	3000670840411	311
671	3000671848927	311
672	3000672548473	312
673	3000673363406	312
674	3000674039053	312
675	3000675975479	312

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;