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 3,176–3,200 of 5,412

purchase_order, page 128 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3176onlineNULLNULL31762018-05-05 07:52:12
3177ticket_desk1NULL31772018-05-05 09:32:51
3178audio_guide_deskNULL231782018-05-05 09:50:00
3179ticket_desk1NULL31792018-05-05 09:52:58
3180audio_guide_deskNULL231802018-05-05 10:30:09
3181app_storeNULLNULL31812018-05-05 12:37:32
3182ticket_desk1NULL31822018-05-06 09:24:34
3183ticket_desk1NULL31832018-05-06 09:32:44
3184audio_guide_deskNULL231842018-05-06 10:06:45
3185audio_guide_deskNULL231852018-05-06 10:27:40
3186onlineNULLNULL31862018-05-06 13:42:28
3187onlineNULLNULL31872018-05-08 10:21:00
3188ticket_desk1NULL31882018-05-08 11:01:12
3189onlineNULLNULL31892018-05-08 11:47:34
3190ticket_desk2NULL31902018-05-09 13:24:03
3191onlineNULLNULL31912018-05-10 09:59:42
3192onlineNULLNULL31922018-05-10 12:29:48
3193onlineNULLNULL31932018-05-10 21:50:12
3194onlineNULLNULL31942018-05-11 17:58:54
3195app_storeNULLNULL31952018-05-12 08:42:20
3196onlineNULLNULL31962018-05-12 09:12:29
3197ticket_desk4NULL31972018-05-12 11:27:25
3198onlineNULLNULL31982018-05-12 11:40:52
3199onlineNULLNULL31992018-05-12 13:27:23
3200ticket_desk1NULL32002018-05-12 15:30:19
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;