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,101–1,125 of 5,412

purchase_order, page 45 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1101	ticket_desk	1	NULL	1101	2016-03-29 13:36:19
1102	app_store	NULL	NULL	1102	2016-03-30 01:14:44
1103	online	NULL	NULL	1103	2016-03-31 22:24:15
1104	online	NULL	NULL	1104	2016-04-01 11:14:57
1105	ticket_desk	2	NULL	1105	2016-04-01 11:22:33
1106	audio_guide_desk	NULL	2	1106	2016-04-01 12:05:19
1107	audio_guide_desk	NULL	2	1107	2016-04-01 14:24:41
1108	audio_guide_desk	NULL	2	1108	2016-04-01 14:26:18
1109	ticket_desk	2	NULL	1109	2016-04-01 16:11:52
1110	audio_guide_desk	NULL	2	1110	2016-04-01 17:04:03
1111	audio_guide_desk	NULL	2	1111	2016-04-03 13:11:19
1112	app_store	NULL	NULL	1112	2016-04-03 18:08:12
1113	app_store	NULL	NULL	1113	2016-04-04 06:44:32
1114	app_store	NULL	NULL	1114	2016-04-05 03:51:42
1115	online	NULL	NULL	1115	2016-04-05 11:32:29
1116	ticket_desk	1	NULL	1116	2016-04-05 11:35:08
1117	online	NULL	NULL	1117	2016-04-05 11:43:19
1118	ticket_desk	1	NULL	1118	2016-04-07 15:29:45
1119	ticket_desk	1	NULL	1119	2016-04-08 12:15:14
1120	online	NULL	NULL	1120	2016-04-09 15:09:21
1121	ticket_desk	1	NULL	1121	2016-04-10 11:13:34
1122	ticket_desk	2	NULL	1122	2016-04-10 12:43:36
1123	audio_guide_desk	NULL	1	1123	2016-04-10 13:08:11
1124	ticket_desk	2	NULL	1124	2016-04-10 14:41:26
1125	audio_guide_desk	NULL	2	1125	2016-04-10 15:10:48

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;