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 3,876–3,900 of 5,412

purchase_order, page 156 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3876audio_guide_deskNULL338762018-11-18 11:24:30
3877ticket_desk1NULL38772018-11-19 10:00:33
3878audio_guide_deskNULL338782018-11-19 12:37:26
3879ticket_desk2NULL38792018-11-19 14:20:50
3880audio_guide_deskNULL238802018-11-19 15:05:51
3881app_storeNULLNULL38812018-11-20 12:02:36
3882app_storeNULLNULL38822018-11-20 16:54:26
3883onlineNULLNULL38832018-11-20 21:35:15
3884onlineNULLNULL38842018-11-20 21:58:13
3885onlineNULLNULL38852018-11-21 07:33:18
3886onlineNULLNULL38862018-11-21 10:19:29
3887onlineNULLNULL38872018-11-21 11:56:32
3888onlineNULLNULL38882018-11-21 19:47:50
3889app_storeNULLNULL38892018-11-22 05:44:07
3890ticket_desk2NULL38902018-11-22 10:38:33
3891onlineNULLNULL38912018-11-22 13:31:02
3892onlineNULLNULL38922018-11-22 17:00:02
3893onlineNULLNULL38932018-11-22 18:34:07
3894onlineNULLNULL38942018-11-22 22:50:39
3895onlineNULLNULL38952018-11-23 10:59:03
3896ticket_desk1NULL38962018-11-23 13:29:09
3897ticket_desk1NULL38972018-11-23 14:38:47
3898audio_guide_deskNULL338982018-11-23 15:06:52
3899onlineNULLNULL38992018-11-23 22:13:58
3900onlineNULLNULL39002018-11-24 07:39:35
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;