Table

purchase_order

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

Replaces in 2020: Invoices

Rows 101–125 of 5,412

purchase_order, page 5 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
101	audio_guide_desk	NULL	2	101	2015-04-05 10:12:23
102	app_store	NULL	NULL	102	2015-04-05 10:48:19
103	ticket_desk	1	NULL	103	2015-04-05 10:53:09
104	online	NULL	NULL	104	2015-04-05 11:03:22
105	ticket_desk	3	NULL	105	2015-04-05 12:15:40
106	online	NULL	NULL	106	2015-04-05 18:53:11
107	app_store	NULL	NULL	107	2015-04-06 10:25:01
108	ticket_desk	3	NULL	108	2015-04-06 10:46:28
109	ticket_desk	1	NULL	109	2015-04-06 11:03:46
110	audio_guide_desk	NULL	1	110	2015-04-06 11:17:40
111	audio_guide_desk	NULL	1	111	2015-04-06 11:35:12
112	online	NULL	NULL	112	2015-04-06 15:14:07
113	app_store	NULL	NULL	113	2015-04-07 03:16:22
114	app_store	NULL	NULL	114	2015-04-08 11:43:51
115	online	NULL	NULL	115	2015-04-09 08:59:46
116	audio_guide_desk	NULL	2	116	2015-04-09 10:39:44
117	audio_guide_desk	NULL	2	117	2015-04-09 10:40:01
118	online	NULL	NULL	118	2015-04-10 08:01:37
119	online	NULL	NULL	119	2015-04-10 08:58:36
120	ticket_desk	2	NULL	120	2015-04-10 10:23:47
121	audio_guide_desk	NULL	2	121	2015-04-10 10:40:26
122	audio_guide_desk	NULL	3	122	2015-04-10 10:44:21
123	ticket_desk	1	NULL	123	2015-04-10 13:45:54
124	ticket_desk	1	NULL	124	2015-04-11 16:04:51
125	app_store	NULL	NULL	125	2015-04-12 11:38:08

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;