Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,651–3,675 of 9,842

ticket, page 147 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3651	3003651939324	2006
3652	3003652891884	2006
3653	3003653329286	2006
3654	3003654958955	2006
3655	3003655906907	2006
3656	3003656256739	2006
3657	3003657718044	2006
3658	3003658500851	2006
3659	3003659480055	2006
3660	3003660984371	2006
3661	3003661164654	2006
3662	3003662333467	2006
3663	3003663689851	2006
3664	3003664368183	2006
3665	3003665327139	2006
3666	3003666843072	2006
3667	3003667560426	2006
3668	3003668207196	2006
3669	3003669803022	2006
3670	3003670567225	2006
3671	3003671271112	2006
3672	3003672209667	2006
3673	3003673052244	2006
3674	3003674261975	2006
3675	3003675089736	2006

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;