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,051–4,075 of 5,412

purchase_order, page 163 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4051onlineNULLNULL40512019-01-18 12:33:11
4052onlineNULLNULL40522019-01-18 15:40:27
4053ticket_desk2NULL40532019-01-19 08:59:59
4054audio_guide_deskNULL240542019-01-19 09:21:55
4055ticket_desk2NULL40552019-01-19 10:14:37
4056ticket_desk1NULL40562019-01-19 11:58:46
4057app_storeNULLNULL40572019-01-20 04:49:39
4058audio_guide_deskNULL240582019-01-20 09:50:47
4059onlineNULLNULL40592019-01-20 16:57:56
4060onlineNULLNULL40602019-01-21 11:46:58
4061onlineNULLNULL40612019-01-23 07:03:59
4062onlineNULLNULL40622019-01-23 08:32:33
4063app_storeNULLNULL40632019-01-23 22:33:42
4064app_storeNULLNULL40642019-01-24 04:04:55
4065ticket_desk2NULL40652019-01-24 14:51:18
4066audio_guide_deskNULL240662019-01-24 15:19:42
4067onlineNULLNULL40672019-01-24 17:30:19
4068audio_guide_deskNULL240682019-01-25 17:02:14
4069app_storeNULLNULL40692019-01-26 03:43:21
4070onlineNULLNULL40702019-01-26 22:28:04
4071onlineNULLNULL40712019-01-27 23:32:02
4072app_storeNULLNULL40722019-01-28 06:59:11
4073onlineNULLNULL40732019-01-29 09:25:33
4074onlineNULLNULL40742019-01-29 13:45:00
4075onlineNULLNULL40752019-01-29 23:14:06
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;