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 751–775 of 5,412

purchase_order, page 31 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
751onlineNULLNULL7512015-10-28 12:33:59
752onlineNULLNULL7522015-10-28 21:34:03
753app_storeNULLNULL7532015-10-29 07:13:32
754app_storeNULLNULL7542015-10-30 00:01:11
755ticket_desk2NULL7552015-10-30 11:42:11
756app_storeNULLNULL7562015-10-30 18:26:09
757onlineNULLNULL7572015-10-31 07:41:09
758ticket_desk4NULL7582015-10-31 09:33:03
759ticket_desk1NULL7592015-10-31 09:50:36
760ticket_desk1NULL7602015-10-31 09:55:23
761audio_guide_deskNULL37612015-10-31 10:27:47
762audio_guide_deskNULL27622015-10-31 10:32:06
763audio_guide_deskNULL37632015-10-31 10:32:29
764onlineNULLNULL7642015-10-31 12:51:30
765app_storeNULLNULL7652015-11-01 20:37:49
766onlineNULLNULL7662015-11-01 23:35:15
767onlineNULLNULL7672015-11-02 08:28:17
768onlineNULLNULL7682015-11-02 16:16:12
769onlineNULLNULL7692015-11-02 20:37:39
770onlineNULLNULL7702015-11-03 09:51:19
771audio_guide_deskNULL17712015-11-03 10:49:43
772onlineNULLNULL7722015-11-03 16:58:36
773ticket_desk4NULL7732015-11-04 10:14:16
774onlineNULLNULL7742015-11-06 15:12:08
775app_storeNULLNULL7752015-11-06 15:32:41
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;