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 4,101–4,125 of 5,412

purchase_order, page 165 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4101onlineNULLNULL41012019-02-08 11:54:24
4102onlineNULLNULL41022019-02-08 15:22:56
4103onlineNULLNULL41032019-02-09 12:20:12
4104ticket_desk4NULL41042019-02-09 14:16:34
4105app_storeNULLNULL41052019-02-09 16:03:04
4106onlineNULLNULL41062019-02-09 19:21:15
4107onlineNULLNULL41072019-02-09 19:30:39
4108onlineNULLNULL41082019-02-10 07:34:05
4109onlineNULLNULL41092019-02-10 07:55:51
4110onlineNULLNULL41102019-02-10 19:00:14
4111onlineNULLNULL41112019-02-10 20:59:09
4112ticket_desk1NULL41122019-02-11 09:49:51
4113onlineNULLNULL41132019-02-11 13:26:24
4114ticket_desk1NULL41142019-02-12 10:26:08
4115audio_guide_deskNULL341152019-02-12 11:15:46
4116ticket_desk1NULL41162019-02-12 13:03:57
4117ticket_desk5NULL41172019-02-12 14:06:14
4118audio_guide_deskNULL241182019-02-12 14:49:43
4119onlineNULLNULL41192019-02-13 08:42:37
4120ticket_desk1NULL41202019-02-13 11:11:08
4121audio_guide_deskNULL241212019-02-14 10:47:31
4122onlineNULLNULL41222019-02-14 22:25:17
4123audio_guide_deskNULL241232019-02-15 15:31:53
4124audio_guide_deskNULL241242019-02-15 15:36:21
4125onlineNULLNULL41252019-02-16 08:19:57
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;