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,351–3,375 of 5,412

purchase_order, page 135 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3351onlineNULLNULL33512018-06-20 18:38:57
3352onlineNULLNULL33522018-06-21 08:50:14
3353onlineNULLNULL33532018-06-21 10:48:05
3354ticket_desk5NULL33542018-06-22 14:06:51
3355app_storeNULLNULL33552018-06-22 18:05:12
3356audio_guide_deskNULL233562018-06-23 14:13:58
3357onlineNULLNULL33572018-06-23 17:59:30
3358onlineNULLNULL33582018-06-24 08:32:01
3359ticket_desk2NULL33592018-06-24 10:03:30
3360audio_guide_deskNULL233602018-06-24 10:40:12
3361onlineNULLNULL33612018-06-24 15:41:09
3362onlineNULLNULL33622018-06-24 19:40:34
3363app_storeNULLNULL33632018-06-25 07:26:56
3364app_storeNULLNULL33642018-06-26 01:30:27
3365onlineNULLNULL33652018-06-26 19:14:19
3366app_storeNULLNULL33662018-06-27 07:48:32
3367onlineNULLNULL33672018-06-27 17:17:00
3368onlineNULLNULL33682018-06-27 18:34:04
3369onlineNULLNULL33692018-06-27 19:53:16
3370onlineNULLNULL33702018-06-27 20:46:25
3371onlineNULLNULL33712018-06-27 21:32:38
3372app_storeNULLNULL33722018-06-27 21:44:29
3373audio_guide_deskNULL133732018-06-28 12:58:15
3374onlineNULLNULL33742018-06-28 17:23:50
3375app_storeNULLNULL33752018-06-28 20:41:58
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;