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

audio_guide_hire, page 44 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
10769768D710U525C8071V725356it22020-02-04 09:18:0622020-02-04 12:14:21
10779767D511E829D1120P995357fr22020-02-04 09:18:0922020-02-04 11:52:59
10789750D626G044Z7549L995366en12020-02-07 13:36:4322020-02-07 15:07:38
10799731D601B335Z9665H815376fr22020-02-10 15:59:4732020-02-10 17:08:52
10809785D607F479P4765P375377en22020-02-11 10:31:0912020-02-11 13:02:02
10819796D324Z884K8486X425383en22020-02-13 14:02:3522020-02-13 15:36:08
10829691D626G044Z7549L995392zh22020-02-17 11:55:2732020-02-17 12:48:07
10839812D547F386X8659H605395fr12020-02-18 14:21:0812020-02-18 15:38:41
10849808D952G324M2778N965406ko32020-02-24 12:05:3612020-02-24 13:11:40
10859833D119M445Z8873B295407es22020-02-24 16:10:5922020-02-24 17:39:58
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;