Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 5,401–5,425 of 9,842

ticket, page 217 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
5401	3005401729805	3000
5402	3005402377425	3000
5403	3005403812365	3000
5404	3005404480598	3000
5405	3005405283500	3000
5406	3005406055962	3000
5407	3005407424573	3000
5408	3005408733987	3000
5409	3005409387334	3000
5410	3005410534309	3000
5411	3005411622383	3000
5412	3005412003050	3000
5413	3005413542137	3000
5414	3005414792032	3000
5415	3005415239796	3000
5416	3005416035368	3000
5417	3005417768957	3000
5418	3005418434141	3000
5419	3005419545442	3000
5420	3005420623377	3000
5421	3005421159868	3000
5422	3005422777927	3000
5423	3005423867720	3000
5424	3005424725850	3000
5425	3005425957714	3000

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;