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 426–450 of 5,412

purchase_order, page 18 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
426onlineNULLNULL4262015-07-21 07:29:09
427onlineNULLNULL4272015-07-21 07:38:21
428ticket_desk4NULL4282015-07-21 11:28:10
429ticket_desk5NULL4292015-07-21 11:37:11
430app_storeNULLNULL4302015-07-21 13:27:33
431onlineNULLNULL4312015-07-21 22:13:04
432ticket_desk1NULL4322015-07-22 11:32:05
433ticket_desk2NULL4332015-07-22 11:41:18
434ticket_desk1NULL4342015-07-22 12:06:07
435audio_guide_deskNULL24352015-07-22 12:39:25
436ticket_desk5NULL4362015-07-22 12:47:32
437ticket_desk2NULL4372015-07-23 10:51:08
438ticket_desk1NULL4382015-07-23 11:10:04
439audio_guide_deskNULL14392015-07-23 11:31:00
440ticket_desk2NULL4402015-07-23 12:40:08
441ticket_desk3NULL4412015-07-23 14:06:40
442app_storeNULLNULL4422015-07-23 21:03:53
443onlineNULLNULL4432015-07-23 22:11:25
444onlineNULLNULL4442015-07-24 07:21:58
445ticket_desk3NULL4452015-07-24 08:31:35
446ticket_desk1NULL4462015-07-24 09:21:50
447audio_guide_deskNULL34472015-07-24 09:22:07
448ticket_desk1NULL4482015-07-24 10:24:02
449audio_guide_deskNULL34492015-07-24 11:40:08
450onlineNULLNULL4502015-07-24 18:15:32
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;