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 4,451–4,475 of 5,412

purchase_order, page 179 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4451onlineNULLNULL44512019-05-25 19:01:56
4452app_storeNULLNULL44522019-05-25 22:52:02
4453onlineNULLNULL44532019-05-26 16:24:26
4454onlineNULLNULL44542019-05-26 21:45:10
4455onlineNULLNULL44552019-05-27 08:14:33
4456audio_guide_deskNULL244562019-05-27 10:20:47
4457onlineNULLNULL44572019-05-27 11:07:57
4458onlineNULLNULL44582019-05-27 11:20:26
4459onlineNULLNULL44592019-05-27 16:52:04
4460app_storeNULLNULL44602019-05-28 01:39:53
4461onlineNULLNULL44612019-05-28 08:42:44
4462ticket_desk2NULL44622019-05-28 10:16:35
4463audio_guide_deskNULL244632019-05-28 10:48:25
4464onlineNULLNULL44642019-05-28 12:56:24
4465ticket_desk1NULL44652019-05-28 13:10:34
4466onlineNULLNULL44662019-05-28 22:33:13
4467app_storeNULLNULL44672019-05-29 17:07:15
4468app_storeNULLNULL44682019-05-29 23:17:42
4469app_storeNULLNULL44692019-05-30 03:45:42
4470onlineNULLNULL44702019-05-30 08:15:57
4471onlineNULLNULL44712019-05-30 12:36:04
4472onlineNULLNULL44722019-05-30 17:37:39
4473onlineNULLNULL44732019-05-31 07:19:47
4474ticket_desk1NULL44742019-05-31 10:27:51
4475onlineNULLNULL44752019-05-31 14:34:58
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;