Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 901–925 of 9,842

ticket, page 37 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
901	3000901095752	481
902	3000902396085	481
903	3000903241817	482
904	3000904620163	482
905	3000905429581	483
906	3000906948225	484
907	3000907703769	486
908	3000908356159	486
909	3000909538566	486
910	3000910709183	486
911	3000911849778	488
912	3000912742312	488
913	3000913013102	489
914	3000914995104	489
915	3000915740912	490
916	3000916039439	490
917	3000917879273	490
918	3000918658045	491
919	3000919932568	492
920	3000920493642	493
921	3000921320085	493
922	3000922452301	493
923	3000923190099	493
924	3000924186126	493
925	3000925837482	495

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;