Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,126–1,150 of 9,842

ticket, page 46 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1126	3001126576073	635
1127	3001127977953	635
1128	3001128845733	636
1129	3001129328594	636
1130	3001130848270	637
1131	3001131531876	637
1132	3001132459699	639
1133	3001133527333	639
1134	3001134080674	642
1135	3001135188178	642
1136	3001136313920	642
1137	3001137751726	642
1138	3001138203059	642
1139	3001139029473	642
1140	3001140715510	642
1141	3001141529859	642
1142	3001142110746	642
1143	3001143171094	642
1144	3001144494839	642
1145	3001145512904	642
1146	3001146886875	642
1147	3001147053549	642
1148	3001148127814	642
1149	3001149663463	642
1150	3001150379969	642

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;