Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 876–900 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 876 | online | NULL | NULL | 876 | 2015-12-14 11:38:57 |
| 877 | online | NULL | NULL | 877 | 2015-12-14 23:20:29 |
| 878 | ticket_desk | 2 | NULL | 878 | 2015-12-15 10:09:39 |
| 879 | audio_guide_desk | NULL | 2 | 879 | 2015-12-15 11:03:28 |
| 880 | online | NULL | NULL | 880 | 2015-12-15 20:37:52 |
| 881 | app_store | NULL | NULL | 881 | 2015-12-16 02:50:05 |
| 882 | online | NULL | NULL | 882 | 2015-12-16 12:29:07 |
| 883 | ticket_desk | 1 | NULL | 883 | 2015-12-18 09:30:41 |
| 884 | ticket_desk | 1 | NULL | 884 | 2015-12-18 13:09:22 |
| 885 | online | NULL | NULL | 885 | 2015-12-18 15:19:25 |
| 886 | audio_guide_desk | NULL | 3 | 886 | 2015-12-18 16:37:03 |
| 887 | ticket_desk | 5 | NULL | 887 | 2015-12-19 09:33:51 |
| 888 | ticket_desk | 1 | NULL | 888 | 2015-12-19 14:21:52 |
| 889 | ticket_desk | 2 | NULL | 889 | 2015-12-19 15:19:15 |
| 890 | audio_guide_desk | NULL | 3 | 890 | 2015-12-19 15:48:56 |
| 891 | online | NULL | NULL | 891 | 2015-12-19 20:17:01 |
| 892 | app_store | NULL | NULL | 892 | 2015-12-19 22:31:25 |
| 893 | app_store | NULL | NULL | 893 | 2015-12-20 06:32:02 |
| 894 | online | NULL | NULL | 894 | 2015-12-20 08:50:29 |
| 895 | online | NULL | NULL | 895 | 2015-12-20 15:10:53 |
| 896 | ticket_desk | 1 | NULL | 896 | 2015-12-21 12:20:40 |
| 897 | ticket_desk | 4 | NULL | 897 | 2015-12-21 14:36:01 |
| 898 | online | NULL | NULL | 898 | 2015-12-22 07:33:11 |
| 899 | ticket_desk | 5 | NULL | 899 | 2015-12-22 10:01:52 |
| 900 | online | NULL | NULL | 900 | 2015-12-22 11:21:41 |
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;