Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 726–750 of 9,842

ticket, page 30 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
726	3000726185037	359
727	3000727319908	360
728	3000728144995	361
729	3000729892621	361
730	3000730576037	362
731	3000731640163	362
732	3000732039338	363
733	3000733583141	364
734	3000734919657	365
735	3000735000690	365
736	3000736722215	366
737	3000737177788	367
738	3000738347128	370
739	3000739739218	370
740	3000740463295	370
741	3000741644529	371
742	3000742055162	371
743	3000743938133	372
744	3000744983634	372
745	3000745027468	373
746	3000746826780	374
747	3000747070379	375
748	3000748709934	375
749	3000749915652	376
750	3000750338384	376

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;