Table

purchase_order

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

Replaces in 2020: Invoices

Rows 976–1,000 of 5,412

purchase_order, page 40 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
976	online	NULL	NULL	976	2016-01-30 13:37:50
977	online	NULL	NULL	977	2016-02-01 17:16:07
978	online	NULL	NULL	978	2016-02-01 23:12:30
979	ticket_desk	2	NULL	979	2016-02-02 09:35:35
980	ticket_desk	4	NULL	980	2016-02-03 10:43:23
981	app_store	NULL	NULL	981	2016-02-04 00:24:06
982	audio_guide_desk	NULL	1	982	2016-02-04 12:41:47
983	app_store	NULL	NULL	983	2016-02-06 07:59:49
984	online	NULL	NULL	984	2016-02-06 23:41:16
985	ticket_desk	4	NULL	985	2016-02-07 10:57:48
986	audio_guide_desk	NULL	2	986	2016-02-07 11:34:46
987	ticket_desk	3	NULL	987	2016-02-07 13:13:15
988	audio_guide_desk	NULL	3	988	2016-02-07 13:42:58
989	app_store	NULL	NULL	989	2016-02-07 21:55:14
990	ticket_desk	2	NULL	990	2016-02-09 11:54:11
991	audio_guide_desk	NULL	2	991	2016-02-09 12:43:07
992	audio_guide_desk	NULL	2	992	2016-02-09 12:50:26
993	ticket_desk	2	NULL	993	2016-02-09 13:06:47
994	online	NULL	NULL	994	2016-02-09 14:08:56
995	online	NULL	NULL	995	2016-02-10 19:19:34
996	online	NULL	NULL	996	2016-02-12 12:16:24
997	app_store	NULL	NULL	997	2016-02-14 12:31:13
998	ticket_desk	1	NULL	998	2016-02-14 15:58:58
999	audio_guide_desk	NULL	2	999	2016-02-14 16:31:58
1000	audio_guide_desk	NULL	2	1000	2016-02-14 16:38:16

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;