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,451–3,475 of 5,412

purchase_order, page 139 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
3451ticket_desk3NULL34512018-07-18 11:43:55
3452ticket_desk1NULL34522018-07-18 12:12:38
3453ticket_desk2NULL34532018-07-18 16:22:02
3454audio_guide_deskNULL134542018-07-18 17:02:18
3455onlineNULLNULL34552018-07-18 18:02:37
3456onlineNULLNULL34562018-07-18 21:14:07
3457onlineNULLNULL34572018-07-19 08:08:12
3458onlineNULLNULL34582018-07-19 21:59:12
3459ticket_desk1NULL34592018-07-20 10:40:47
3460ticket_desk2NULL34602018-07-21 09:20:53
3461ticket_desk1NULL34612018-07-21 09:36:31
3462ticket_desk5NULL34622018-07-21 10:11:21
3463audio_guide_deskNULL134632018-07-21 12:04:07
3464ticket_desk1NULL34642018-07-21 15:11:57
3465audio_guide_deskNULL234652018-07-21 15:57:29
3466onlineNULLNULL34662018-07-21 21:30:59
3467onlineNULLNULL34672018-07-23 21:17:28
3468onlineNULLNULL34682018-07-24 23:59:05
3469onlineNULLNULL34692018-07-25 07:45:41
3470audio_guide_deskNULL234702018-07-25 12:14:07
3471onlineNULLNULL34712018-07-25 13:29:32
3472app_storeNULLNULL34722018-07-25 22:51:35
3473onlineNULLNULL34732018-07-26 11:44:09
3474onlineNULLNULL34742018-07-26 12:12:46
3475ticket_desk2NULL34752018-07-27 09:42:04
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;