Skip to content
Louvre Ops DB

Table

purchase_order

One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.

Replaces in 2020: Invoices

Download CSV Query in playground

Rows 676–700 of 5,412

purchase_order, page 28 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
676audio_guide_deskNULL36762015-09-27 13:23:22
677app_storeNULLNULL6772015-09-28 12:49:33
678onlineNULLNULL6782015-09-28 21:39:26
679onlineNULLNULL6792015-09-29 07:20:35
680onlineNULLNULL6802015-09-30 11:20:43
681ticket_desk4NULL6812015-09-30 11:56:49
682audio_guide_deskNULL26822015-09-30 12:36:08
683ticket_desk2NULL6832015-10-01 11:13:54
684audio_guide_deskNULL26842015-10-01 11:41:39
685onlineNULLNULL6852015-10-01 16:57:45
686app_storeNULLNULL6862015-10-01 20:53:41
687onlineNULLNULL6872015-10-02 07:47:11
688ticket_desk1NULL6882015-10-02 08:53:12
689audio_guide_deskNULL16892015-10-02 09:27:06
690ticket_desk1NULL6902015-10-02 12:39:07
691ticket_desk2NULL6912015-10-02 13:08:16
692ticket_desk1NULL6922015-10-02 14:39:51
693audio_guide_deskNULL26932015-10-02 15:00:29
694audio_guide_deskNULL26942015-10-02 15:29:13
695audio_guide_deskNULL36952015-10-04 10:48:21
696onlineNULLNULL6962015-10-04 11:56:43
697ticket_desk5NULL6972015-10-04 12:38:58
698audio_guide_deskNULL26982015-10-04 13:07:01
699app_storeNULLNULL6992015-10-04 19:14:56
700app_storeNULLNULL7002015-10-04 23:39:17
Table definition
CREATE TABLE purchase_order (
  order_id    INTEGER PRIMARY KEY,
  channel     TEXT NOT NULL
              CHECK (channel IN ('online', 'ticket_desk', 'audio_guide_desk', 'app_store')),
  entrance_id INTEGER REFERENCES entrance (entrance_id),
  wing_id     INTEGER REFERENCES wing (wing_id),
  payment_id  INTEGER NOT NULL UNIQUE REFERENCES payment (payment_id),
  ordered_at  TEXT NOT NULL,
  CHECK ((channel = 'ticket_desk') = (entrance_id IS NOT NULL)),
  CHECK ((channel = 'audio_guide_desk') = (wing_id IS NOT NULL))
) STRICT;