Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 5,376–5,400 of 9,842

ticket, page 216 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
5376	3005376957696	2997
5377	3005377607119	3000
5378	3005378087466	3000
5379	3005379970891	3000
5380	3005380879151	3000
5381	3005381541110	3000
5382	3005382900043	3000
5383	3005383880010	3000
5384	3005384721350	3000
5385	3005385541550	3000
5386	3005386615150	3000
5387	3005387670279	3000
5388	3005388016902	3000
5389	3005389826453	3000
5390	3005390759375	3000
5391	3005391913695	3000
5392	3005392923039	3000
5393	3005393163016	3000
5394	3005394718216	3000
5395	3005395238784	3000
5396	3005396669529	3000
5397	3005397502912	3000
5398	3005398361336	3000
5399	3005399085318	3000
5400	3005400704226	3000

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;