Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,426–1,450 of 9,842

ticket, page 58 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1426	3001426219635	778
1427	3001427839666	779
1428	3001428856642	779
1429	3001429910411	781
1430	3001430933140	781
1431	3001431153935	781
1432	3001432267910	783
1433	3001433793643	784
1434	3001434624050	784
1435	3001435188449	784
1436	3001436919259	784
1437	3001437012139	785
1438	3001438581405	785
1439	3001439364286	785
1440	3001440340877	785
1441	3001441878642	786
1442	3001442252240	787
1443	3001443282007	787
1444	3001444130613	787
1445	3001445106616	787
1446	3001446463012	787
1447	3001447533322	788
1448	3001448892504	790
1449	3001449044527	792
1450	3001450949633	792

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;