Table

purchase_order

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

Replaces in 2020: Invoices

Rows 51–75 of 5,412

purchase_order, page 3 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
51	online	NULL	NULL	51	2015-03-20 16:14:05
52	ticket_desk	2	NULL	52	2015-03-21 10:13:28
53	audio_guide_desk	NULL	2	53	2015-03-21 10:59:54
54	ticket_desk	2	NULL	54	2015-03-21 11:42:35
55	ticket_desk	2	NULL	55	2015-03-22 10:21:34
56	online	NULL	NULL	56	2015-03-22 10:46:13
57	online	NULL	NULL	57	2015-03-24 08:42:24
58	online	NULL	NULL	58	2015-03-24 10:39:23
59	online	NULL	NULL	59	2015-03-24 18:57:56
60	app_store	NULL	NULL	60	2015-03-25 09:29:00
61	online	NULL	NULL	61	2015-03-25 10:51:07
62	app_store	NULL	NULL	62	2015-03-25 11:13:40
63	online	NULL	NULL	63	2015-03-25 12:18:32
64	app_store	NULL	NULL	64	2015-03-26 02:11:31
65	ticket_desk	2	NULL	65	2015-03-27 10:30:11
66	app_store	NULL	NULL	66	2015-03-27 11:57:40
67	ticket_desk	5	NULL	67	2015-03-27 12:03:02
68	audio_guide_desk	NULL	3	68	2015-03-27 12:16:41
69	ticket_desk	1	NULL	69	2015-03-27 12:40:39
70	audio_guide_desk	NULL	2	70	2015-03-27 13:32:10
71	app_store	NULL	NULL	71	2015-03-28 16:27:14
72	app_store	NULL	NULL	72	2015-03-28 23:57:56
73	app_store	NULL	NULL	73	2015-03-29 08:13:05
74	ticket_desk	1	NULL	74	2015-03-29 11:40:33
75	audio_guide_desk	NULL	2	75	2015-03-29 12:11:14

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;