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,476–1,500 of 5,412

purchase_order, page 60 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1476	ticket_desk	1	NULL	1476	2016-08-06 14:21:02
1477	online	NULL	NULL	1477	2016-08-06 15:17:58
1478	audio_guide_desk	NULL	3	1478	2016-08-07 10:01:43
1479	ticket_desk	1	NULL	1479	2016-08-07 11:58:00
1480	audio_guide_desk	NULL	2	1480	2016-08-07 12:27:26
1481	online	NULL	NULL	1481	2016-08-07 14:05:03
1482	ticket_desk	4	NULL	1482	2016-08-09 14:12:16
1483	audio_guide_desk	NULL	2	1483	2016-08-09 15:30:00
1484	app_store	NULL	NULL	1484	2016-08-10 07:52:47
1485	app_store	NULL	NULL	1485	2016-08-10 15:52:49
1486	ticket_desk	1	NULL	1486	2016-08-11 10:27:40
1487	ticket_desk	1	NULL	1487	2016-08-11 10:55:10
1488	audio_guide_desk	NULL	3	1488	2016-08-11 11:22:05
1489	ticket_desk	2	NULL	1489	2016-08-11 11:33:32
1490	ticket_desk	1	NULL	1490	2016-08-11 12:56:15
1491	audio_guide_desk	NULL	2	1491	2016-08-11 13:40:10
1492	online	NULL	NULL	1492	2016-08-12 15:13:07
1493	online	NULL	NULL	1493	2016-08-12 21:38:51
1494	ticket_desk	1	NULL	1494	2016-08-13 10:08:32
1495	audio_guide_desk	NULL	2	1495	2016-08-13 10:36:50
1496	online	NULL	NULL	1496	2016-08-13 13:47:25
1497	audio_guide_desk	NULL	2	1497	2016-08-13 14:49:39
1498	ticket_desk	1	NULL	1498	2016-08-14 08:26:34
1499	ticket_desk	4	NULL	1499	2016-08-14 10:39:53
1500	audio_guide_desk	NULL	2	1500	2016-08-14 11:17:40

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;