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,101–2,125 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2101 | ticket_desk | 3 | NULL | 2101 | 2017-04-24 09:01:45 |
| 2102 | audio_guide_desk | NULL | 3 | 2102 | 2017-04-24 09:28:21 |
| 2103 | audio_guide_desk | NULL | 3 | 2103 | 2017-04-24 09:30:43 |
| 2104 | audio_guide_desk | NULL | 3 | 2104 | 2017-04-24 09:31:16 |
| 2105 | ticket_desk | 5 | NULL | 2105 | 2017-04-24 12:37:52 |
| 2106 | online | NULL | NULL | 2106 | 2017-04-24 18:25:41 |
| 2107 | online | NULL | NULL | 2107 | 2017-04-25 21:02:18 |
| 2108 | app_store | NULL | NULL | 2108 | 2017-04-26 06:18:16 |
| 2109 | app_store | NULL | NULL | 2109 | 2017-04-26 13:00:27 |
| 2110 | online | NULL | NULL | 2110 | 2017-04-27 12:15:14 |
| 2111 | ticket_desk | 1 | NULL | 2111 | 2017-04-28 09:36:48 |
| 2112 | online | NULL | NULL | 2112 | 2017-04-28 17:25:02 |
| 2113 | online | NULL | NULL | 2113 | 2017-04-28 22:24:41 |
| 2114 | online | NULL | NULL | 2114 | 2017-04-28 22:40:48 |
| 2115 | ticket_desk | 2 | NULL | 2115 | 2017-04-29 09:03:40 |
| 2116 | audio_guide_desk | NULL | 1 | 2116 | 2017-04-29 09:34:58 |
| 2117 | audio_guide_desk | NULL | 2 | 2117 | 2017-04-29 12:37:04 |
| 2118 | audio_guide_desk | NULL | 2 | 2118 | 2017-04-29 12:41:17 |
| 2119 | app_store | NULL | NULL | 2119 | 2017-04-29 18:42:15 |
| 2120 | ticket_desk | 2 | NULL | 2120 | 2017-04-30 12:17:53 |
| 2121 | audio_guide_desk | NULL | 3 | 2121 | 2017-04-30 12:36:07 |
| 2122 | online | NULL | NULL | 2122 | 2017-04-30 12:38:04 |
| 2123 | online | NULL | NULL | 2123 | 2017-04-30 20:47:30 |
| 2124 | online | NULL | NULL | 2124 | 2017-04-30 20:50:23 |
| 2125 | app_store | NULL | NULL | 2125 | 2017-05-02 06:02:14 |
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;