Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,076–2,100 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2076 | online | NULL | NULL | 2076 | 2017-04-17 12:59:43 |
| 2077 | app_store | NULL | NULL | 2077 | 2017-04-17 14:00:35 |
| 2078 | online | NULL | NULL | 2078 | 2017-04-18 07:08:35 |
| 2079 | audio_guide_desk | NULL | 2 | 2079 | 2017-04-18 12:55:58 |
| 2080 | app_store | NULL | NULL | 2080 | 2017-04-18 14:14:12 |
| 2081 | online | NULL | NULL | 2081 | 2017-04-18 19:47:25 |
| 2082 | audio_guide_desk | NULL | 2 | 2082 | 2017-04-19 14:47:16 |
| 2083 | ticket_desk | 4 | NULL | 2083 | 2017-04-19 16:12:02 |
| 2084 | online | NULL | NULL | 2084 | 2017-04-20 10:03:41 |
| 2085 | online | NULL | NULL | 2085 | 2017-04-20 19:01:16 |
| 2086 | online | NULL | NULL | 2086 | 2017-04-21 09:56:57 |
| 2087 | online | NULL | NULL | 2087 | 2017-04-21 12:28:44 |
| 2088 | online | NULL | NULL | 2088 | 2017-04-21 19:43:21 |
| 2089 | audio_guide_desk | NULL | 3 | 2089 | 2017-04-22 09:55:47 |
| 2090 | online | NULL | NULL | 2090 | 2017-04-22 11:49:06 |
| 2091 | online | NULL | NULL | 2091 | 2017-04-22 14:02:40 |
| 2092 | online | NULL | NULL | 2092 | 2017-04-22 17:43:59 |
| 2093 | app_store | NULL | NULL | 2093 | 2017-04-22 18:57:36 |
| 2094 | ticket_desk | 1 | NULL | 2094 | 2017-04-23 11:03:21 |
| 2095 | ticket_desk | 2 | NULL | 2095 | 2017-04-23 13:49:19 |
| 2096 | audio_guide_desk | NULL | 2 | 2096 | 2017-04-23 14:04:41 |
| 2097 | audio_guide_desk | NULL | 3 | 2097 | 2017-04-23 14:12:07 |
| 2098 | app_store | NULL | NULL | 2098 | 2017-04-23 16:38:10 |
| 2099 | online | NULL | NULL | 2099 | 2017-04-23 19:34:52 |
| 2100 | app_store | NULL | NULL | 2100 | 2017-04-24 06:03: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;