Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,576–1,600 of 9,842

ticket, page 64 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1576	3001576113991	864
1577	3001577449558	864
1578	3001578883511	868
1579	3001579162081	871
1580	3001580739623	872
1581	3001581230034	873
1582	3001582905525	875
1583	3001583229953	876
1584	3001584267374	876
1585	3001585598446	877
1586	3001586948379	878
1587	3001587953866	878
1588	3001588093833	878
1589	3001589556473	878
1590	3001590130994	880
1591	3001591281350	882
1592	3001592651453	882
1593	3001593331015	882
1594	3001594303704	883
1595	3001595315548	883
1596	3001596911036	883
1597	3001597779022	883
1598	3001598105009	884
1599	3001599516125	885
1600	3001600828647	885

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;