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

purchase_order, page 120 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
2976onlineNULLNULL29762018-03-06 21:13:38
2977app_storeNULLNULL29772018-03-07 12:17:13
2978onlineNULLNULL29782018-03-07 15:34:45
2979app_storeNULLNULL29792018-03-07 21:34:47
2980onlineNULLNULL29802018-03-08 11:02:31
2981onlineNULLNULL29812018-03-09 11:55:41
2982ticket_desk1NULL29822018-03-09 12:22:29
2983onlineNULLNULL29832018-03-09 17:34:44
2984ticket_desk1NULL29842018-03-10 10:12:18
2985onlineNULLNULL29852018-03-10 17:26:06
2986ticket_desk1NULL29862018-03-11 09:18:07
2987onlineNULLNULL29872018-03-11 10:52:42
2988onlineNULLNULL29882018-03-12 10:48:33
2989app_storeNULLNULL29892018-03-12 11:44:05
2990onlineNULLNULL29902018-03-12 21:45:22
2991app_storeNULLNULL29912018-03-13 09:32:56
2992onlineNULLNULL29922018-03-13 23:11:38
2993onlineNULLNULL29932018-03-14 13:28:41
2994app_storeNULLNULL29942018-03-14 16:29:36
2995app_storeNULLNULL29952018-03-15 05:50:51
2996ticket_desk4NULL29962018-03-15 11:38:28
2997ticket_desk1NULL29972018-03-15 13:39:26
2998audio_guide_deskNULL229982018-03-15 14:03:42
2999audio_guide_deskNULL229992018-03-15 15:35:14
3000onlineNULLNULL30002018-03-15 16:28:16
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;