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 476–500 of 5,412

purchase_order, page 20 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
476onlineNULLNULL4762015-07-30 13:59:20
477app_storeNULLNULL4772015-08-01 06:15:10
478ticket_desk2NULL4782015-08-01 09:29:34
479ticket_desk4NULL4792015-08-01 11:18:58
480onlineNULLNULL4802015-08-01 17:17:12
481onlineNULLNULL4812015-08-03 07:09:40
482onlineNULLNULL4822015-08-03 07:31:40
483onlineNULLNULL4832015-08-03 09:21:02
484ticket_desk1NULL4842015-08-04 08:45:05
485audio_guide_deskNULL24852015-08-04 10:53:50
486onlineNULLNULL4862015-08-04 13:28:17
487app_storeNULLNULL4872015-08-04 21:13:20
488ticket_desk3NULL4882015-08-05 08:59:22
489ticket_desk2NULL4892015-08-05 09:56:02
490onlineNULLNULL4902015-08-05 16:36:38
491onlineNULLNULL4912015-08-05 18:22:50
492onlineNULLNULL4922015-08-05 19:50:32
493onlineNULLNULL4932015-08-05 23:47:58
494audio_guide_deskNULL24942015-08-06 09:58:08
495onlineNULLNULL4952015-08-06 13:19:27
496audio_guide_deskNULL24962015-08-06 17:04:05
497ticket_desk4NULL4972015-08-07 10:35:31
498onlineNULLNULL4982015-08-07 10:45:59
499audio_guide_deskNULL24992015-08-07 11:15:26
500onlineNULLNULL5002015-08-07 15:55:45
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;