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 2,051–2,075 of 5,412

purchase_order, page 83 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
2051onlineNULLNULL20512017-04-10 14:50:03
2052app_storeNULLNULL20522017-04-10 15:32:58
2053onlineNULLNULL20532017-04-10 19:48:29
2054ticket_desk2NULL20542017-04-11 11:20:51
2055audio_guide_deskNULL320552017-04-11 11:48:26
2056onlineNULLNULL20562017-04-11 14:06:08
2057onlineNULLNULL20572017-04-11 15:07:57
2058onlineNULLNULL20582017-04-11 18:46:06
2059onlineNULLNULL20592017-04-12 09:34:56
2060onlineNULLNULL20602017-04-12 10:09:24
2061audio_guide_deskNULL220612017-04-12 12:12:49
2062ticket_desk1NULL20622017-04-12 14:34:46
2063onlineNULLNULL20632017-04-12 20:07:09
2064audio_guide_deskNULL220642017-04-13 13:21:08
2065app_storeNULLNULL20652017-04-13 18:50:50
2066onlineNULLNULL20662017-04-13 19:01:26
2067ticket_desk2NULL20672017-04-14 10:40:56
2068audio_guide_deskNULL220682017-04-14 11:40:10
2069onlineNULLNULL20692017-04-14 12:27:47
2070onlineNULLNULL20702017-04-14 19:20:52
2071onlineNULLNULL20712017-04-15 07:07:41
2072app_storeNULLNULL20722017-04-16 02:08:35
2073audio_guide_deskNULL220732017-04-16 12:17:08
2074onlineNULLNULL20742017-04-16 15:51:14
2075onlineNULLNULL20752017-04-16 21:49:39
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;