Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 51–75 of 9,842

ticket, page 3 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
51	3000051905688	5
52	3000052769603	5
53	3000053250765	5
54	3000054470912	5
55	3000055668010	5
56	3000056811477	5
57	3000057181049	5
58	3000058767530	5
59	3000059141878	5
60	3000060841140	5
61	3000061673957	5
62	3000062004789	5
63	3000063547809	5
64	3000064385741	5
65	3000065161105	5
66	3000066232510	6
67	3000067876500	6
68	3000068068939	7
69	3000069098606	7
70	3000070534157	7
71	3000071285931	7
72	3000072880816	9
73	3000073600568	12
74	3000074316040	12
75	3000075892004	13

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;