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,251–1,275 of 5,412

purchase_order, page 51 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1251	app_store	NULL	NULL	1251	2016-05-25 06:50:37
1252	online	NULL	NULL	1252	2016-05-25 07:00:47
1253	audio_guide_desk	NULL	2	1253	2016-05-25 10:45:36
1254	online	NULL	NULL	1254	2016-05-25 13:25:40
1255	ticket_desk	4	NULL	1255	2016-05-26 11:23:40
1256	audio_guide_desk	NULL	1	1256	2016-05-26 11:39:58
1257	ticket_desk	2	NULL	1257	2016-05-26 13:41:26
1258	online	NULL	NULL	1258	2016-05-26 18:05:31
1259	ticket_desk	1	NULL	1259	2016-05-28 09:56:48
1260	audio_guide_desk	NULL	1	1260	2016-05-28 10:54:19
1261	ticket_desk	2	NULL	1261	2016-05-28 15:01:07
1262	audio_guide_desk	NULL	2	1262	2016-05-28 15:34:43
1263	online	NULL	NULL	1263	2016-05-29 10:25:33
1264	audio_guide_desk	NULL	2	1264	2016-05-29 12:26:46
1265	ticket_desk	3	NULL	1265	2016-05-29 12:42:49
1266	audio_guide_desk	NULL	2	1266	2016-05-29 15:03:54
1267	ticket_desk	2	NULL	1267	2016-05-29 15:33:00
1268	online	NULL	NULL	1268	2016-05-31 15:54:02
1269	app_store	NULL	NULL	1269	2016-05-31 16:10:00
1270	online	NULL	NULL	1270	2016-05-31 18:29:10
1271	ticket_desk	1	NULL	1271	2016-06-01 09:46:52
1272	ticket_desk	3	NULL	1272	2016-06-01 13:51:16
1273	ticket_desk	2	NULL	1273	2016-06-02 09:14:42
1274	audio_guide_desk	NULL	2	1274	2016-06-02 09:42:15
1275	ticket_desk	2	NULL	1275	2016-06-02 10:34:44

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;