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,151–2,175 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2151 | audio_guide_desk | NULL | 2 | 2151 | 2017-05-11 10:58:08 |
| 2152 | online | NULL | NULL | 2152 | 2017-05-11 11:40:01 |
| 2153 | ticket_desk | 3 | NULL | 2153 | 2017-05-11 14:06:42 |
| 2154 | ticket_desk | 2 | NULL | 2154 | 2017-05-11 15:40:11 |
| 2155 | online | NULL | NULL | 2155 | 2017-05-11 17:23:36 |
| 2156 | ticket_desk | 2 | NULL | 2156 | 2017-05-12 09:01:26 |
| 2157 | audio_guide_desk | NULL | 2 | 2157 | 2017-05-12 09:28:47 |
| 2158 | online | NULL | NULL | 2158 | 2017-05-12 09:57:03 |
| 2159 | ticket_desk | 3 | NULL | 2159 | 2017-05-12 13:43:03 |
| 2160 | audio_guide_desk | NULL | 2 | 2160 | 2017-05-12 14:28:47 |
| 2161 | online | NULL | NULL | 2161 | 2017-05-12 16:35:24 |
| 2162 | ticket_desk | 1 | NULL | 2162 | 2017-05-13 15:18:05 |
| 2163 | audio_guide_desk | NULL | 2 | 2163 | 2017-05-13 15:51:15 |
| 2164 | online | NULL | NULL | 2164 | 2017-05-14 15:43:41 |
| 2165 | app_store | NULL | NULL | 2165 | 2017-05-14 17:55:47 |
| 2166 | online | NULL | NULL | 2166 | 2017-05-14 20:15:12 |
| 2167 | online | NULL | NULL | 2167 | 2017-05-15 12:36:18 |
| 2168 | app_store | NULL | NULL | 2168 | 2017-05-16 10:19:43 |
| 2169 | online | NULL | NULL | 2169 | 2017-05-17 14:47:01 |
| 2170 | ticket_desk | 1 | NULL | 2170 | 2017-05-18 09:08:56 |
| 2171 | online | NULL | NULL | 2171 | 2017-05-18 21:58:25 |
| 2172 | app_store | NULL | NULL | 2172 | 2017-05-19 06:12:47 |
| 2173 | ticket_desk | 1 | NULL | 2173 | 2017-05-19 10:50:08 |
| 2174 | app_store | NULL | NULL | 2174 | 2017-05-20 03:34:18 |
| 2175 | app_store | NULL | NULL | 2175 | 2017-05-20 08:46:46 |
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;