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,176–2,200 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2176 | ticket_desk | 2 | NULL | 2176 | 2017-05-20 09:21:07 |
| 2177 | audio_guide_desk | NULL | 2 | 2177 | 2017-05-20 13:27:38 |
| 2178 | app_store | NULL | NULL | 2178 | 2017-05-20 15:54:32 |
| 2179 | ticket_desk | 1 | NULL | 2179 | 2017-05-21 10:45:45 |
| 2180 | online | NULL | NULL | 2180 | 2017-05-21 19:22:39 |
| 2181 | app_store | NULL | NULL | 2181 | 2017-05-22 12:46:49 |
| 2182 | online | NULL | NULL | 2182 | 2017-05-22 12:53:55 |
| 2183 | app_store | NULL | NULL | 2183 | 2017-05-23 10:07:11 |
| 2184 | audio_guide_desk | NULL | 2 | 2184 | 2017-05-23 12:52:22 |
| 2185 | online | NULL | NULL | 2185 | 2017-05-23 16:21:37 |
| 2186 | ticket_desk | 1 | NULL | 2186 | 2017-05-25 14:17:14 |
| 2187 | audio_guide_desk | NULL | 2 | 2187 | 2017-05-27 15:19:46 |
| 2188 | online | NULL | NULL | 2188 | 2017-05-27 21:10:03 |
| 2189 | ticket_desk | 5 | NULL | 2189 | 2017-05-28 11:01:54 |
| 2190 | ticket_desk | 2 | NULL | 2190 | 2017-05-28 11:15:27 |
| 2191 | audio_guide_desk | NULL | 1 | 2191 | 2017-05-28 11:18:45 |
| 2192 | ticket_desk | 1 | NULL | 2192 | 2017-05-28 11:58:16 |
| 2193 | ticket_desk | 1 | NULL | 2193 | 2017-05-29 10:48:12 |
| 2194 | ticket_desk | 1 | NULL | 2194 | 2017-05-29 14:49:02 |
| 2195 | audio_guide_desk | NULL | 1 | 2195 | 2017-05-29 15:27:38 |
| 2196 | app_store | NULL | NULL | 2196 | 2017-05-29 19:55:40 |
| 2197 | app_store | NULL | NULL | 2197 | 2017-05-29 23:34:43 |
| 2198 | app_store | NULL | NULL | 2198 | 2017-05-31 06:32:28 |
| 2199 | online | NULL | NULL | 2199 | 2017-05-31 13:11:55 |
| 2200 | online | NULL | NULL | 2200 | 2017-05-31 19:03:55 |
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;