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 126–150 of 5,412

purchase_order, page 6 of 217
order_idINTEGERchannelTEXTentrance_id→ entrance.entrance_idwing_id→ wing.wing_idpayment_id→ payment.payment_idordered_atTEXT
126ticket_desk1NULL1262015-04-12 15:38:17
127audio_guide_deskNULL21272015-04-12 16:11:49
128ticket_desk4NULL1282015-04-13 09:17:23
129ticket_desk4NULL1292015-04-13 10:34:13
130onlineNULLNULL1302015-04-13 16:03:55
131ticket_desk1NULL1312015-04-14 10:54:33
132app_storeNULLNULL1322015-04-15 06:18:34
133audio_guide_deskNULL21332015-04-15 13:08:35
134ticket_desk1NULL1342015-04-15 13:22:37
135onlineNULLNULL1352015-04-17 09:28:55
136audio_guide_deskNULL21362015-04-17 12:41:21
137audio_guide_deskNULL31372015-04-17 17:13:43
138onlineNULLNULL1382015-04-18 10:31:47
139ticket_desk4NULL1392015-04-18 10:47:01
140onlineNULLNULL1402015-04-18 11:18:31
141ticket_desk3NULL1412015-04-18 11:33:21
142onlineNULLNULL1422015-04-18 14:16:58
143onlineNULLNULL1432015-04-18 21:50:10
144onlineNULLNULL1442015-04-19 14:48:50
145onlineNULLNULL1452015-04-19 15:39:09
146onlineNULLNULL1462015-04-19 18:32:02
147onlineNULLNULL1472015-04-19 22:10:17
148onlineNULLNULL1482015-04-20 08:32:33
149onlineNULLNULL1492015-04-20 09:49:25
150app_storeNULLNULL1502015-04-20 10:33:36
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;