Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 6,301–6,325 of 9,842

ticket, page 253 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
6301	3006301243347	3478
6302	3006302457549	3480
6303	3006303193480	3481
6304	3006304063579	3482
6305	3006305554780	3482
6306	3006306201776	3483
6307	3006307961613	3485
6308	3006308892511	3485
6309	3006309016257	3485
6310	3006310648834	3485
6311	3006311674988	3488
6312	3006312045570	3488
6313	3006313286376	3488
6314	3006314937132	3488
6315	3006315447045	3488
6316	3006316104053	3489
6317	3006317033595	3489
6318	3006318892718	3491
6319	3006319566601	3491
6320	3006320706784	3491
6321	3006321189664	3491
6322	3006322926732	3491
6323	3006323990850	3493
6324	3006324098790	3493
6325	3006325235922	3493

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;