Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 6,476–6,500 of 9,842

ticket, page 260 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
6476	3006476576071	3581
6477	3006477263158	3581
6478	3006478550301	3581
6479	3006479707044	3583
6480	3006480459801	3583
6481	3006481423663	3583
6482	3006482048070	3583
6483	3006483217959	3584
6484	3006484601545	3585
6485	3006485111233	3586
6486	3006486241645	3586
6487	3006487000213	3586
6488	3006488612284	3586
6489	3006489488922	3588
6490	3006490164673	3588
6491	3006491569368	3588
6492	3006492630476	3589
6493	3006493910216	3589
6494	3006494322577	3590
6495	3006495962802	3591
6496	3006496234646	3592
6497	3006497543671	3592
6498	3006498945749	3592
6499	3006499729497	3593
6500	3006500612226	3593

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;