Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,151–2,175 of 9,842

ticket, page 87 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2151	3002151000876	1202
2152	3002152540938	1202
2153	3002153917152	1202
2154	3002154130522	1202
2155	3002155666177	1202
2156	3002156786222	1202
2157	3002157826239	1202
2158	3002158494708	1202
2159	3002159746927	1202
2160	3002160824308	1202
2161	3002161086549	1202
2162	3002162705876	1202
2163	3002163202237	1202
2164	3002164375505	1202
2165	3002165904065	1202
2166	3002166006105	1202
2167	3002167710449	1202
2168	3002168553654	1202
2169	3002169183438	1202
2170	3002170373215	1202
2171	3002171592680	1202
2172	3002172266668	1202
2173	3002173046479	1202
2174	3002174426241	1202
2175	3002175865937	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;