Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,051–1,075 of 9,842

ticket, page 43 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1051	3001051946495	591
1052	3001052801356	596
1053	3001053921876	596
1054	3001054240914	596
1055	3001055765264	597
1056	3001056028933	598
1057	3001057024615	598
1058	3001058462720	600
1059	3001059034787	600
1060	3001060102568	600
1061	3001061006786	600
1062	3001062466702	601
1063	3001063259540	601
1064	3001064322257	602
1065	3001065205386	604
1066	3001066043042	604
1067	3001067320154	609
1068	3001068054801	612
1069	3001069572226	613
1070	3001070679034	616
1071	3001071305988	616
1072	3001072406231	617
1073	3001073924612	617
1074	3001074461803	620
1075	3001075337908	620

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;