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

purchase_order, page 207 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5151onlineNULLNULL51512019-12-08 11:52:46
5152ticket_desk2NULL51522019-12-08 15:32:40
5153app_storeNULLNULL51532019-12-08 22:19:48
5154onlineNULLNULL51542019-12-09 22:46:12
5155onlineNULLNULL51552019-12-10 10:29:12
5156onlineNULLNULL51562019-12-10 10:44:31
5157audio_guide_deskNULL151572019-12-10 12:40:54
5158ticket_desk4NULL51582019-12-10 14:12:33
5159audio_guide_deskNULL251592019-12-10 14:35:04
5160audio_guide_deskNULL251602019-12-10 15:22:22
5161app_storeNULLNULL51612019-12-11 12:49:41
5162app_storeNULLNULL51622019-12-11 18:28:05
5163onlineNULLNULL51632019-12-12 18:08:38
5164onlineNULLNULL51642019-12-12 22:03:59
5165onlineNULLNULL51652019-12-13 17:24:19
5166app_storeNULLNULL51662019-12-13 19:24:55
5167onlineNULLNULL51672019-12-13 20:45:54
5168onlineNULLNULL51682019-12-14 08:44:33
5169onlineNULLNULL51692019-12-14 12:03:23
5170ticket_desk4NULL51702019-12-14 14:15:49
5171ticket_desk2NULL51712019-12-14 14:25:51
5172onlineNULLNULL51722019-12-14 15:33:33
5173app_storeNULLNULL51732019-12-15 05:09:28
5174onlineNULLNULL51742019-12-15 08:13:01
5175onlineNULLNULL51752019-12-15 14:20:55
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;