Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,526–1,550 of 9,842

ticket, page 62 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1526	3001526651377	827
1527	3001527849675	829
1528	3001528965617	830
1529	3001529125370	830
1530	3001530906291	834
1531	3001531244760	834
1532	3001532173593	835
1533	3001533066120	836
1534	3001534334089	836
1535	3001535722762	837
1536	3001536322940	837
1537	3001537225458	837
1538	3001538917266	837
1539	3001539750706	837
1540	3001540732153	838
1541	3001541018276	839
1542	3001542309097	839
1543	3001543783014	840
1544	3001544486582	841
1545	3001545178694	841
1546	3001546879023	842
1547	3001547123460	842
1548	3001548757678	842
1549	3001549643424	845
1550	3001550767152	846

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;