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,976–4,000 of 5,412

purchase_order, page 160 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3976app_storeNULLNULL39762018-12-15 21:21:45
3977onlineNULLNULL39772018-12-15 22:22:31
3978onlineNULLNULL39782018-12-16 07:16:30
3979audio_guide_deskNULL139792018-12-16 10:28:54
3980audio_guide_deskNULL239802018-12-16 13:05:44
3981ticket_desk2NULL39812018-12-16 16:05:48
3982app_storeNULLNULL39822018-12-17 01:27:25
3983onlineNULLNULL39832018-12-17 22:25:48
3984onlineNULLNULL39842018-12-18 08:55:27
3985audio_guide_deskNULL239852018-12-18 09:55:39
3986app_storeNULLNULL39862018-12-18 12:41:02
3987ticket_desk2NULL39872018-12-19 08:40:07
3988onlineNULLNULL39882018-12-19 11:23:14
3989audio_guide_deskNULL239892018-12-19 12:51:30
3990ticket_desk2NULL39902018-12-19 14:03:56
3991app_storeNULLNULL39912018-12-20 04:30:24
3992onlineNULLNULL39922018-12-20 08:00:39
3993onlineNULLNULL39932018-12-20 08:24:13
3994onlineNULLNULL39942018-12-20 09:06:29
3995audio_guide_deskNULL239952018-12-20 09:57:16
3996onlineNULLNULL39962018-12-21 11:18:12
3997onlineNULLNULL39972018-12-22 08:42:17
3998ticket_desk1NULL39982018-12-22 10:02:24
3999audio_guide_deskNULL139992018-12-22 10:38:26
4000audio_guide_deskNULL240002018-12-22 11:31:15
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;