Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 26–50 of 9,842

ticket, page 2 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
26	3000026581669	5
27	3000027516727	5
28	3000028989497	5
29	3000029724076	5
30	3000030986926	5
31	3000031002359	5
32	3000032238352	5
33	3000033552287	5
34	3000034887849	5
35	3000035194277	5
36	3000036030743	5
37	3000037401057	5
38	3000038574556	5
39	3000039846916	5
40	3000040712078	5
41	3000041349594	5
42	3000042658836	5
43	3000043913368	5
44	3000044582681	5
45	3000045967022	5
46	3000046325777	5
47	3000047936949	5
48	3000048899350	5
49	3000049759679	5
50	3000050254412	5

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;