Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 926–950 of 9,842

ticket, page 38 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
926	3000926870461	497
927	3000927593988	498
928	3000928975027	500
929	3000929895653	502
930	3000930108768	502
931	3000931206646	502
932	3000932333981	504
933	3000933569475	504
934	3000934255203	505
935	3000935396857	505
936	3000936142426	505
937	3000937834449	505
938	3000938458964	506
939	3000939662009	506
940	3000940606569	508
941	3000941768445	510
942	3000942679766	510
943	3000943557024	510
944	3000944734587	511
945	3000945010617	512
946	3000946519564	512
947	3000947384856	513
948	3000948005506	513
949	3000949468139	515
950	3000950779569	515

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;