Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,776–1,800 of 9,842

ticket, page 72 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1776	3001776460158	980
1777	3001777778851	980
1778	3001778401104	984
1779	3001779175915	985
1780	3001780302102	985
1781	3001781503333	987
1782	3001782430526	990
1783	3001783322212	990
1784	3001784571220	990
1785	3001785707512	993
1786	3001786975858	993
1787	3001787302031	994
1788	3001788631827	995
1789	3001789572622	995
1790	3001790692630	995
1791	3001791446082	996
1792	3001792037668	996
1793	3001793790856	996
1794	3001794073146	998
1795	3001795301016	998
1796	3001796195723	998
1797	3001797505307	998
1798	3001798220772	1001
1799	3001799864252	1002
1800	3001800990852	1002

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;