Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 526–550 of 9,842

ticket, page 22 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
526	3000526178867	226
527	3000527729413	226
528	3000528822900	226
529	3000529142771	227
530	3000530971332	227
531	3000531460668	227
532	3000532270036	228
533	3000533393860	228
534	3000534574146	228
535	3000535545247	228
536	3000536920115	228
537	3000537071394	231
538	3000538358984	232
539	3000539073478	232
540	3000540386858	233
541	3000541345589	236
542	3000542126765	236
543	3000543365089	239
544	3000544265680	239
545	3000545684637	240
546	3000546887057	242
547	3000547957982	242
548	3000548487395	243
549	3000549483437	243
550	3000550438370	244

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;