Table

purchase_order

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

Replaces in 2020: Invoices

Rows 176–200 of 5,412

purchase_order, page 8 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
176	online	NULL	NULL	176	2015-04-29 19:46:51
177	ticket_desk	1	NULL	177	2015-04-30 15:51:04
178	online	NULL	NULL	178	2015-04-30 20:21:54
179	online	NULL	NULL	179	2015-04-30 22:27:13
180	online	NULL	NULL	180	2015-05-01 10:14:13
181	audio_guide_desk	NULL	2	181	2015-05-01 10:31:45
182	audio_guide_desk	NULL	2	182	2015-05-01 10:32:22
183	ticket_desk	1	NULL	183	2015-05-01 11:16:39
184	audio_guide_desk	NULL	2	184	2015-05-01 11:54:50
185	audio_guide_desk	NULL	2	185	2015-05-01 13:46:53
186	ticket_desk	3	NULL	186	2015-05-01 15:36:41
187	audio_guide_desk	NULL	2	187	2015-05-02 11:38:45
188	ticket_desk	5	NULL	188	2015-05-02 14:04:57
189	ticket_desk	1	NULL	189	2015-05-03 09:44:53
190	ticket_desk	1	NULL	190	2015-05-03 09:46:53
191	audio_guide_desk	NULL	1	191	2015-05-03 10:10:19
192	audio_guide_desk	NULL	2	192	2015-05-03 10:19:41
193	ticket_desk	2	NULL	193	2015-05-03 13:51:16
194	app_store	NULL	NULL	194	2015-05-03 14:44:11
195	audio_guide_desk	NULL	2	195	2015-05-04 09:44:14
196	online	NULL	NULL	196	2015-05-04 18:23:22
197	ticket_desk	2	NULL	197	2015-05-05 10:23:54
198	audio_guide_desk	NULL	1	198	2015-05-05 10:40:51
199	ticket_desk	2	NULL	199	2015-05-06 11:33:35
200	online	NULL	NULL	200	2015-05-06 13:52:06

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;