Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 676–700 of 9,842

ticket, page 28 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
676	3000676394401	317
677	3000677608676	317
678	3000678186716	317
679	3000679466800	318
680	3000680146600	318
681	3000681278856	319
682	3000682046365	319
683	3000683550422	319
684	3000684884333	321
685	3000685275999	321
686	3000686726385	324
687	3000687056883	324
688	3000688265996	328
689	3000689684493	328
690	3000690276686	328
691	3000691087559	328
692	3000692946025	329
693	3000693011780	330
694	3000694422086	330
695	3000695313216	331
696	3000696751878	331
697	3000697034133	333
698	3000698858251	333
699	3000699868399	333
700	3000700682609	333

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;