Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 9,826–9,842 of 9,842

ticket, page 394 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
9826	3009826835569	5397
9827	3009827482433	5397
9828	3009828186216	5398
9829	3009829829609	5398
9830	3009830210379	5399
9831	3009831320855	5400
9832	3009832200261	5400
9833	3009833998919	5401
9834	3009834767447	5401
9835	3009835365898	5401
9836	3009836192938	5403
9837	3009837211735	5408
9838	3009838697870	5409
9839	3009839617287	5409
9840	3009840230686	5410
9841	3009841440520	5410
9842	3009842265563	5410

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;