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 4,851–4,875 of 5,412

purchase_order, page 195 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4851onlineNULLNULL48512019-09-04 18:55:08
4852onlineNULLNULL48522019-09-04 22:48:12
4853app_storeNULLNULL48532019-09-05 06:00:20
4854onlineNULLNULL48542019-09-05 08:42:45
4855audio_guide_deskNULL348552019-09-05 12:24:47
4856onlineNULLNULL48562019-09-05 20:08:54
4857app_storeNULLNULL48572019-09-05 21:00:05
4858app_storeNULLNULL48582019-09-06 03:44:10
4859onlineNULLNULL48592019-09-06 09:00:50
4860app_storeNULLNULL48602019-09-06 22:28:42
4861onlineNULLNULL48612019-09-06 22:51:36
4862onlineNULLNULL48622019-09-07 10:32:28
4863onlineNULLNULL48632019-09-07 13:10:54
4864onlineNULLNULL48642019-09-07 21:10:17
4865onlineNULLNULL48652019-09-08 15:18:41
4866app_storeNULLNULL48662019-09-09 23:26:01
4867audio_guide_deskNULL248672019-09-10 11:10:34
4868onlineNULLNULL48682019-09-10 13:30:52
4869app_storeNULLNULL48692019-09-10 21:27:58
4870app_storeNULLNULL48702019-09-11 02:44:46
4871onlineNULLNULL48712019-09-11 07:10:48
4872ticket_desk2NULL48722019-09-11 10:14:14
4873onlineNULLNULL48732019-09-11 10:27:08
4874audio_guide_deskNULL248742019-09-11 12:31:30
4875app_storeNULLNULL48752019-09-12 01:28:51
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;