Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,476–1,500 of 9,842

ticket, page 60 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1476	3001476017553	810
1477	3001477423122	810
1478	3001478880306	810
1479	3001479757498	810
1480	3001480795820	810
1481	3001481129275	810
1482	3001482277323	810
1483	3001483966253	810
1484	3001484966164	810
1485	3001485997223	810
1486	3001486147659	810
1487	3001487908054	810
1488	3001488992136	810
1489	3001489739279	810
1490	3001490047642	810
1491	3001491652066	810
1492	3001492348594	810
1493	3001493140013	810
1494	3001494322255	810
1495	3001495310324	810
1496	3001496935279	810
1497	3001497777021	810
1498	3001498122541	810
1499	3001499744390	810
1500	3001500964439	810

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;