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

purchase_order, page 22 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
526onlineNULLNULL5262015-08-14 11:44:32
527onlineNULLNULL5272015-08-14 14:49:54
528ticket_desk1NULL5282015-08-14 15:18:07
529ticket_desk1NULL5292015-08-15 10:37:37
530audio_guide_deskNULL25302015-08-15 11:08:13
531ticket_desk1NULL5312015-08-15 11:30:59
532audio_guide_deskNULL25322015-08-15 13:42:16
533ticket_desk3NULL5332015-08-15 14:40:41
534ticket_desk5NULL5342015-08-15 15:05:55
535audio_guide_deskNULL25352015-08-16 12:15:26
536ticket_desk2NULL5362015-08-16 15:17:48
537ticket_desk2NULL5372015-08-17 09:28:23
538onlineNULLNULL5382015-08-18 07:36:37
539ticket_desk2NULL5392015-08-18 10:16:52
540audio_guide_deskNULL35402015-08-18 11:00:48
541ticket_desk4NULL5412015-08-18 14:43:12
542audio_guide_deskNULL25422015-08-18 15:17:24
543onlineNULLNULL5432015-08-18 19:20:12
544onlineNULLNULL5442015-08-19 09:24:05
545onlineNULLNULL5452015-08-19 16:10:01
546app_storeNULLNULL5462015-08-19 18:02:23
547onlineNULLNULL5472015-08-20 07:56:11
548onlineNULLNULL5482015-08-20 08:05:14
549audio_guide_deskNULL25492015-08-20 11:21:11
550ticket_desk4NULL5502015-08-20 12:46:25
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;