Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,626–2,650 of 9,842

ticket, page 106 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2626	3002626351656	1492
2627	3002627809801	1492
2628	3002628393745	1493
2629	3002629110920	1494
2630	3002630319258	1494
2631	3002631097355	1496
2632	3002632139743	1496
2633	3002633777325	1496
2634	3002634528544	1498
2635	3002635996930	1498
2636	3002636768068	1498
2637	3002637585028	1498
2638	3002638991895	1498
2639	3002639115601	1499
2640	3002640420139	1499
2641	3002641023012	1499
2642	3002642802225	1499
2643	3002643923197	1501
2644	3002644841929	1501
2645	3002645174265	1501
2646	3002646505599	1501
2647	3002647493520	1501
2648	3002648679289	1504
2649	3002649885458	1504
2650	3002650943759	1504

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;