Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,301–1,325 of 9,842

ticket, page 53 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1301	3001301229502	709
1302	3001302445605	709
1303	3001303359486	709
1304	3001304295596	710
1305	3001305467080	710
1306	3001306090371	710
1307	3001307982039	712
1308	3001308209937	712
1309	3001309247600	713
1310	3001310393888	713
1311	3001311008094	713
1312	3001312018680	713
1313	3001313561675	714
1314	3001314215398	714
1315	3001315668440	717
1316	3001316693367	717
1317	3001317096534	719
1318	3001318807447	719
1319	3001319634166	719
1320	3001320501239	720
1321	3001321138845	720
1322	3001322195689	721
1323	3001323647371	721
1324	3001324706691	722
1325	3001325135843	723

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;