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 3,676–3,700 of 5,412

purchase_order, page 148 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3676ticket_desk2NULL36762018-09-17 11:06:08
3677audio_guide_deskNULL236772018-09-17 11:27:25
3678audio_guide_deskNULL236782018-09-17 11:36:25
3679onlineNULLNULL36792018-09-17 21:13:30
3680audio_guide_deskNULL336802018-09-18 11:56:07
3681onlineNULLNULL36812018-09-18 12:58:23
3682ticket_desk1NULL36822018-09-18 15:43:26
3683audio_guide_deskNULL136832018-09-18 16:05:58
3684onlineNULLNULL36842018-09-18 18:04:05
3685audio_guide_deskNULL236852018-09-19 12:02:16
3686audio_guide_deskNULL136862018-09-19 12:10:33
3687app_storeNULLNULL36872018-09-20 02:14:07
3688onlineNULLNULL36882018-09-20 08:35:42
3689onlineNULLNULL36892018-09-20 21:24:58
3690onlineNULLNULL36902018-09-20 22:24:40
3691onlineNULLNULL36912018-09-23 13:01:34
3692onlineNULLNULL36922018-09-23 13:20:30
3693ticket_desk1NULL36932018-09-23 13:47:07
3694audio_guide_deskNULL336942018-09-23 14:15:30
3695audio_guide_deskNULL336952018-09-23 14:16:56
3696onlineNULLNULL36962018-09-23 18:30:14
3697onlineNULLNULL36972018-09-24 12:16:32
3698onlineNULLNULL36982018-09-24 22:26:39
3699ticket_desk2NULL36992018-09-25 10:17:20
3700audio_guide_deskNULL237002018-09-25 11:15:33
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;