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 651–675 of 5,412

purchase_order, page 27 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
651audio_guide_deskNULL26512015-09-20 12:33:09
652ticket_desk2NULL6522015-09-20 14:47:58
653onlineNULLNULL6532015-09-20 20:16:08
654app_storeNULLNULL6542015-09-20 21:01:10
655ticket_desk2NULL6552015-09-22 11:04:00
656audio_guide_deskNULL16562015-09-22 11:45:41
657ticket_desk5NULL6572015-09-22 12:07:19
658onlineNULLNULL6582015-09-22 20:11:54
659ticket_desk1NULL6592015-09-23 09:49:49
660audio_guide_deskNULL26602015-09-23 10:31:33
661ticket_desk2NULL6612015-09-23 11:09:51
662audio_guide_deskNULL26622015-09-23 11:45:29
663ticket_desk2NULL6632015-09-23 12:21:52
664audio_guide_deskNULL26642015-09-23 12:59:17
665app_storeNULLNULL6652015-09-23 16:41:11
666onlineNULLNULL6662015-09-23 22:09:19
667audio_guide_deskNULL26672015-09-24 10:34:39
668app_storeNULLNULL6682015-09-24 11:14:35
669onlineNULLNULL6692015-09-24 12:59:00
670ticket_desk1NULL6702015-09-25 10:21:32
671ticket_desk2NULL6712015-09-25 10:41:50
672app_storeNULLNULL6722015-09-25 16:48:14
673ticket_desk4NULL6732015-09-27 10:18:45
674ticket_desk2NULL6742015-09-27 10:46:13
675ticket_desk2NULL6752015-09-27 12:23:37
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;