Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,876–2,900 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2876 | app_store | NULL | NULL | 2876 | 2018-01-26 21:37:26 |
| 2877 | app_store | NULL | NULL | 2877 | 2018-01-28 01:12:59 |
| 2878 | app_store | NULL | NULL | 2878 | 2018-01-29 02:57:33 |
| 2879 | online | NULL | NULL | 2879 | 2018-01-29 08:07:40 |
| 2880 | ticket_desk | 2 | NULL | 2880 | 2018-01-29 09:39:08 |
| 2881 | audio_guide_desk | NULL | 3 | 2881 | 2018-01-29 14:23:43 |
| 2882 | app_store | NULL | NULL | 2882 | 2018-01-31 00:17:59 |
| 2883 | online | NULL | NULL | 2883 | 2018-02-01 13:29:21 |
| 2884 | app_store | NULL | NULL | 2884 | 2018-02-02 21:00:01 |
| 2885 | app_store | NULL | NULL | 2885 | 2018-02-02 21:57:40 |
| 2886 | app_store | NULL | NULL | 2886 | 2018-02-03 12:18:31 |
| 2887 | app_store | NULL | NULL | 2887 | 2018-02-03 15:05:44 |
| 2888 | online | NULL | NULL | 2888 | 2018-02-03 15:30:29 |
| 2889 | app_store | NULL | NULL | 2889 | 2018-02-03 15:42:32 |
| 2890 | online | NULL | NULL | 2890 | 2018-02-03 18:43:28 |
| 2891 | app_store | NULL | NULL | 2891 | 2018-02-03 23:46:55 |
| 2892 | ticket_desk | 4 | NULL | 2892 | 2018-02-04 10:31:54 |
| 2893 | audio_guide_desk | NULL | 2 | 2893 | 2018-02-04 11:17:04 |
| 2894 | app_store | NULL | NULL | 2894 | 2018-02-05 12:08:31 |
| 2895 | online | NULL | NULL | 2895 | 2018-02-05 16:34:28 |
| 2896 | app_store | NULL | NULL | 2896 | 2018-02-05 19:12:27 |
| 2897 | ticket_desk | 3 | NULL | 2897 | 2018-02-06 09:32:56 |
| 2898 | app_store | NULL | NULL | 2898 | 2018-02-06 16:26:39 |
| 2899 | online | NULL | NULL | 2899 | 2018-02-06 16:34:46 |
| 2900 | online | NULL | NULL | 2900 | 2018-02-07 20:22:43 |
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;