Table

purchase_order

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

Replaces in 2020: Invoices

Rows 76–100 of 5,412

purchase_order, page 4 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
76	online	NULL	NULL	76	2015-03-29 14:48:55
77	online	NULL	NULL	77	2015-03-29 15:15:54
78	ticket_desk	2	NULL	78	2015-03-30 11:21:11
79	online	NULL	NULL	79	2015-03-30 18:45:11
80	audio_guide_desk	NULL	1	80	2015-03-31 14:25:28
81	audio_guide_desk	NULL	2	81	2015-03-31 14:30:49
82	app_store	NULL	NULL	82	2015-03-31 19:53:08
83	ticket_desk	5	NULL	83	2015-04-01 09:32:43
84	online	NULL	NULL	84	2015-04-01 10:21:30
85	ticket_desk	4	NULL	85	2015-04-01 13:56:46
86	audio_guide_desk	NULL	3	86	2015-04-01 14:30:52
87	online	NULL	NULL	87	2015-04-01 18:55:46
88	online	NULL	NULL	88	2015-04-01 21:10:14
89	ticket_desk	1	NULL	89	2015-04-02 15:10:15
90	online	NULL	NULL	90	2015-04-02 15:25:42
91	online	NULL	NULL	91	2015-04-03 14:59:24
92	app_store	NULL	NULL	92	2015-04-03 21:48:25
93	ticket_desk	1	NULL	93	2015-04-04 09:33:13
94	audio_guide_desk	NULL	3	94	2015-04-04 10:34:18
95	app_store	NULL	NULL	95	2015-04-04 11:15:39
96	ticket_desk	3	NULL	96	2015-04-04 14:04:25
97	app_store	NULL	NULL	97	2015-04-04 20:39:20
98	online	NULL	NULL	98	2015-04-05 07:59:55
99	ticket_desk	3	NULL	99	2015-04-05 09:06:10
100	ticket_desk	2	NULL	100	2015-04-05 09:28:28

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;