Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 926–950 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 926 | app_store | NULL | NULL | 926 | 2015-12-31 06:03:56 |
| 927 | ticket_desk | 1 | NULL | 927 | 2015-12-31 10:09:50 |
| 928 | ticket_desk | 3 | NULL | 928 | 2015-12-31 12:10:53 |
| 929 | audio_guide_desk | NULL | 3 | 929 | 2015-12-31 12:58:27 |
| 930 | online | NULL | NULL | 930 | 2015-12-31 14:57:33 |
| 931 | online | NULL | NULL | 931 | 2015-12-31 22:24:19 |
| 932 | app_store | NULL | NULL | 932 | 2016-01-01 13:39:29 |
| 933 | online | NULL | NULL | 933 | 2016-01-01 22:53:21 |
| 934 | online | NULL | NULL | 934 | 2016-01-02 08:47:23 |
| 935 | ticket_desk | 2 | NULL | 935 | 2016-01-03 09:34:06 |
| 936 | audio_guide_desk | NULL | 1 | 936 | 2016-01-03 12:46:50 |
| 937 | online | NULL | NULL | 937 | 2016-01-05 09:31:03 |
| 938 | online | NULL | NULL | 938 | 2016-01-05 09:53:42 |
| 939 | ticket_desk | 3 | NULL | 939 | 2016-01-05 10:40:51 |
| 940 | audio_guide_desk | NULL | 1 | 940 | 2016-01-05 11:24:15 |
| 941 | audio_guide_desk | NULL | 1 | 941 | 2016-01-05 11:25:50 |
| 942 | online | NULL | NULL | 942 | 2016-01-06 09:52:23 |
| 943 | app_store | NULL | NULL | 943 | 2016-01-07 07:20:06 |
| 944 | online | NULL | NULL | 944 | 2016-01-07 09:09:56 |
| 945 | online | NULL | NULL | 945 | 2016-01-07 09:54:49 |
| 946 | app_store | NULL | NULL | 946 | 2016-01-07 17:23:26 |
| 947 | app_store | NULL | NULL | 947 | 2016-01-08 03:16:42 |
| 948 | ticket_desk | 2 | NULL | 948 | 2016-01-10 12:08:38 |
| 949 | online | NULL | NULL | 949 | 2016-01-10 16:27:50 |
| 950 | audio_guide_desk | NULL | 2 | 950 | 2016-01-12 12:02: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;