Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 901–925 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 901 | online | NULL | NULL | 901 | 2015-12-22 11:45:12 |
| 902 | app_store | NULL | NULL | 902 | 2015-12-22 12:17:48 |
| 903 | ticket_desk | 4 | NULL | 903 | 2015-12-22 14:55:10 |
| 904 | audio_guide_desk | NULL | 2 | 904 | 2015-12-22 15:42:06 |
| 905 | app_store | NULL | NULL | 905 | 2015-12-23 04:47:33 |
| 906 | ticket_desk | 4 | NULL | 906 | 2015-12-23 08:32:41 |
| 907 | online | NULL | NULL | 907 | 2015-12-23 17:04:09 |
| 908 | online | NULL | NULL | 908 | 2015-12-23 20:53:56 |
| 909 | app_store | NULL | NULL | 909 | 2015-12-23 23:12:51 |
| 910 | app_store | NULL | NULL | 910 | 2015-12-24 16:23:49 |
| 911 | online | NULL | NULL | 911 | 2015-12-24 21:53:03 |
| 912 | app_store | NULL | NULL | 912 | 2015-12-26 06:18:11 |
| 913 | ticket_desk | 4 | NULL | 913 | 2015-12-26 08:58:00 |
| 914 | online | NULL | NULL | 914 | 2015-12-26 09:50:03 |
| 915 | ticket_desk | 2 | NULL | 915 | 2015-12-26 12:17:58 |
| 916 | ticket_desk | 3 | NULL | 916 | 2015-12-27 10:28:49 |
| 917 | ticket_desk | 1 | NULL | 917 | 2015-12-27 10:59:36 |
| 918 | audio_guide_desk | NULL | 3 | 918 | 2015-12-27 11:40:29 |
| 919 | online | NULL | NULL | 919 | 2015-12-27 12:42:38 |
| 920 | ticket_desk | 5 | NULL | 920 | 2015-12-28 12:17:07 |
| 921 | online | NULL | NULL | 921 | 2015-12-28 13:52:56 |
| 922 | ticket_desk | 1 | NULL | 922 | 2015-12-29 10:31:32 |
| 923 | app_store | NULL | NULL | 923 | 2015-12-29 23:25:23 |
| 924 | ticket_desk | 1 | NULL | 924 | 2015-12-30 15:07:33 |
| 925 | ticket_desk | 1 | NULL | 925 | 2015-12-30 16:19:21 |
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;