Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 101–125 of 9,842

ticket, page 5 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
101	3000101945951	34
102	3000102196889	35
103	3000103822716	38
104	3000104519704	39
105	3000105842269	39
106	3000106725528	42
107	3000107299935	44
108	3000108584133	47
109	3000109450796	47
110	3000110010922	49
111	3000111208676	49
112	3000112170268	51
113	3000113233983	51
114	3000114907563	51
115	3000115352581	51
116	3000116132711	51
117	3000117485594	51
118	3000118473124	51
119	3000119274454	51
120	3000120799578	51
121	3000121463142	51
122	3000122743626	51
123	3000123004189	51
124	3000124122630	51
125	3000125487635	51

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;