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,851–2,875 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2851 | app_store | NULL | NULL | 2851 | 2018-01-19 06:55:50 |
| 2852 | app_store | NULL | NULL | 2852 | 2018-01-19 16:44:07 |
| 2853 | online | NULL | NULL | 2853 | 2018-01-19 19:53:03 |
| 2854 | app_store | NULL | NULL | 2854 | 2018-01-20 06:05:26 |
| 2855 | ticket_desk | 1 | NULL | 2855 | 2018-01-20 10:54:10 |
| 2856 | audio_guide_desk | NULL | 2 | 2856 | 2018-01-20 11:08:55 |
| 2857 | online | NULL | NULL | 2857 | 2018-01-21 08:31:25 |
| 2858 | online | NULL | NULL | 2858 | 2018-01-21 18:12:55 |
| 2859 | app_store | NULL | NULL | 2859 | 2018-01-21 20:06:42 |
| 2860 | app_store | NULL | NULL | 2860 | 2018-01-22 03:58:24 |
| 2861 | ticket_desk | 2 | NULL | 2861 | 2018-01-22 09:03:31 |
| 2862 | audio_guide_desk | NULL | 2 | 2862 | 2018-01-22 12:49:00 |
| 2863 | audio_guide_desk | NULL | 2 | 2863 | 2018-01-22 12:50:36 |
| 2864 | online | NULL | NULL | 2864 | 2018-01-22 13:15:25 |
| 2865 | ticket_desk | 2 | NULL | 2865 | 2018-01-22 13:58:35 |
| 2866 | online | NULL | NULL | 2866 | 2018-01-22 15:03:10 |
| 2867 | ticket_desk | 1 | NULL | 2867 | 2018-01-23 08:47:43 |
| 2868 | audio_guide_desk | NULL | 2 | 2868 | 2018-01-23 09:21:48 |
| 2869 | online | NULL | NULL | 2869 | 2018-01-23 13:40:22 |
| 2870 | online | NULL | NULL | 2870 | 2018-01-23 15:56:10 |
| 2871 | ticket_desk | 3 | NULL | 2871 | 2018-01-24 13:16:18 |
| 2872 | app_store | NULL | NULL | 2872 | 2018-01-24 17:06:16 |
| 2873 | online | NULL | NULL | 2873 | 2018-01-25 08:01:52 |
| 2874 | online | NULL | NULL | 2874 | 2018-01-26 08:57:57 |
| 2875 | online | NULL | NULL | 2875 | 2018-01-26 09:21:59 |
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;