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,651–3,675 of 5,412

purchase_order, page 147 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3651onlineNULLNULL36512018-09-10 08:15:48
3652onlineNULLNULL36522018-09-10 08:53:27
3653onlineNULLNULL36532018-09-10 19:57:00
3654ticket_desk2NULL36542018-09-11 11:27:54
3655onlineNULLNULL36552018-09-11 17:45:05
3656onlineNULLNULL36562018-09-12 08:12:51
3657ticket_desk1NULL36572018-09-12 09:43:14
3658onlineNULLNULL36582018-09-12 10:59:21
3659audio_guide_deskNULL236592018-09-12 11:42:57
3660onlineNULLNULL36602018-09-12 14:16:56
3661onlineNULLNULL36612018-09-12 23:42:48
3662onlineNULLNULL36622018-09-13 10:43:19
3663audio_guide_deskNULL336632018-09-14 10:20:46
3664ticket_desk2NULL36642018-09-14 10:28:27
3665audio_guide_deskNULL136652018-09-14 11:11:44
3666onlineNULLNULL36662018-09-14 17:29:48
3667app_storeNULLNULL36672018-09-15 01:08:53
3668onlineNULLNULL36682018-09-15 08:25:25
3669ticket_desk1NULL36692018-09-15 10:39:23
3670ticket_desk4NULL36702018-09-16 11:39:40
3671onlineNULLNULL36712018-09-16 12:17:42
3672audio_guide_deskNULL236722018-09-16 12:18:25
3673ticket_desk1NULL36732018-09-16 14:52:58
3674ticket_desk1NULL36742018-09-17 09:41:00
3675ticket_desk2NULL36752018-09-17 10:59:35
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;