Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1–25 of 9,842

ticket, page 1 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1	3000001269040	1
2	3000002031614	1
3	3000003767594	2
4	3000004530473	2
5	3000005968905	3
6	3000006341452	3
7	3000007840908	4
8	3000008553094	5
9	3000009420367	5
10	3000010252638	5
11	3000011285315	5
12	3000012564389	5
13	3000013392151	5
14	3000014787819	5
15	3000015366774	5
16	3000016526155	5
17	3000017658568	5
18	3000018181030	5
19	3000019891445	5
20	3000020056313	5
21	3000021624975	5
22	3000022381027	5
23	3000023285865	5
24	3000024899319	5
25	3000025987847	5

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;