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,401–4,425 of 5,412

purchase_order, page 177 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4401onlineNULLNULL44012019-05-08 18:44:35
4402onlineNULLNULL44022019-05-08 23:54:16
4403ticket_desk3NULL44032019-05-09 09:22:00
4404ticket_desk3NULL44042019-05-09 10:41:12
4405audio_guide_deskNULL244052019-05-09 11:38:22
4406onlineNULLNULL44062019-05-10 10:11:08
4407audio_guide_deskNULL244072019-05-10 11:23:08
4408onlineNULLNULL44082019-05-10 16:26:12
4409audio_guide_deskNULL244092019-05-11 09:45:40
4410ticket_desk1NULL44102019-05-12 09:39:56
4411onlineNULLNULL44112019-05-12 10:17:13
4412app_storeNULLNULL44122019-05-12 14:53:29
4413onlineNULLNULL44132019-05-12 15:10:41
4414onlineNULLNULL44142019-05-12 15:12:20
4415ticket_desk1NULL44152019-05-13 11:44:07
4416ticket_desk1NULL44162019-05-13 13:17:46
4417audio_guide_deskNULL244172019-05-13 13:44:35
4418onlineNULLNULL44182019-05-14 17:19:49
4419onlineNULLNULL44192019-05-15 08:21:14
4420onlineNULLNULL44202019-05-15 08:35:18
4421onlineNULLNULL44212019-05-15 18:44:53
4422onlineNULLNULL44222019-05-16 15:38:15
4423app_storeNULLNULL44232019-05-16 16:16:48
4424ticket_desk2NULL44242019-05-17 09:17:51
4425onlineNULLNULL44252019-05-17 09:25:14
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;