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,926–4,950 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4926 | online | NULL | NULL | 4926 | 2019-10-05 13:26:17 |
| 4927 | online | NULL | NULL | 4927 | 2019-10-06 07:27:42 |
| 4928 | ticket_desk | 1 | NULL | 4928 | 2019-10-06 12:46:30 |
| 4929 | online | NULL | NULL | 4929 | 2019-10-06 18:52:50 |
| 4930 | audio_guide_desk | NULL | 3 | 4930 | 2019-10-07 09:41:26 |
| 4931 | online | NULL | NULL | 4931 | 2019-10-08 07:10:44 |
| 4932 | online | NULL | NULL | 4932 | 2019-10-08 09:48:50 |
| 4933 | audio_guide_desk | NULL | 1 | 4933 | 2019-10-08 11:16:53 |
| 4934 | audio_guide_desk | NULL | 1 | 4934 | 2019-10-08 11:18:38 |
| 4935 | online | NULL | NULL | 4935 | 2019-10-08 12:52:42 |
| 4936 | online | NULL | NULL | 4936 | 2019-10-08 15:49:54 |
| 4937 | online | NULL | NULL | 4937 | 2019-10-08 18:10:40 |
| 4938 | online | NULL | NULL | 4938 | 2019-10-08 20:20:13 |
| 4939 | app_store | NULL | NULL | 4939 | 2019-10-08 22:35:49 |
| 4940 | ticket_desk | 2 | NULL | 4940 | 2019-10-09 09:30:29 |
| 4941 | online | NULL | NULL | 4941 | 2019-10-10 14:41:03 |
| 4942 | online | NULL | NULL | 4942 | 2019-10-10 19:30:39 |
| 4943 | online | NULL | NULL | 4943 | 2019-10-11 07:00:59 |
| 4944 | audio_guide_desk | NULL | 1 | 4944 | 2019-10-11 10:44:14 |
| 4945 | audio_guide_desk | NULL | 1 | 4945 | 2019-10-11 10:52:46 |
| 4946 | online | NULL | NULL | 4946 | 2019-10-11 22:08:46 |
| 4947 | app_store | NULL | NULL | 4947 | 2019-10-12 01:24:55 |
| 4948 | online | NULL | NULL | 4948 | 2019-10-12 14:21:47 |
| 4949 | app_store | NULL | NULL | 4949 | 2019-10-13 02:52:06 |
| 4950 | online | NULL | NULL | 4950 | 2019-10-13 09:12:42 |
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;