Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,451–1,475 of 9,842

ticket, page 59 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1451	3001451020366	794
1452	3001452794477	794
1453	3001453734544	795
1454	3001454710978	798
1455	3001455769559	798
1456	3001456345973	799
1457	3001457748456	801
1458	3001458690819	801
1459	3001459909308	803
1460	3001460638094	803
1461	3001461925090	804
1462	3001462728131	810
1463	3001463856211	810
1464	3001464717307	810
1465	3001465426669	810
1466	3001466458224	810
1467	3001467450247	810
1468	3001468222429	810
1469	3001469527596	810
1470	3001470006026	810
1471	3001471810524	810
1472	3001472764588	810
1473	3001473053204	810
1474	3001474434937	810
1475	3001475359653	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;