Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,501–1,525 of 9,842

ticket, page 61 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1501	3001501430488	810
1502	3001502377152	811
1503	3001503400184	812
1504	3001504632694	813
1505	3001505309158	813
1506	3001506954012	813
1507	3001507108246	815
1508	3001508796876	816
1509	3001509509603	818
1510	3001510648784	818
1511	3001511826407	818
1512	3001512696790	820
1513	3001513552603	820
1514	3001514880355	822
1515	3001515485437	823
1516	3001516972104	823
1517	3001517298248	824
1518	3001518825013	824
1519	3001519105178	824
1520	3001520565958	824
1521	3001521141105	825
1522	3001522593159	825
1523	3001523826891	826
1524	3001524705603	826
1525	3001525422774	827

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;