Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 5,326–5,350 of 9,842

ticket, page 214 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
5326	3005326819850	2957
5327	3005327986249	2957
5328	3005328899852	2957
5329	3005329326106	2958
5330	3005330680335	2958
5331	3005331886725	2958
5332	3005332184984	2958
5333	3005333596687	2960
5334	3005334498642	2962
5335	3005335508503	2963
5336	3005336891874	2963
5337	3005337176541	2966
5338	3005338362794	2966
5339	3005339572289	2968
5340	3005340725736	2972
5341	3005341936741	2972
5342	3005342851443	2972
5343	3005343571601	2972
5344	3005344788022	2973
5345	3005345526463	2973
5346	3005346284494	2973
5347	3005347017948	2976
5348	3005348237341	2976
5349	3005349225434	2978
5350	3005350527440	2980

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;