Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 7,726–7,750 of 9,842

ticket, page 310 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
7726	3007726945199	4152
7727	3007727961321	4152
7728	3007728728446	4153
7729	3007729480454	4155
7730	3007730179679	4155
7731	3007731198699	4156
7732	3007732100383	4156
7733	3007733296536	4156
7734	3007734510287	4156
7735	3007735999674	4156
7736	3007736408644	4157
7737	3007737813691	4157
7738	3007738186556	4157
7739	3007739962885	4158
7740	3007740139577	4160
7741	3007741172925	4161
7742	3007742511215	4161
7743	3007743846919	4161
7744	3007744373502	4161
7745	3007745183854	4161
7746	3007746533001	4165
7747	3007747919350	4165
7748	3007748351611	4165
7749	3007749225836	4165
7750	3007750090575	4165

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;