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,301–5,325 of 5,412

purchase_order, page 213 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5301onlineNULLNULL53012020-01-21 21:45:42
5302onlineNULLNULL53022020-01-21 22:29:03
5303onlineNULLNULL53032020-01-22 07:58:08
5304onlineNULLNULL53042020-01-22 09:42:47
5305audio_guide_deskNULL353052020-01-22 10:08:36
5306audio_guide_deskNULL253062020-01-22 10:56:07
5307onlineNULLNULL53072020-01-22 12:19:30
5308audio_guide_deskNULL153082020-01-22 14:41:35
5309onlineNULLNULL53092020-01-22 20:25:00
5310onlineNULLNULL53102020-01-23 07:26:11
5311app_storeNULLNULL53112020-01-23 09:51:49
5312audio_guide_deskNULL353122020-01-23 13:45:46
5313ticket_desk1NULL53132020-01-23 14:11:58
5314audio_guide_deskNULL253142020-01-23 14:47:43
5315onlineNULLNULL53152020-01-23 15:09:09
5316onlineNULLNULL53162020-01-24 20:08:55
5317onlineNULLNULL53172020-01-24 20:23:36
5318ticket_desk2NULL53182020-01-25 08:43:29
5319onlineNULLNULL53192020-01-25 14:38:50
5320onlineNULLNULL53202020-01-25 17:33:54
5321app_storeNULLNULL53212020-01-26 10:42:26
5322onlineNULLNULL53222020-01-26 13:08:52
5323app_storeNULLNULL53232020-01-27 00:03:04
5324app_storeNULLNULL53242020-01-27 01:45:48
5325ticket_desk5NULL53252020-01-27 08:56:31
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;