Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,401–1,425 of 9,842

ticket, page 57 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1401	3001401882152	768
1402	3001402995306	768
1403	3001403251378	768
1404	3001404872002	768
1405	3001405784709	768
1406	3001406251405	768
1407	3001407225656	768
1408	3001408346507	768
1409	3001409808792	768
1410	3001410546198	768
1411	3001411570713	768
1412	3001412811623	768
1413	3001413915027	768
1414	3001414085982	768
1415	3001415686487	768
1416	3001416625867	769
1417	3001417981667	770
1418	3001418700171	772
1419	3001419120746	772
1420	3001420100659	773
1421	3001421666606	774
1422	3001422847306	774
1423	3001423906029	774
1424	3001424223372	776
1425	3001425203353	776

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;