Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,551–2,575 of 9,842

ticket, page 103 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2551	3002551059502	1434
2552	3002552753115	1434
2553	3002553376359	1434
2554	3002554513426	1434
2555	3002555457101	1435
2556	3002556583844	1435
2557	3002557125002	1437
2558	3002558900376	1437
2559	3002559769593	1438
2560	3002560112375	1440
2561	3002561991224	1441
2562	3002562557081	1442
2563	3002563442036	1443
2564	3002564005481	1444
2565	3002565977000	1445
2566	3002566868727	1445
2567	3002567597084	1445
2568	3002568774062	1446
2569	3002569482674	1446
2570	3002570709848	1447
2571	3002571692232	1447
2572	3002572265507	1448
2573	3002573084720	1448
2574	3002574779569	1448
2575	3002575166067	1450

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;