Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,551–1,575 of 9,842

ticket, page 63 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1551	3001551902628	847
1552	3001552537255	847
1553	3001553030500	848
1554	3001554429579	848
1555	3001555104640	851
1556	3001556277998	851
1557	3001557804111	851
1558	3001558275139	851
1559	3001559807060	852
1560	3001560640772	854
1561	3001561654682	854
1562	3001562638631	856
1563	3001563910175	856
1564	3001564510225	856
1565	3001565452362	856
1566	3001566749526	858
1567	3001567450802	860
1568	3001568333357	861
1569	3001569900523	861
1570	3001570077814	861
1571	3001571033570	861
1572	3001572202515	861
1573	3001573332203	862
1574	3001574996286	863
1575	3001575518490	864

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;