Table

purchase_order

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

Replaces in 2020: Invoices

Rows 801–825 of 5,412

purchase_order, page 33 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
801	ticket_desk	2	NULL	801	2015-11-17 15:37:37
802	audio_guide_desk	NULL	1	802	2015-11-17 16:06:31
803	online	NULL	NULL	803	2015-11-17 17:39:28
804	online	NULL	NULL	804	2015-11-17 19:43:54
805	audio_guide_desk	NULL	2	805	2015-11-18 10:12:02
806	audio_guide_desk	NULL	2	806	2015-11-18 10:24:08
807	app_store	NULL	NULL	807	2015-11-19 04:42:05
808	audio_guide_desk	NULL	2	808	2015-11-19 13:27:49
809	app_store	NULL	NULL	809	2015-11-20 00:08:37
810	online	NULL	NULL	810	2015-11-20 18:18:35
811	online	NULL	NULL	811	2015-11-21 09:49:02
812	ticket_desk	2	NULL	812	2015-11-21 10:53:11
813	online	NULL	NULL	813	2015-11-21 13:12:26
814	audio_guide_desk	NULL	1	814	2015-11-21 13:17:25
815	ticket_desk	4	NULL	815	2015-11-21 14:32:53
816	ticket_desk	3	NULL	816	2015-11-22 08:58:45
817	audio_guide_desk	NULL	2	817	2015-11-22 15:10:03
818	ticket_desk	1	NULL	818	2015-11-24 11:29:21
819	audio_guide_desk	NULL	1	819	2015-11-24 12:07:10
820	online	NULL	NULL	820	2015-11-24 13:18:07
821	audio_guide_desk	NULL	2	821	2015-11-24 14:13:52
822	online	NULL	NULL	822	2015-11-26 10:42:28
823	ticket_desk	2	NULL	823	2015-11-26 14:11:00
824	ticket_desk	5	NULL	824	2015-11-27 09:46:55
825	ticket_desk	1	NULL	825	2015-11-27 15:04:18

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;