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,276–2,300 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2276 | ticket_desk | 5 | NULL | 2276 | 2017-06-21 11:44:29 |
| 2277 | online | NULL | NULL | 2277 | 2017-06-22 07:10:29 |
| 2278 | online | NULL | NULL | 2278 | 2017-06-22 12:34:07 |
| 2279 | audio_guide_desk | NULL | 2 | 2279 | 2017-06-22 14:55:04 |
| 2280 | app_store | NULL | NULL | 2280 | 2017-06-22 20:01:44 |
| 2281 | online | NULL | NULL | 2281 | 2017-06-23 10:50:08 |
| 2282 | online | NULL | NULL | 2282 | 2017-06-23 15:53:26 |
| 2283 | online | NULL | NULL | 2283 | 2017-06-23 20:55:28 |
| 2284 | online | NULL | NULL | 2284 | 2017-06-23 23:14:14 |
| 2285 | app_store | NULL | NULL | 2285 | 2017-06-24 03:35:00 |
| 2286 | audio_guide_desk | NULL | 2 | 2286 | 2017-06-24 11:25:31 |
| 2287 | app_store | NULL | NULL | 2287 | 2017-06-25 05:24:50 |
| 2288 | online | NULL | NULL | 2288 | 2017-06-25 08:12:07 |
| 2289 | ticket_desk | 1 | NULL | 2289 | 2017-06-25 11:05:10 |
| 2290 | ticket_desk | 1 | NULL | 2290 | 2017-06-25 13:28:27 |
| 2291 | audio_guide_desk | NULL | 3 | 2291 | 2017-06-25 14:00:21 |
| 2292 | ticket_desk | 1 | NULL | 2292 | 2017-06-25 14:28:04 |
| 2293 | app_store | NULL | NULL | 2293 | 2017-06-25 23:55:50 |
| 2294 | online | NULL | NULL | 2294 | 2017-06-26 07:17:16 |
| 2295 | online | NULL | NULL | 2295 | 2017-06-26 08:35:38 |
| 2296 | online | NULL | NULL | 2296 | 2017-06-26 10:18:23 |
| 2297 | audio_guide_desk | NULL | 2 | 2297 | 2017-06-26 10:59:07 |
| 2298 | app_store | NULL | NULL | 2298 | 2017-06-27 08:22:55 |
| 2299 | online | NULL | NULL | 2299 | 2017-06-28 08:29:26 |
| 2300 | app_store | NULL | NULL | 2300 | 2017-06-28 14:09:52 |
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;