Table

purchase_order

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

Replaces in 2020: Invoices

Rows 1,301–1,325 of 5,412

purchase_order, page 53 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1301	ticket_desk	4	NULL	1301	2016-06-10 12:08:54
1302	ticket_desk	1	NULL	1302	2016-06-10 16:04:19
1303	online	NULL	NULL	1303	2016-06-11 19:11:10
1304	online	NULL	NULL	1304	2016-06-11 22:42:27
1305	ticket_desk	1	NULL	1305	2016-06-12 09:54:30
1306	online	NULL	NULL	1306	2016-06-12 11:03:01
1307	ticket_desk	2	NULL	1307	2016-06-12 11:33:36
1308	online	NULL	NULL	1308	2016-06-12 15:07:52
1309	app_store	NULL	NULL	1309	2016-06-12 19:00:27
1310	ticket_desk	1	NULL	1310	2016-06-14 08:43:39
1311	online	NULL	NULL	1311	2016-06-14 20:13:35
1312	app_store	NULL	NULL	1312	2016-06-14 23:26:40
1313	online	NULL	NULL	1313	2016-06-15 10:48:55
1314	ticket_desk	2	NULL	1314	2016-06-16 16:05:19
1315	audio_guide_desk	NULL	2	1315	2016-06-16 16:48:08
1316	ticket_desk	1	NULL	1316	2016-06-17 10:05:29
1317	audio_guide_desk	NULL	1	1317	2016-06-17 10:40:21
1318	online	NULL	NULL	1318	2016-06-17 17:52:57
1319	ticket_desk	2	NULL	1319	2016-06-18 11:27:39
1320	online	NULL	NULL	1320	2016-06-18 21:00:22
1321	ticket_desk	1	NULL	1321	2016-06-19 14:15:50
1322	ticket_desk	2	NULL	1322	2016-06-20 10:07:44
1323	audio_guide_desk	NULL	3	1323	2016-06-20 10:54:05
1324	online	NULL	NULL	1324	2016-06-21 11:41:33
1325	online	NULL	NULL	1325	2016-06-22 10:32:21

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;