Table

purchase_order

One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.

Replaces in 2020: Invoices

Rows 326–350 of 5,412

purchase_order, page 14 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
326	audio_guide_desk	NULL	2	326	2015-06-17 13:59:28
327	app_store	NULL	NULL	327	2015-06-17 15:15:03
328	ticket_desk	1	NULL	328	2015-06-18 12:56:58
329	ticket_desk	1	NULL	329	2015-06-19 10:29:13
330	ticket_desk	4	NULL	330	2015-06-19 10:55:38
331	ticket_desk	4	NULL	331	2015-06-20 10:02:52
332	audio_guide_desk	NULL	2	332	2015-06-20 10:32:20
333	online	NULL	NULL	333	2015-06-20 16:07:49
334	ticket_desk	1	NULL	334	2015-06-21 12:17:17
335	ticket_desk	2	NULL	335	2015-06-22 10:08:34
336	app_store	NULL	NULL	336	2015-06-22 21:42:15
337	online	NULL	NULL	337	2015-06-23 07:35:50
338	online	NULL	NULL	338	2015-06-23 07:57:01
339	ticket_desk	1	NULL	339	2015-06-23 09:17:47
340	audio_guide_desk	NULL	2	340	2015-06-23 09:58:45
341	ticket_desk	1	NULL	341	2015-06-23 11:05:41
342	audio_guide_desk	NULL	2	342	2015-06-23 11:23:45
343	audio_guide_desk	NULL	2	343	2015-06-24 10:03:18
344	app_store	NULL	NULL	344	2015-06-24 12:49:22
345	ticket_desk	4	NULL	345	2015-06-25 08:44:41
346	audio_guide_desk	NULL	3	346	2015-06-25 09:27:24
347	audio_guide_desk	NULL	2	347	2015-06-26 09:30:51
348	ticket_desk	2	NULL	348	2015-06-26 14:01:05
349	audio_guide_desk	NULL	1	349	2015-06-26 14:38:58
350	app_store	NULL	NULL	350	2015-06-26 20:55:59

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;