Skip to content
Louvre Ops DB

Table

audio_guide_hire

Each hire: ticket, device, language, issuing and returning wing, times and payment.

Replaces in 2020: Hired Audio Guide

Download CSV Query in playground

Rows 751–775 of 1,085

audio_guide_hire, page 31 of 44
hire_idINTEGERticket_id→ ticket.ticket_idserial_number→ audio_guide_device.serial_numberorder_id→ purchase_order.order_idlanguage_code→ language.language_codeissued_wing_id→ wing.wing_idissued_atTEXTreturned_wing_id→ wing.wing_idreturned_atTEXT
7516706D948A201L8911R063665en12018-09-14 11:11:4432018-09-14 13:55:22
7526715D510H421W1552A283672en22018-09-16 12:18:2522018-09-16 14:33:00
7536722D767Q927C0149V093677en22018-09-17 11:27:2532018-09-17 14:33:02
7546726D324Z884K8486X423678en22018-09-17 11:36:2532018-09-17 13:15:57
7556708D736D252Z3041D493680en32018-09-18 11:56:0722018-09-18 13:48:02
7566731D724L458C1162U173683zh12018-09-18 16:05:5812018-09-18 17:36:32
7576734D130X023V8765P413685fr22018-09-19 12:02:1622018-09-19 13:03:30
7586701D611Q961Z6085N963686en12018-09-19 12:10:3322018-09-19 15:36:47
7596748D841H941H0791Q123694en32018-09-23 14:15:3022018-09-23 16:05:10
7606746D767Q927C0149V093695en32018-09-23 14:16:5612018-09-23 16:36:51
7616743D841H941H0791Q123700zh22018-09-25 11:15:3322018-09-25 12:36:33
7626768D413Q817Y7694B713706fr22018-09-26 09:08:4132018-09-26 10:00:19
7636764D570K624F8858E763707en32018-09-26 09:57:1432018-09-26 11:49:11
7646750D736D252Z3041D493708en12018-09-26 10:50:4832018-09-26 12:02:35
7656770D561K998R8427R263710en22018-09-26 11:48:5132018-09-26 14:42:46
7666624D388J554M7671Q583714en12018-09-27 11:01:5212018-09-27 12:08:54
7676775D607F479P4765P373717fi32018-09-28 14:39:4632018-09-28 16:06:49
7686783D127T102L7940A933727en12018-09-30 11:01:1322018-09-30 12:20:20
7696850D130X023V8765P413746en32018-10-06 09:36:0912018-10-06 11:59:05
7706853D724L458C1162U173749fr22018-10-06 10:52:2112018-10-06 13:30:14
7716858D561K998R8427R263754en22018-10-07 12:18:0412018-10-07 15:15:18
7726861D843X661P8223W213756fr12018-10-07 14:56:2932018-10-07 16:31:09
7736830D724L458C1162U173757fr22018-10-07 16:22:1132018-10-07 18:10:00
7746845D265V521D1968K753762en22018-10-09 12:52:4622018-10-09 14:40:53
7756867D561K998R8427R263763zh32018-10-09 13:03:5922018-10-09 15:13:45
Table definition
CREATE TABLE audio_guide_hire (
  hire_id          INTEGER PRIMARY KEY,
  ticket_id        INTEGER NOT NULL REFERENCES ticket (ticket_id),
  serial_number    TEXT NOT NULL REFERENCES audio_guide_device (serial_number),
  order_id         INTEGER NOT NULL UNIQUE REFERENCES purchase_order (order_id),
  language_code    TEXT NOT NULL REFERENCES language (language_code),
  issued_wing_id   INTEGER NOT NULL REFERENCES wing (wing_id),
  issued_at        TEXT NOT NULL,
  returned_wing_id INTEGER REFERENCES wing (wing_id),
  returned_at      TEXT,
  CHECK ((returned_at IS NULL) = (returned_wing_id IS NULL)),
  CHECK (returned_at IS NULL OR returned_at > issued_at)
) STRICT;