Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 7,226–7,250 of 9,842

ticket, page 290 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
7226	3007226318713	3942
7227	3007227668789	3942
7228	3007228970538	3942
7229	3007229979246	3942
7230	3007230095908	3942
7231	3007231700592	3943
7232	3007232531988	3943
7233	3007233881987	3945
7234	3007234281969	3945
7235	3007235657012	3945
7236	3007236497142	3945
7237	3007237710099	3946
7238	3007238594045	3946
7239	3007239108215	3946
7240	3007240312828	3946
7241	3007241054250	3947
7242	3007242775760	3947
7243	3007243076901	3948
7244	3007244145378	3948
7245	3007245322973	3948
7246	3007246905662	3948
7247	3007247451196	3953
7248	3007248437091	3954
7249	3007249952749	3954
7250	3007250452896	3956

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;