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 1,051–1,075 of 1,085

audio_guide_hire, page 43 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
10519626D127T102L7940A935241fr32019-12-30 12:09:2432019-12-30 12:56:27
10529604D710U525C8071V725250it22020-01-04 10:24:5922020-01-04 11:33:14
10539632D413Q817Y7694B715257en12020-01-06 15:11:1212020-01-06 16:35:45
10549646D952G324M2778N965261en22020-01-07 10:43:0422020-01-07 14:19:38
10559649D034Y265X8016K495270fr22020-01-09 15:41:5822020-01-09 18:10:00
10569648D689M436C2815G775271it22020-01-09 15:59:4222020-01-09 17:53:27
10579650D736D252Z3041D495277fr22020-01-12 15:49:0212020-01-12 17:51:42
10589677D831V786T8186E005289en22020-01-18 09:27:5622020-01-18 12:22:00
10599697D910N244E8046F155292pt22020-01-18 12:40:2932020-01-18 14:28:54
10609694D347B753W8220U055294fr32020-01-18 15:07:2332020-01-18 17:55:35
10619693D130X023V8765P415295fr32020-01-18 15:21:2932020-01-18 17:22:32
10629711D611Q961Z6085N965305en32020-01-22 10:08:3632020-01-22 11:45:08
10639698D186L149Z2216U435306en22020-01-22 10:56:0722020-01-22 12:12:41
10649713D265V521D1968K755308zh12020-01-22 14:41:3512020-01-22 16:06:22
10659664D558F571V1033X915312en32020-01-23 13:45:4612020-01-23 14:51:46
10669721D413Q817Y7694B715314en22020-01-23 14:47:4322020-01-23 16:14:39
10679724D845W425F3685F625329zh12020-01-29 11:19:0012020-01-29 12:34:13
10689723D831V786T8186E005330zh12020-01-29 11:32:1812020-01-29 13:24:34
10699741D510H421W1552A285336zh22020-01-31 12:51:4122020-01-31 13:52:52
10709708D601B335Z9665H815340en22020-02-01 11:46:4232020-02-01 13:40:35
10719760D736D252Z3041D495348es22020-02-02 11:02:2012020-02-02 12:34:29
10729762D477K685J7558W945349pl32020-02-02 12:56:1932020-02-02 14:29:47
10739761D127T102L7940A935350pl22020-02-02 13:06:3932020-02-02 14:29:03
10749764D004U524E2632P535352zh32020-02-02 16:41:0132020-02-02 18:10:00
10759763D607F479P4765P375353zh32020-02-02 16:45:4432020-02-02 18:10:00
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;