Skip to content
Louvre Ops DB

Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Download CSV Query in playground

Rows 6,226–6,250 of 9,842

ticket, page 250 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
622630062266866193438
622730062275160373438
622830062285220833439
622930062293044793439
623030062305735853439
623130062317853563440
623230062321460993440
623330062335660643440
623430062346257453440
623530062358294073440
623630062364438143441
623730062370242043442
623830062389132163442
623930062396693833442
624030062405881993442
624130062416182053443
624230062429077073443
624330062436077433443
624430062448874123445
624530062452290473445
624630062465193863445
624730062475081183445
624830062480800363446
624930062493685363447
625030062509320753447
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;