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 5,001–5,025 of 5,412

purchase_order, page 201 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5001onlineNULLNULL50012019-10-27 20:11:46
5002onlineNULLNULL50022019-10-28 07:31:05
5003onlineNULLNULL50032019-10-28 09:47:51
5004ticket_desk2NULL50042019-10-28 11:09:56
5005onlineNULLNULL50052019-10-28 13:10:42
5006ticket_desk1NULL50062019-10-28 13:53:58
5007audio_guide_deskNULL250072019-10-28 14:03:56
5008app_storeNULLNULL50082019-10-29 02:50:53
5009onlineNULLNULL50092019-10-29 08:14:02
5010onlineNULLNULL50102019-10-29 08:42:42
5011ticket_desk5NULL50112019-10-29 11:18:42
5012ticket_desk2NULL50122019-10-29 14:50:29
5013ticket_desk2NULL50132019-10-29 16:36:06
5014audio_guide_deskNULL250142019-10-29 17:05:20
5015app_storeNULLNULL50152019-10-30 23:11:36
5016app_storeNULLNULL50162019-10-31 06:11:14
5017onlineNULLNULL50172019-10-31 12:58:57
5018onlineNULLNULL50182019-10-31 17:54:10
5019app_storeNULLNULL50192019-11-01 06:56:45
5020onlineNULLNULL50202019-11-02 07:13:39
5021ticket_desk1NULL50212019-11-02 11:11:21
5022onlineNULLNULL50222019-11-02 21:21:45
5023onlineNULLNULL50232019-11-03 10:43:33
5024onlineNULLNULL50242019-11-03 18:50:22
5025onlineNULLNULL50252019-11-03 19:11:05
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;