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,076–4,100 of 5,412

purchase_order, page 164 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4076onlineNULLNULL40762019-01-30 16:42:42
4077app_storeNULLNULL40772019-01-31 01:37:39
4078onlineNULLNULL40782019-01-31 12:13:23
4079onlineNULLNULL40792019-01-31 13:45:59
4080onlineNULLNULL40802019-02-01 10:31:08
4081onlineNULLNULL40812019-02-01 16:38:55
4082ticket_desk2NULL40822019-02-02 15:23:14
4083audio_guide_deskNULL240832019-02-02 16:14:44
4084onlineNULLNULL40842019-02-02 19:32:27
4085app_storeNULLNULL40852019-02-03 04:28:35
4086audio_guide_deskNULL240862019-02-03 12:18:36
4087onlineNULLNULL40872019-02-04 07:44:51
4088ticket_desk3NULL40882019-02-04 10:43:37
4089onlineNULLNULL40892019-02-04 16:46:14
4090ticket_desk4NULL40902019-02-05 11:48:03
4091onlineNULLNULL40912019-02-05 12:03:14
4092app_storeNULLNULL40922019-02-06 16:55:39
4093onlineNULLNULL40932019-02-06 17:08:05
4094onlineNULLNULL40942019-02-06 20:36:48
4095onlineNULLNULL40952019-02-07 08:29:21
4096app_storeNULLNULL40962019-02-07 08:59:15
4097onlineNULLNULL40972019-02-07 10:37:41
4098app_storeNULLNULL40982019-02-07 16:04:08
4099app_storeNULLNULL40992019-02-08 11:18:05
4100onlineNULLNULL41002019-02-08 11:18:59
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;