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,201–2,225 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2201 | online | NULL | NULL | 2201 | 2017-05-31 21:24:52 |
| 2202 | online | NULL | NULL | 2202 | 2017-06-01 21:03:36 |
| 2203 | app_store | NULL | NULL | 2203 | 2017-06-02 13:49:27 |
| 2204 | online | NULL | NULL | 2204 | 2017-06-02 14:33:24 |
| 2205 | app_store | NULL | NULL | 2205 | 2017-06-03 16:25:30 |
| 2206 | online | NULL | NULL | 2206 | 2017-06-03 23:00:09 |
| 2207 | app_store | NULL | NULL | 2207 | 2017-06-04 06:36:10 |
| 2208 | audio_guide_desk | NULL | 1 | 2208 | 2017-06-04 10:32:13 |
| 2209 | ticket_desk | 1 | NULL | 2209 | 2017-06-04 11:17:03 |
| 2210 | online | NULL | NULL | 2210 | 2017-06-04 11:23:19 |
| 2211 | app_store | NULL | NULL | 2211 | 2017-06-04 15:07:40 |
| 2212 | ticket_desk | 1 | NULL | 2212 | 2017-06-05 10:35:17 |
| 2213 | audio_guide_desk | NULL | 1 | 2213 | 2017-06-05 10:40:57 |
| 2214 | audio_guide_desk | NULL | 2 | 2214 | 2017-06-05 10:58:50 |
| 2215 | online | NULL | NULL | 2215 | 2017-06-05 21:07:15 |
| 2216 | ticket_desk | 1 | NULL | 2216 | 2017-06-06 08:50:53 |
| 2217 | audio_guide_desk | NULL | 2 | 2217 | 2017-06-06 09:28:53 |
| 2218 | ticket_desk | 1 | NULL | 2218 | 2017-06-06 10:02:41 |
| 2219 | audio_guide_desk | NULL | 2 | 2219 | 2017-06-06 10:28:44 |
| 2220 | audio_guide_desk | NULL | 2 | 2220 | 2017-06-06 10:33:09 |
| 2221 | ticket_desk | 1 | NULL | 2221 | 2017-06-06 10:40:21 |
| 2222 | ticket_desk | 1 | NULL | 2222 | 2017-06-06 11:36:49 |
| 2223 | audio_guide_desk | NULL | 2 | 2223 | 2017-06-06 13:07:19 |
| 2224 | audio_guide_desk | NULL | 2 | 2224 | 2017-06-06 13:13:49 |
| 2225 | online | NULL | NULL | 2225 | 2017-06-07 08:05:58 |
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;