Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 4,001–4,025 of 9,842

ticket, page 161 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
4001	3004001616242	2218
4002	3004002457848	2221
4003	3004003436418	2222
4004	3004004835857	2225
4005	3004005914510	2226
4006	3004006159076	2226
4007	3004007053247	2227
4008	3004008149976	2227
4009	3004009556871	2228
4010	3004010018991	2228
4011	3004011878609	2230
4012	3004012682178	2230
4013	3004013165193	2230
4014	3004014058254	2230
4015	3004015798273	2230
4016	3004016564082	2232
4017	3004017993051	2233
4018	3004018378426	2234
4019	3004019669458	2234
4020	3004020347649	2234
4021	3004021910469	2234
4022	3004022336058	2234
4023	3004023471143	2235
4024	3004024312267	2235
4025	3004025278006	2236

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;