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,401–1,425 of 5,412

purchase_order, page 57 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1401	online	NULL	NULL	1401	2016-07-16 10:35:58
1402	ticket_desk	2	NULL	1402	2016-07-16 13:41:03
1403	audio_guide_desk	NULL	3	1403	2016-07-16 14:23:12
1404	audio_guide_desk	NULL	2	1404	2016-07-16 14:51:27
1405	app_store	NULL	NULL	1405	2016-07-16 23:11:16
1406	online	NULL	NULL	1406	2016-07-17 07:48:42
1407	audio_guide_desk	NULL	1	1407	2016-07-17 10:07:58
1408	ticket_desk	2	NULL	1408	2016-07-17 13:32:41
1409	online	NULL	NULL	1409	2016-07-17 22:00:06
1410	app_store	NULL	NULL	1410	2016-07-18 00:41:12
1411	audio_guide_desk	NULL	2	1411	2016-07-18 15:29:10
1412	audio_guide_desk	NULL	2	1412	2016-07-18 15:30:20
1413	app_store	NULL	NULL	1413	2016-07-19 00:11:07
1414	online	NULL	NULL	1414	2016-07-19 12:45:58
1415	ticket_desk	1	NULL	1415	2016-07-19 13:53:03
1416	audio_guide_desk	NULL	2	1416	2016-07-19 14:16:46
1417	online	NULL	NULL	1417	2016-07-19 18:05:28
1418	online	NULL	NULL	1418	2016-07-19 18:18:37
1419	app_store	NULL	NULL	1419	2016-07-20 03:20:54
1420	ticket_desk	1	NULL	1420	2016-07-20 09:53:55
1421	ticket_desk	4	NULL	1421	2016-07-20 16:13:10
1422	online	NULL	NULL	1422	2016-07-20 19:08:56
1423	app_store	NULL	NULL	1423	2016-07-20 19:49:35
1424	online	NULL	NULL	1424	2016-07-20 22:13:59
1425	ticket_desk	4	NULL	1425	2016-07-21 15:26:37

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;