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,126–4,150 of 5,412

purchase_order, page 166 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4126app_storeNULLNULL41262019-02-16 10:02:21
4127ticket_desk5NULL41272019-02-16 10:11:23
4128ticket_desk1NULL41282019-02-16 11:39:04
4129ticket_desk4NULL41292019-02-16 15:19:40
4130onlineNULLNULL41302019-02-16 20:43:33
4131app_storeNULLNULL41312019-02-16 21:14:10
4132app_storeNULLNULL41322019-02-18 03:12:00
4133onlineNULLNULL41332019-02-18 08:46:38
4134onlineNULLNULL41342019-02-18 09:00:55
4135onlineNULLNULL41352019-02-18 10:23:36
4136app_storeNULLNULL41362019-02-19 02:42:37
4137app_storeNULLNULL41372019-02-19 14:45:03
4138onlineNULLNULL41382019-02-19 21:25:08
4139onlineNULLNULL41392019-02-20 11:08:58
4140onlineNULLNULL41402019-02-20 11:25:36
4141app_storeNULLNULL41412019-02-21 02:56:55
4142onlineNULLNULL41422019-02-21 17:11:40
4143onlineNULLNULL41432019-02-21 23:47:11
4144audio_guide_deskNULL141442019-02-22 11:40:29
4145app_storeNULLNULL41452019-02-22 17:00:36
4146ticket_desk2NULL41462019-02-23 09:18:22
4147onlineNULLNULL41472019-02-23 14:51:40
4148app_storeNULLNULL41482019-02-24 01:59:31
4149app_storeNULLNULL41492019-02-24 05:45:48
4150ticket_desk2NULL41502019-02-24 11:17:46
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;