Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 601–625 of 9,842

ticket, page 25 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
601	3000601417431	250
602	3000602365744	252
603	3000603644399	255
604	3000604750941	255
605	3000605868610	257
606	3000606560592	258
607	3000607970438	259
608	3000608976053	260
609	3000609069440	260
610	3000610958045	261
611	3000611555773	264
612	3000612141170	265
613	3000613323363	265
614	3000614824129	265
615	3000615445583	267
616	3000616712781	270
617	3000617788366	270
618	3000618174019	270
619	3000619937059	270
620	3000620927763	273
621	3000621206710	273
622	3000622993656	274
623	3000623764363	274
624	3000624703754	275
625	3000625484106	275

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;