Table

purchase_order

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

Replaces in 2020: Invoices

Rows 376–400 of 5,412

purchase_order, page 16 of 217
order_idINTEGER	channelTEXT	entrance_id→ entrance.entrance_id	wing_id→ wing.wing_id	payment_id→ payment.payment_id	ordered_atTEXT
376	ticket_desk	2	NULL	376	2015-07-05 11:28:02
377	online	NULL	NULL	377	2015-07-05 20:53:29
378	app_store	NULL	NULL	378	2015-07-06 02:55:16
379	ticket_desk	2	NULL	379	2015-07-06 09:02:56
380	ticket_desk	5	NULL	380	2015-07-06 11:13:15
381	ticket_desk	1	NULL	381	2015-07-07 12:03:37
382	app_store	NULL	NULL	382	2015-07-07 19:38:01
383	ticket_desk	5	NULL	383	2015-07-08 12:29:02
384	audio_guide_desk	NULL	2	384	2015-07-08 13:00:20
385	online	NULL	NULL	385	2015-07-08 17:24:26
386	app_store	NULL	NULL	386	2015-07-08 22:58:34
387	ticket_desk	4	NULL	387	2015-07-09 10:41:45
388	audio_guide_desk	NULL	2	388	2015-07-09 11:16:03
389	online	NULL	NULL	389	2015-07-09 21:47:54
390	ticket_desk	1	NULL	390	2015-07-10 10:17:32
391	ticket_desk	1	NULL	391	2015-07-10 11:27:13
392	audio_guide_desk	NULL	2	392	2015-07-10 12:15:51
393	ticket_desk	1	NULL	393	2015-07-11 09:37:45
394	ticket_desk	2	NULL	394	2015-07-11 10:05:23
395	audio_guide_desk	NULL	2	395	2015-07-11 10:08:34
396	ticket_desk	4	NULL	396	2015-07-11 10:53:56
397	audio_guide_desk	NULL	1	397	2015-07-11 11:46:52
398	online	NULL	NULL	398	2015-07-11 19:36:05
399	online	NULL	NULL	399	2015-07-11 21:05:04
400	app_store	NULL	NULL	400	2015-07-12 00:49:50

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;