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 276–300 of 5,412

purchase_order, page 12 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
276onlineNULLNULL2762015-06-03 09:05:57
277ticket_desk1NULL2772015-06-03 11:13:36
278onlineNULLNULL2782015-06-03 14:26:28
279onlineNULLNULL2792015-06-03 14:49:12
280onlineNULLNULL2802015-06-04 14:03:44
281app_storeNULLNULL2812015-06-05 09:42:06
282audio_guide_deskNULL32822015-06-06 10:45:14
283ticket_desk3NULL2832015-06-06 10:55:10
284audio_guide_deskNULL22842015-06-06 11:24:40
285ticket_desk2NULL2852015-06-06 13:03:57
286audio_guide_deskNULL22862015-06-06 14:05:27
287ticket_desk1NULL2872015-06-06 15:41:07
288onlineNULLNULL2882015-06-07 12:59:38
289ticket_desk2NULL2892015-06-08 10:27:51
290ticket_desk1NULL2902015-06-08 11:12:14
291audio_guide_deskNULL22912015-06-08 11:14:53
292audio_guide_deskNULL22922015-06-08 11:39:10
293app_storeNULLNULL2932015-06-08 13:59:45
294ticket_desk2NULL2942015-06-08 14:36:59
295onlineNULLNULL2952015-06-08 21:12:14
296app_storeNULLNULL2962015-06-09 12:41:42
297onlineNULLNULL2972015-06-09 16:28:38
298onlineNULLNULL2982015-06-09 17:29:43
299audio_guide_deskNULL32992015-06-10 15:24:25
300onlineNULLNULL3002015-06-10 16:37:56
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;