Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 626–650 of 9,842

ticket, page 26 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
626	3000626532897	276
627	3000627897969	276
628	3000628769713	276
629	3000629961795	276
630	3000630346427	277
631	3000631639754	277
632	3000632758129	278
633	3000633309276	279
634	3000634194721	279
635	3000635280960	280
636	3000636895149	280
637	3000637129405	283
638	3000638633083	285
639	3000639634054	287
640	3000640297964	288
641	3000641778677	288
642	3000642945315	288
643	3000643406012	289
644	3000644301150	289
645	3000645241830	289
646	3000646316533	289
647	3000647938977	290
648	3000648875939	290
649	3000649976958	294
650	3000650135367	295

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;