Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,126–2,150 of 9,842

ticket, page 86 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2126	3002126420663	1181
2127	3002127412182	1181
2128	3002128562490	1183
2129	3002129749296	1183
2130	3002130708522	1183
2131	3002131155742	1184
2132	3002132114149	1184
2133	3002133901232	1185
2134	3002134162205	1185
2135	3002135354977	1186
2136	3002136866116	1187
2137	3002137435512	1188
2138	3002138425455	1188
2139	3002139538246	1189
2140	3002140510772	1194
2141	3002141352369	1194
2142	3002142247214	1194
2143	3002143769279	1197
2144	3002144444469	1198
2145	3002145708880	1200
2146	3002146981042	1202
2147	3002147434110	1202
2148	3002148870406	1202
2149	3002149758415	1202
2150	3002150721262	1202

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;