Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 1,026–1,050 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1026 | online | NULL | NULL | 1026 | 2016-02-27 13:52:09 |
| 1027 | online | NULL | NULL | 1027 | 2016-02-28 08:19:45 |
| 1028 | online | NULL | NULL | 1028 | 2016-03-02 07:16:48 |
| 1029 | online | NULL | NULL | 1029 | 2016-03-02 08:32:37 |
| 1030 | ticket_desk | 1 | NULL | 1030 | 2016-03-02 16:28:17 |
| 1031 | online | NULL | NULL | 1031 | 2016-03-02 22:56:35 |
| 1032 | app_store | NULL | NULL | 1032 | 2016-03-03 08:28:50 |
| 1033 | app_store | NULL | NULL | 1033 | 2016-03-03 09:13:06 |
| 1034 | online | NULL | NULL | 1034 | 2016-03-03 10:00:33 |
| 1035 | app_store | NULL | NULL | 1035 | 2016-03-04 09:12:20 |
| 1036 | online | NULL | NULL | 1036 | 2016-03-04 20:32:58 |
| 1037 | audio_guide_desk | NULL | 2 | 1037 | 2016-03-05 13:22:17 |
| 1038 | ticket_desk | 1 | NULL | 1038 | 2016-03-06 10:21:14 |
| 1039 | ticket_desk | 4 | NULL | 1039 | 2016-03-06 10:28:13 |
| 1040 | app_store | NULL | NULL | 1040 | 2016-03-06 19:13:54 |
| 1041 | app_store | NULL | NULL | 1041 | 2016-03-07 06:29:20 |
| 1042 | online | NULL | NULL | 1042 | 2016-03-07 09:13:05 |
| 1043 | online | NULL | NULL | 1043 | 2016-03-07 12:27:28 |
| 1044 | online | NULL | NULL | 1044 | 2016-03-07 13:20:35 |
| 1045 | online | NULL | NULL | 1045 | 2016-03-08 14:00:09 |
| 1046 | online | NULL | NULL | 1046 | 2016-03-08 21:54:16 |
| 1047 | app_store | NULL | NULL | 1047 | 2016-03-09 01:00:29 |
| 1048 | audio_guide_desk | NULL | 3 | 1048 | 2016-03-09 13:18:18 |
| 1049 | online | NULL | NULL | 1049 | 2016-03-10 08:58:01 |
| 1050 | audio_guide_desk | NULL | 2 | 1050 | 2016-03-10 12:51:27 |
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;