Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,851–1,875 of 9,842

ticket, page 75 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1851	3001851397502	1030
1852	3001852033698	1031
1853	3001853735406	1031
1854	3001854870271	1034
1855	3001855017028	1034
1856	3001856965973	1036
1857	3001857275069	1036
1858	3001858687035	1036
1859	3001859968187	1038
1860	3001860181246	1038
1861	3001861111896	1038
1862	3001862734866	1038
1863	3001863273428	1038
1864	3001864763762	1039
1865	3001865114615	1039
1866	3001866264509	1042
1867	3001867397086	1042
1868	3001868215008	1043
1869	3001869322746	1043
1870	3001870707546	1043
1871	3001871291210	1043
1872	3001872685444	1043
1873	3001873235773	1044
1874	3001874416269	1044
1875	3001875604804	1044

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;