Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,951–1,975 of 9,842

ticket, page 79 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1951	3001951531193	1056
1952	3001952312913	1056
1953	3001953453334	1056
1954	3001954405859	1056
1955	3001955405452	1058
1956	3001956580320	1058
1957	3001957672872	1059
1958	3001958622269	1059
1959	3001959201703	1063
1960	3001960454462	1064
1961	3001961072727	1064
1962	3001962760261	1064
1963	3001963948984	1064
1964	3001964064901	1065
1965	3001965700015	1066
1966	3001966825932	1066
1967	3001967344009	1067
1968	3001968478155	1067
1969	3001969757882	1070
1970	3001970469217	1070
1971	3001971396818	1070
1972	3001972640310	1070
1973	3001973884464	1071
1974	3001974978071	1071
1975	3001975604848	1071

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;