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,776–4,800 of 5,412

purchase_order, page 192 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4776onlineNULLNULL47762019-08-15 20:51:01
4777onlineNULLNULL47772019-08-15 21:12:42
4778onlineNULLNULL47782019-08-16 12:14:32
4779audio_guide_deskNULL247792019-08-16 14:28:34
4780app_storeNULLNULL47802019-08-17 13:21:27
4781onlineNULLNULL47812019-08-18 08:22:43
4782audio_guide_deskNULL147822019-08-18 10:59:19
4783ticket_desk2NULL47832019-08-18 11:04:24
4784onlineNULLNULL47842019-08-19 09:49:40
4785ticket_desk2NULL47852019-08-19 10:27:15
4786ticket_desk2NULL47862019-08-19 12:49:30
4787app_storeNULLNULL47872019-08-20 01:36:04
4788onlineNULLNULL47882019-08-20 12:11:27
4789app_storeNULLNULL47892019-08-20 12:32:04
4790onlineNULLNULL47902019-08-20 13:34:35
4791audio_guide_deskNULL147912019-08-21 10:24:17
4792app_storeNULLNULL47922019-08-21 18:57:48
4793onlineNULLNULL47932019-08-22 09:05:21
4794onlineNULLNULL47942019-08-22 13:26:17
4795ticket_desk1NULL47952019-08-22 14:33:22
4796onlineNULLNULL47962019-08-22 22:24:59
4797onlineNULLNULL47972019-08-23 08:10:50
4798ticket_desk1NULL47982019-08-23 09:51:06
4799onlineNULLNULL47992019-08-23 21:53:29
4800app_storeNULLNULL48002019-08-24 01:27:51
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;