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,301–4,325 of 5,412

purchase_order, page 173 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4301audio_guide_deskNULL243012019-04-12 13:37:52
4302onlineNULLNULL43022019-04-12 15:04:10
4303onlineNULLNULL43032019-04-12 20:39:20
4304onlineNULLNULL43042019-04-13 09:33:49
4305audio_guide_deskNULL143052019-04-13 10:35:50
4306onlineNULLNULL43062019-04-13 12:00:13
4307onlineNULLNULL43072019-04-13 12:51:32
4308onlineNULLNULL43082019-04-14 08:39:03
4309ticket_desk2NULL43092019-04-14 09:37:12
4310audio_guide_deskNULL243102019-04-14 10:47:46
4311ticket_desk1NULL43112019-04-14 13:12:10
4312ticket_desk1NULL43122019-04-15 09:39:12
4313onlineNULLNULL43132019-04-15 11:16:55
4314app_storeNULLNULL43142019-04-15 11:51:50
4315app_storeNULLNULL43152019-04-15 13:15:51
4316onlineNULLNULL43162019-04-15 15:15:57
4317onlineNULLNULL43172019-04-15 15:37:54
4318app_storeNULLNULL43182019-04-16 00:29:31
4319ticket_desk4NULL43192019-04-16 08:53:02
4320audio_guide_deskNULL243202019-04-16 09:33:55
4321onlineNULLNULL43212019-04-16 23:06:19
4322ticket_desk1NULL43222019-04-17 10:30:28
4323ticket_desk4NULL43232019-04-17 14:59:23
4324onlineNULLNULL43242019-04-17 20:00:35
4325onlineNULLNULL43252019-04-18 09:35:53
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;