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

purchase_order, page 212 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
5276onlineNULLNULL52762020-01-12 14:40:29
5277audio_guide_deskNULL252772020-01-12 15:49:02
5278onlineNULLNULL52782020-01-13 12:33:27
5279onlineNULLNULL52792020-01-14 07:48:35
5280ticket_desk1NULL52802020-01-14 10:02:36
5281ticket_desk2NULL52812020-01-14 11:16:36
5282onlineNULLNULL52822020-01-14 13:35:21
5283onlineNULLNULL52832020-01-15 10:48:16
5284ticket_desk2NULL52842020-01-15 14:09:14
5285onlineNULLNULL52852020-01-16 19:03:07
5286onlineNULLNULL52862020-01-17 18:41:48
5287app_storeNULLNULL52872020-01-18 00:02:40
5288onlineNULLNULL52882020-01-18 08:19:28
5289audio_guide_deskNULL252892020-01-18 09:27:56
5290ticket_desk1NULL52902020-01-18 11:38:50
5291ticket_desk1NULL52912020-01-18 11:58:00
5292audio_guide_deskNULL252922020-01-18 12:40:29
5293onlineNULLNULL52932020-01-18 14:00:45
5294audio_guide_deskNULL352942020-01-18 15:07:23
5295audio_guide_deskNULL352952020-01-18 15:21:29
5296app_storeNULLNULL52962020-01-19 02:51:04
5297ticket_desk1NULL52972020-01-19 09:11:10
5298onlineNULLNULL52982020-01-19 21:17:06
5299onlineNULLNULL52992020-01-20 10:14:16
5300ticket_desk1NULL53002020-01-21 13:34:39
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;