Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 6,751–6,775 of 9,842

ticket, page 271 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
6751	3006751845820	3696
6752	3006752392028	3697
6753	3006753124286	3698
6754	3006754988060	3698
6755	3006755250735	3699
6756	3006756092944	3699
6757	3006757502310	3699
6758	3006758379553	3699
6759	3006759476325	3699
6760	3006760268815	3701
6761	3006761082312	3702
6762	3006762465486	3702
6763	3006763940780	3703
6764	3006764419499	3704
6765	3006765489281	3704
6766	3006766828651	3705
6767	3006767148752	3705
6768	3006768224975	3705
6769	3006769400188	3705
6770	3006770068304	3709
6771	3006771055262	3713
6772	3006772408695	3715
6773	3006773360367	3715
6774	3006774909391	3716
6775	3006775169675	3716

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;