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,951–3,975 of 5,412

purchase_order, page 159 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3951app_storeNULLNULL39512018-12-08 00:10:16
3952app_storeNULLNULL39522018-12-09 03:16:53
3953onlineNULLNULL39532018-12-09 08:26:34
3954ticket_desk1NULL39542018-12-09 10:11:32
3955app_storeNULLNULL39552018-12-09 13:00:43
3956onlineNULLNULL39562018-12-10 11:46:15
3957app_storeNULLNULL39572018-12-10 19:00:58
3958app_storeNULLNULL39582018-12-11 01:39:20
3959ticket_desk2NULL39592018-12-11 09:09:52
3960audio_guide_deskNULL239602018-12-11 09:49:45
3961onlineNULLNULL39612018-12-11 11:30:28
3962onlineNULLNULL39622018-12-11 18:37:16
3963ticket_desk4NULL39632018-12-12 10:09:58
3964onlineNULLNULL39642018-12-12 11:30:39
3965audio_guide_deskNULL239652018-12-12 12:16:25
3966onlineNULLNULL39662018-12-13 18:13:50
3967onlineNULLNULL39672018-12-13 19:13:24
3968onlineNULLNULL39682018-12-14 07:44:28
3969ticket_desk1NULL39692018-12-14 10:32:41
3970audio_guide_deskNULL339702018-12-14 11:08:07
3971ticket_desk2NULL39712018-12-14 11:16:22
3972audio_guide_deskNULL239722018-12-14 12:06:07
3973app_storeNULLNULL39732018-12-15 04:19:35
3974onlineNULLNULL39742018-12-15 10:10:35
3975onlineNULLNULL39752018-12-15 19:10:27
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;