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 551–575 of 5,412

purchase_order, page 23 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
551onlineNULLNULL5512015-08-20 13:24:56
552audio_guide_deskNULL15522015-08-20 13:31:21
553onlineNULLNULL5532015-08-20 20:31:58
554onlineNULLNULL5542015-08-21 14:09:52
555ticket_desk5NULL5552015-08-21 15:54:48
556audio_guide_deskNULL25562015-08-21 16:19:36
557audio_guide_deskNULL25572015-08-22 10:39:38
558onlineNULLNULL5582015-08-22 14:06:07
559onlineNULLNULL5592015-08-22 15:33:07
560onlineNULLNULL5602015-08-23 07:35:50
561ticket_desk1NULL5612015-08-23 09:17:29
562onlineNULLNULL5622015-08-23 10:46:00
563app_storeNULLNULL5632015-08-23 17:05:43
564audio_guide_deskNULL25642015-08-23 17:11:50
565app_storeNULLNULL5652015-08-23 19:44:04
566onlineNULLNULL5662015-08-24 10:13:14
567ticket_desk1NULL5672015-08-24 10:14:29
568onlineNULLNULL5682015-08-24 18:37:43
569ticket_desk1NULL5692015-08-25 09:56:22
570onlineNULLNULL5702015-08-27 07:25:29
571app_storeNULLNULL5712015-08-27 14:15:49
572ticket_desk1NULL5722015-08-27 14:35:40
573onlineNULLNULL5732015-08-28 08:37:23
574onlineNULLNULL5742015-08-28 11:38:27
575ticket_desk4NULL5752015-08-28 12:07:42
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;