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 4,876–4,900 of 5,412

purchase_order, page 196 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
4876app_storeNULLNULL48762019-09-12 08:17:06
4877ticket_desk1NULL48772019-09-12 09:10:33
4878onlineNULLNULL48782019-09-13 09:43:41
4879audio_guide_deskNULL148792019-09-13 11:37:15
4880audio_guide_deskNULL148802019-09-13 11:41:06
4881app_storeNULLNULL48812019-09-14 06:31:09
4882audio_guide_deskNULL248822019-09-14 09:28:07
4883ticket_desk2NULL48832019-09-14 11:17:33
4884audio_guide_deskNULL248842019-09-14 14:47:24
4885onlineNULLNULL48852019-09-15 08:00:45
4886onlineNULLNULL48862019-09-15 08:18:57
4887ticket_desk2NULL48872019-09-15 09:58:12
4888onlineNULLNULL48882019-09-15 15:21:06
4889onlineNULLNULL48892019-09-15 19:14:47
4890onlineNULLNULL48902019-09-15 20:58:03
4891app_storeNULLNULL48912019-09-17 02:28:13
4892app_storeNULLNULL48922019-09-17 08:17:37
4893onlineNULLNULL48932019-09-17 13:26:09
4894app_storeNULLNULL48942019-09-17 21:19:06
4895onlineNULLNULL48952019-09-18 10:56:10
4896onlineNULLNULL48962019-09-19 12:08:42
4897onlineNULLNULL48972019-09-20 09:58:35
4898onlineNULLNULL48982019-09-20 14:52:33
4899onlineNULLNULL48992019-09-22 08:10:13
4900onlineNULLNULL49002019-09-22 08:57:10
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;