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,001–2,025 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2001 | ticket_desk | 2 | NULL | 2001 | 2017-03-17 14:14:36 |
| 2002 | audio_guide_desk | NULL | 2 | 2002 | 2017-03-17 14:56:43 |
| 2003 | ticket_desk | 1 | NULL | 2003 | 2017-03-18 11:28:45 |
| 2004 | online | NULL | NULL | 2004 | 2017-03-18 19:42:03 |
| 2005 | online | NULL | NULL | 2005 | 2017-03-18 20:50:32 |
| 2006 | online | NULL | NULL | 2006 | 2017-03-19 12:26:00 |
| 2007 | online | NULL | NULL | 2007 | 2017-03-21 10:19:29 |
| 2008 | ticket_desk | 2 | NULL | 2008 | 2017-03-21 10:27:27 |
| 2009 | app_store | NULL | NULL | 2009 | 2017-03-22 10:20:17 |
| 2010 | online | NULL | NULL | 2010 | 2017-03-22 11:57:09 |
| 2011 | app_store | NULL | NULL | 2011 | 2017-03-22 18:48:30 |
| 2012 | online | NULL | NULL | 2012 | 2017-03-23 07:41:14 |
| 2013 | online | NULL | NULL | 2013 | 2017-03-23 13:32:39 |
| 2014 | ticket_desk | 2 | NULL | 2014 | 2017-03-23 14:08:54 |
| 2015 | online | NULL | NULL | 2015 | 2017-03-24 20:00:27 |
| 2016 | ticket_desk | 3 | NULL | 2016 | 2017-03-25 09:50:54 |
| 2017 | audio_guide_desk | NULL | 2 | 2017 | 2017-03-25 11:16:21 |
| 2018 | audio_guide_desk | NULL | 1 | 2018 | 2017-03-25 13:11:47 |
| 2019 | audio_guide_desk | NULL | 3 | 2019 | 2017-03-25 15:16:46 |
| 2020 | audio_guide_desk | NULL | 2 | 2020 | 2017-03-25 15:41:27 |
| 2021 | online | NULL | NULL | 2021 | 2017-03-25 20:07:30 |
| 2022 | app_store | NULL | NULL | 2022 | 2017-03-26 08:36:03 |
| 2023 | app_store | NULL | NULL | 2023 | 2017-03-26 12:17:01 |
| 2024 | online | NULL | NULL | 2024 | 2017-03-26 21:21:31 |
| 2025 | online | NULL | NULL | 2025 | 2017-03-28 09:26:11 |
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;