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,126–1,150 of 5,412

purchase_order, page 46 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
1126	online	NULL	NULL	1126	2016-04-10 17:44:01
1127	online	NULL	NULL	1127	2016-04-10 20:54:27
1128	online	NULL	NULL	1128	2016-04-11 22:33:06
1129	app_store	NULL	NULL	1129	2016-04-12 03:04:07
1130	app_store	NULL	NULL	1130	2016-04-12 13:47:19
1131	online	NULL	NULL	1131	2016-04-12 18:39:33
1132	online	NULL	NULL	1132	2016-04-13 10:19:47
1133	app_store	NULL	NULL	1133	2016-04-13 15:57:25
1134	online	NULL	NULL	1134	2016-04-13 20:37:35
1135	ticket_desk	2	NULL	1135	2016-04-14 13:34:51
1136	audio_guide_desk	NULL	2	1136	2016-04-16 10:19:16
1137	ticket_desk	2	NULL	1137	2016-04-16 12:20:33
1138	audio_guide_desk	NULL	1	1138	2016-04-16 13:06:04
1139	ticket_desk	1	NULL	1139	2016-04-16 15:30:08
1140	online	NULL	NULL	1140	2016-04-16 17:50:28
1141	ticket_desk	1	NULL	1141	2016-04-17 09:45:31
1142	audio_guide_desk	NULL	2	1142	2016-04-17 10:25:09
1143	audio_guide_desk	NULL	2	1143	2016-04-17 10:34:45
1144	online	NULL	NULL	1144	2016-04-18 18:32:11
1145	ticket_desk	2	NULL	1145	2016-04-19 08:35:31
1146	online	NULL	NULL	1146	2016-04-19 09:07:26
1147	audio_guide_desk	NULL	2	1147	2016-04-19 09:15:18
1148	ticket_desk	4	NULL	1148	2016-04-19 10:13:07
1149	online	NULL	NULL	1149	2016-04-19 19:48:27
1150	online	NULL	NULL	1150	2016-04-20 18:23:45

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;