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,526–4,550 of 5,412

purchase_order, page 182 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4526ticket_desk1NULL45262019-06-15 12:56:45
4527onlineNULLNULL45272019-06-15 14:59:48
4528onlineNULLNULL45282019-06-16 07:03:14
4529ticket_desk1NULL45292019-06-16 09:54:54
4530audio_guide_deskNULL245302019-06-16 13:43:30
4531onlineNULLNULL45312019-06-16 14:52:41
4532onlineNULLNULL45322019-06-16 17:37:37
4533audio_guide_deskNULL345332019-06-17 09:52:30
4534onlineNULLNULL45342019-06-17 10:03:52
4535onlineNULLNULL45352019-06-17 11:52:01
4536onlineNULLNULL45362019-06-18 11:12:23
4537ticket_desk1NULL45372019-06-18 11:17:08
4538onlineNULLNULL45382019-06-18 14:47:01
4539app_storeNULLNULL45392019-06-19 07:58:58
4540onlineNULLNULL45402019-06-19 17:52:47
4541onlineNULLNULL45412019-06-20 09:05:58
4542onlineNULLNULL45422019-06-20 23:34:40
4543app_storeNULLNULL45432019-06-21 00:50:11
4544onlineNULLNULL45442019-06-21 09:59:58
4545onlineNULLNULL45452019-06-21 10:24:08
4546onlineNULLNULL45462019-06-21 17:17:09
4547onlineNULLNULL45472019-06-21 18:30:25
4548ticket_desk2NULL45482019-06-22 09:29:26
4549audio_guide_deskNULL145492019-06-22 10:07:00
4550audio_guide_deskNULL345502019-06-22 12:02:50
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;