Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,326–1,350 of 9,842

ticket, page 54 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1326	3001326557405	725
1327	3001327152975	725
1328	3001328895738	728
1329	3001329990134	728
1330	3001330559979	728
1331	3001331977741	730
1332	3001332744050	731
1333	3001333869365	731
1334	3001334403756	731
1335	3001335473080	731
1336	3001336453226	732
1337	3001337946698	732
1338	3001338705145	732
1339	3001339822617	734
1340	3001340862882	734
1341	3001341062632	736
1342	3001342052237	736
1343	3001343343559	736
1344	3001344333136	737
1345	3001345717814	739
1346	3001346791830	741
1347	3001347504836	741
1348	3001348191167	741
1349	3001349703284	741
1350	3001350323156	742

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;