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 451–475 of 5,412

purchase_order, page 19 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
451app_storeNULLNULL4512015-07-25 01:30:49
452onlineNULLNULL4522015-07-25 07:53:36
453audio_guide_deskNULL24532015-07-25 10:36:08
454ticket_desk1NULL4542015-07-25 14:42:09
455audio_guide_deskNULL24552015-07-25 15:03:31
456ticket_desk2NULL4562015-07-25 15:03:55
457audio_guide_deskNULL34572015-07-25 15:32:08
458onlineNULLNULL4582015-07-25 18:40:53
459ticket_desk3NULL4592015-07-26 08:51:16
460audio_guide_deskNULL24602015-07-26 09:34:55
461onlineNULLNULL4612015-07-26 23:49:10
462onlineNULLNULL4622015-07-27 12:34:51
463onlineNULLNULL4632015-07-27 16:56:34
464onlineNULLNULL4642015-07-27 22:27:37
465onlineNULLNULL4652015-07-28 07:04:54
466onlineNULLNULL4662015-07-28 15:24:06
467app_storeNULLNULL4672015-07-29 03:22:18
468audio_guide_deskNULL24682015-07-29 11:33:27
469onlineNULLNULL4692015-07-29 11:47:04
470ticket_desk1NULL4702015-07-29 12:51:25
471audio_guide_deskNULL24712015-07-29 13:15:50
472audio_guide_deskNULL24722015-07-29 13:23:43
473app_storeNULLNULL4732015-07-29 20:02:07
474onlineNULLNULL4742015-07-30 09:14:42
475ticket_desk3NULL4752015-07-30 10:24:47
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;