Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,001–1,025 of 9,842

ticket, page 41 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1001	3001001867747	555
1002	3001002538603	555
1003	3001003605888	555
1004	3001004573267	555
1005	3001005354092	558
1006	3001006163348	558
1007	3001007751402	558
1008	3001008931252	558
1009	3001009446775	559
1010	3001010426412	559
1011	3001011184317	560
1012	3001012745575	560
1013	3001013932713	560
1014	3001014762757	560
1015	3001015009720	561
1016	3001016340984	562
1017	3001017486248	562
1018	3001018201010	562
1019	3001019837268	562
1020	3001020720423	566
1021	3001021484746	566
1022	3001022936687	567
1023	3001023682137	568
1024	3001024552311	568
1025	3001025562189	568

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;