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,626–3,650 of 5,412

purchase_order, page 146 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3626onlineNULLNULL36262018-08-29 18:20:54
3627onlineNULLNULL36272018-08-30 07:45:55
3628ticket_desk5NULL36282018-08-30 09:01:12
3629onlineNULLNULL36292018-08-30 10:30:14
3630ticket_desk1NULL36302018-08-30 10:47:46
3631onlineNULLNULL36312018-08-30 12:42:06
3632onlineNULLNULL36322018-08-30 16:50:14
3633onlineNULLNULL36332018-08-31 09:03:46
3634app_storeNULLNULL36342018-08-31 10:18:52
3635ticket_desk1NULL36352018-08-31 14:49:07
3636onlineNULLNULL36362018-09-02 07:54:01
3637ticket_desk1NULL36372018-09-02 10:00:39
3638audio_guide_deskNULL236382018-09-02 10:18:12
3639onlineNULLNULL36392018-09-02 11:08:45
3640onlineNULLNULL36402018-09-03 16:42:03
3641app_storeNULLNULL36412018-09-03 18:29:38
3642ticket_desk1NULL36422018-09-04 11:10:57
3643onlineNULLNULL36432018-09-05 10:11:37
3644ticket_desk4NULL36442018-09-05 10:32:13
3645ticket_desk3NULL36452018-09-05 11:03:07
3646audio_guide_deskNULL236462018-09-05 11:50:51
3647app_storeNULLNULL36472018-09-05 17:31:50
3648ticket_desk2NULL36482018-09-06 13:59:29
3649audio_guide_deskNULL236492018-09-06 14:49:29
3650onlineNULLNULL36502018-09-09 18:48:06
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;