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 401–425 of 5,412

purchase_order, page 17 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
401ticket_desk3NULL4012015-07-12 13:43:55
402ticket_desk1NULL4022015-07-12 14:17:41
403audio_guide_deskNULL24032015-07-12 14:27:31
404audio_guide_deskNULL24042015-07-12 14:48:10
405audio_guide_deskNULL24052015-07-12 14:53:39
406ticket_desk3NULL4062015-07-13 09:10:58
407onlineNULLNULL4072015-07-13 09:28:51
408ticket_desk2NULL4082015-07-13 10:46:29
409ticket_desk3NULL4092015-07-14 16:27:44
410onlineNULLNULL4102015-07-14 20:45:48
411ticket_desk4NULL4112015-07-15 13:23:35
412audio_guide_deskNULL14122015-07-15 14:02:12
413onlineNULLNULL4132015-07-16 15:07:42
414audio_guide_deskNULL14142015-07-17 11:29:46
415onlineNULLNULL4152015-07-18 08:36:45
416ticket_desk1NULL4162015-07-18 10:17:31
417audio_guide_deskNULL34172015-07-18 10:40:00
418onlineNULLNULL4182015-07-18 10:44:18
419audio_guide_deskNULL14192015-07-18 10:47:06
420ticket_desk1NULL4202015-07-18 12:41:50
421ticket_desk5NULL4212015-07-19 10:48:54
422ticket_desk1NULL4222015-07-19 13:50:01
423onlineNULLNULL4232015-07-20 07:38:49
424onlineNULLNULL4242015-07-20 09:50:49
425onlineNULLNULL4252015-07-20 11:42:54
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;