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

purchase_order, page 208 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5176audio_guide_deskNULL251762019-12-15 15:19:52
5177onlineNULLNULL51772019-12-15 20:32:00
5178app_storeNULLNULL51782019-12-16 00:14:57
5179onlineNULLNULL51792019-12-16 11:08:58
5180onlineNULLNULL51802019-12-16 12:52:32
5181onlineNULLNULL51812019-12-16 23:42:01
5182app_storeNULLNULL51822019-12-17 02:12:53
5183onlineNULLNULL51832019-12-17 07:56:58
5184app_storeNULLNULL51842019-12-17 09:36:28
5185audio_guide_deskNULL251852019-12-17 10:38:49
5186onlineNULLNULL51862019-12-17 12:14:46
5187audio_guide_deskNULL351872019-12-17 13:41:58
5188onlineNULLNULL51882019-12-18 07:30:35
5189ticket_desk1NULL51892019-12-18 10:56:59
5190onlineNULLNULL51902019-12-18 11:11:19
5191onlineNULLNULL51912019-12-18 19:27:47
5192onlineNULLNULL51922019-12-18 20:31:02
5193onlineNULLNULL51932019-12-18 22:18:19
5194audio_guide_deskNULL351942019-12-19 14:30:27
5195onlineNULLNULL51952019-12-19 14:52:36
5196onlineNULLNULL51962019-12-19 18:51:34
5197onlineNULLNULL51972019-12-20 07:33:10
5198onlineNULLNULL51982019-12-20 08:17:32
5199onlineNULLNULL51992019-12-21 10:24:13
5200audio_guide_deskNULL252002019-12-21 10:33:23
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;