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 201–225 of 5,412

purchase_order, page 9 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
201ticket_desk1NULL2012015-05-06 14:57:51
202onlineNULLNULL2022015-05-06 18:08:18
203onlineNULLNULL2032015-05-06 19:05:24
204audio_guide_deskNULL22042015-05-07 11:09:39
205onlineNULLNULL2052015-05-07 13:50:18
206ticket_desk5NULL2062015-05-08 12:27:23
207onlineNULLNULL2072015-05-09 12:17:33
208onlineNULLNULL2082015-05-10 09:06:49
209app_storeNULLNULL2092015-05-10 11:50:43
210ticket_desk1NULL2102015-05-10 14:57:51
211app_storeNULLNULL2112015-05-10 15:31:57
212app_storeNULLNULL2122015-05-11 12:15:23
213app_storeNULLNULL2132015-05-11 17:48:02
214onlineNULLNULL2142015-05-12 07:30:20
215ticket_desk2NULL2152015-05-12 10:17:44
216audio_guide_deskNULL22162015-05-12 11:19:02
217ticket_desk5NULL2172015-05-13 12:02:38
218ticket_desk2NULL2182015-05-13 12:42:27
219ticket_desk2NULL2192015-05-13 14:26:48
220audio_guide_deskNULL32202015-05-13 15:01:18
221onlineNULLNULL2212015-05-13 17:03:27
222ticket_desk1NULL2222015-05-14 11:16:13
223onlineNULLNULL2232015-05-15 08:20:59
224onlineNULLNULL2242015-05-15 08:35:08
225ticket_desk1NULL2252015-05-15 09:18:57
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;