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,151–4,175 of 5,412

purchase_order, page 167 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4151app_storeNULLNULL41512019-02-24 21:19:34
4152onlineNULLNULL41522019-02-25 09:38:35
4153onlineNULLNULL41532019-02-25 21:06:31
4154app_storeNULLNULL41542019-02-26 00:25:00
4155onlineNULLNULL41552019-02-26 22:07:53
4156onlineNULLNULL41562019-02-28 08:48:30
4157onlineNULLNULL41572019-02-28 11:33:56
4158onlineNULLNULL41582019-02-28 17:19:08
4159app_storeNULLNULL41592019-03-01 17:06:59
4160onlineNULLNULL41602019-03-01 21:19:45
4161ticket_desk5NULL41612019-03-02 10:31:58
4162audio_guide_deskNULL141622019-03-02 10:48:38
4163audio_guide_deskNULL241632019-03-02 10:49:06
4164app_storeNULLNULL41642019-03-02 20:56:11
4165onlineNULLNULL41652019-03-02 23:55:36
4166audio_guide_deskNULL241662019-03-03 12:51:49
4167onlineNULLNULL41672019-03-03 19:10:55
4168onlineNULLNULL41682019-03-03 21:49:02
4169onlineNULLNULL41692019-03-05 07:06:13
4170onlineNULLNULL41702019-03-05 08:28:18
4171onlineNULLNULL41712019-03-05 11:10:38
4172ticket_desk4NULL41722019-03-05 11:23:26
4173onlineNULLNULL41732019-03-05 13:24:10
4174app_storeNULLNULL41742019-03-06 07:45:06
4175onlineNULLNULL41752019-03-06 08:50:28
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;