Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,976–5,000 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4976 | online | NULL | NULL | 4976 | 2019-10-20 10:22:33 |
| 4977 | online | NULL | NULL | 4977 | 2019-10-20 14:26:18 |
| 4978 | online | NULL | NULL | 4978 | 2019-10-21 09:06:10 |
| 4979 | online | NULL | NULL | 4979 | 2019-10-21 16:03:26 |
| 4980 | app_store | NULL | NULL | 4980 | 2019-10-21 19:06:33 |
| 4981 | audio_guide_desk | NULL | 2 | 4981 | 2019-10-22 11:51:37 |
| 4982 | online | NULL | NULL | 4982 | 2019-10-22 18:13:30 |
| 4983 | online | NULL | NULL | 4983 | 2019-10-22 20:45:00 |
| 4984 | app_store | NULL | NULL | 4984 | 2019-10-23 03:10:59 |
| 4985 | online | NULL | NULL | 4985 | 2019-10-23 08:22:18 |
| 4986 | app_store | NULL | NULL | 4986 | 2019-10-23 11:44:57 |
| 4987 | ticket_desk | 1 | NULL | 4987 | 2019-10-23 13:39:19 |
| 4988 | online | NULL | NULL | 4988 | 2019-10-23 20:28:27 |
| 4989 | app_store | NULL | NULL | 4989 | 2019-10-24 08:23:44 |
| 4990 | online | NULL | NULL | 4990 | 2019-10-24 15:23:34 |
| 4991 | app_store | NULL | NULL | 4991 | 2019-10-24 20:51:58 |
| 4992 | audio_guide_desk | NULL | 1 | 4992 | 2019-10-25 09:54:46 |
| 4993 | online | NULL | NULL | 4993 | 2019-10-25 13:13:59 |
| 4994 | online | NULL | NULL | 4994 | 2019-10-25 15:03:45 |
| 4995 | audio_guide_desk | NULL | 3 | 4995 | 2019-10-26 10:45:01 |
| 4996 | audio_guide_desk | NULL | 3 | 4996 | 2019-10-26 11:49:26 |
| 4997 | audio_guide_desk | NULL | 2 | 4997 | 2019-10-26 15:07:17 |
| 4998 | app_store | NULL | NULL | 4998 | 2019-10-27 01:36:15 |
| 4999 | ticket_desk | 2 | NULL | 4999 | 2019-10-27 14:38:44 |
| 5000 | online | NULL | NULL | 5000 | 2019-10-27 17:02:33 |
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;