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,126–2,150 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2126 | online | NULL | NULL | 2126 | 2017-05-02 07:02:06 |
| 2127 | ticket_desk | 1 | NULL | 2127 | 2017-05-02 09:37:53 |
| 2128 | ticket_desk | 1 | NULL | 2128 | 2017-05-02 10:11:01 |
| 2129 | audio_guide_desk | NULL | 1 | 2129 | 2017-05-02 10:41:56 |
| 2130 | online | NULL | NULL | 2130 | 2017-05-03 19:29:18 |
| 2131 | app_store | NULL | NULL | 2131 | 2017-05-04 07:08:47 |
| 2132 | ticket_desk | 2 | NULL | 2132 | 2017-05-04 11:20:21 |
| 2133 | ticket_desk | 5 | NULL | 2133 | 2017-05-05 10:47:49 |
| 2134 | app_store | NULL | NULL | 2134 | 2017-05-05 15:06:04 |
| 2135 | online | NULL | NULL | 2135 | 2017-05-05 19:33:12 |
| 2136 | app_store | NULL | NULL | 2136 | 2017-05-05 22:29:11 |
| 2137 | audio_guide_desk | NULL | 3 | 2137 | 2017-05-06 09:45:48 |
| 2138 | ticket_desk | 2 | NULL | 2138 | 2017-05-06 14:40:15 |
| 2139 | online | NULL | NULL | 2139 | 2017-05-06 17:07:37 |
| 2140 | online | NULL | NULL | 2140 | 2017-05-07 09:21:24 |
| 2141 | online | NULL | NULL | 2141 | 2017-05-07 18:33:02 |
| 2142 | online | NULL | NULL | 2142 | 2017-05-07 22:01:11 |
| 2143 | ticket_desk | 2 | NULL | 2143 | 2017-05-08 10:42:28 |
| 2144 | ticket_desk | 3 | NULL | 2144 | 2017-05-08 13:39:25 |
| 2145 | online | NULL | NULL | 2145 | 2017-05-08 14:05:08 |
| 2146 | online | NULL | NULL | 2146 | 2017-05-08 16:03:23 |
| 2147 | online | NULL | NULL | 2147 | 2017-05-09 07:07:51 |
| 2148 | online | NULL | NULL | 2148 | 2017-05-10 12:44:44 |
| 2149 | online | NULL | NULL | 2149 | 2017-05-11 10:26:39 |
| 2150 | ticket_desk | 1 | NULL | 2150 | 2017-05-11 10:33:43 |
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;