Table

purchase_order

One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.

Replaces in 2020: Invoices

Rows 26–50 of 5,412

purchase_order, page 2 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
26	audio_guide_desk	NULL	2	26	2015-03-07 11:18:13
27	ticket_desk	3	NULL	27	2015-03-08 09:47:16
28	audio_guide_desk	NULL	2	28	2015-03-08 14:42:49
29	audio_guide_desk	NULL	2	29	2015-03-08 14:45:10
30	audio_guide_desk	NULL	2	30	2015-03-09 17:03:51
31	online	NULL	NULL	31	2015-03-10 11:31:40
32	online	NULL	NULL	32	2015-03-10 11:32:12
33	online	NULL	NULL	33	2015-03-10 15:48:34
34	ticket_desk	1	NULL	34	2015-03-12 11:42:32
35	ticket_desk	1	NULL	35	2015-03-13 10:19:45
36	app_store	NULL	NULL	36	2015-03-13 12:49:37
37	app_store	NULL	NULL	37	2015-03-14 01:36:31
38	ticket_desk	2	NULL	38	2015-03-14 11:27:48
39	ticket_desk	2	NULL	39	2015-03-14 13:02:15
40	audio_guide_desk	NULL	2	40	2015-03-14 13:52:33
41	audio_guide_desk	NULL	3	41	2015-03-15 13:51:07
42	online	NULL	NULL	42	2015-03-15 14:23:41
43	app_store	NULL	NULL	43	2015-03-16 01:35:49
44	online	NULL	NULL	44	2015-03-17 22:55:18
45	app_store	NULL	NULL	45	2015-03-17 23:36:46
46	app_store	NULL	NULL	46	2015-03-18 04:57:13
47	online	NULL	NULL	47	2015-03-19 09:18:55
48	app_store	NULL	NULL	48	2015-03-19 10:45:24
49	online	NULL	NULL	49	2015-03-19 15:52:17
50	app_store	NULL	NULL	50	2015-03-20 05:32:22

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;