Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 151–175 of 9,842

ticket, page 7 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
151	3000151746073	51
152	3000152667462	51
153	3000153415175	51
154	3000154039278	51
155	3000155571940	51
156	3000156863803	51
157	3000157686215	52
158	3000158793205	52
159	3000159693240	52
160	3000160523016	52
161	3000161573729	52
162	3000162903583	54
163	3000163081440	55
164	3000164058383	55
165	3000165130923	56
166	3000166997107	57
167	3000167661280	57
168	3000168856150	57
169	3000169727531	57
170	3000170778018	58
171	3000171272112	58
172	3000172398843	59
173	3000173768553	59
174	3000174044235	59
175	3000175740927	59

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;