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 5,376–5,400 of 5,412

purchase_order, page 216 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5376audio_guide_deskNULL253762020-02-10 15:59:47
5377audio_guide_deskNULL253772020-02-11 10:31:09
5378onlineNULLNULL53782020-02-11 15:50:18
5379app_storeNULLNULL53792020-02-11 18:43:00
5380app_storeNULLNULL53802020-02-11 23:42:38
5381app_storeNULLNULL53812020-02-13 08:11:54
5382onlineNULLNULL53822020-02-13 11:34:21
5383audio_guide_deskNULL253832020-02-13 14:02:35
5384onlineNULLNULL53842020-02-13 16:48:23
5385ticket_desk2NULL53852020-02-15 09:27:25
5386onlineNULLNULL53862020-02-15 14:36:36
5387onlineNULLNULL53872020-02-16 07:55:03
5388onlineNULLNULL53882020-02-16 12:36:10
5389onlineNULLNULL53892020-02-16 14:42:43
5390ticket_desk3NULL53902020-02-16 14:49:01
5391onlineNULLNULL53912020-02-17 09:00:42
5392audio_guide_deskNULL253922020-02-17 11:55:27
5393ticket_desk1NULL53932020-02-17 13:21:28
5394onlineNULLNULL53942020-02-17 15:57:05
5395audio_guide_deskNULL153952020-02-18 14:21:08
5396app_storeNULLNULL53962020-02-18 15:14:57
5397onlineNULLNULL53972020-02-18 15:32:05
5398onlineNULLNULL53982020-02-19 10:06:37
5399onlineNULLNULL53992020-02-20 09:07:49
5400onlineNULLNULL54002020-02-20 14:00:09
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;