Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 1,226–1,250 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1226 | online | NULL | NULL | 1226 | 2016-05-14 21:26:52 |
| 1227 | app_store | NULL | NULL | 1227 | 2016-05-14 23:24:03 |
| 1228 | online | NULL | NULL | 1228 | 2016-05-15 13:05:06 |
| 1229 | online | NULL | NULL | 1229 | 2016-05-15 22:54:40 |
| 1230 | online | NULL | NULL | 1230 | 2016-05-16 09:56:50 |
| 1231 | ticket_desk | 1 | NULL | 1231 | 2016-05-16 11:28:36 |
| 1232 | app_store | NULL | NULL | 1232 | 2016-05-16 14:23:17 |
| 1233 | online | NULL | NULL | 1233 | 2016-05-17 13:21:51 |
| 1234 | online | NULL | NULL | 1234 | 2016-05-17 14:57:32 |
| 1235 | app_store | NULL | NULL | 1235 | 2016-05-17 15:48:02 |
| 1236 | app_store | NULL | NULL | 1236 | 2016-05-17 18:18:28 |
| 1237 | online | NULL | NULL | 1237 | 2016-05-17 22:37:20 |
| 1238 | ticket_desk | 1 | NULL | 1238 | 2016-05-18 11:07:34 |
| 1239 | audio_guide_desk | NULL | 2 | 1239 | 2016-05-18 11:40:41 |
| 1240 | online | NULL | NULL | 1240 | 2016-05-18 13:56:40 |
| 1241 | audio_guide_desk | NULL | 2 | 1241 | 2016-05-18 15:00:05 |
| 1242 | app_store | NULL | NULL | 1242 | 2016-05-19 22:07:35 |
| 1243 | audio_guide_desk | NULL | 2 | 1243 | 2016-05-20 10:51:31 |
| 1244 | online | NULL | NULL | 1244 | 2016-05-21 11:59:41 |
| 1245 | online | NULL | NULL | 1245 | 2016-05-22 11:58:37 |
| 1246 | app_store | NULL | NULL | 1246 | 2016-05-22 23:46:37 |
| 1247 | audio_guide_desk | NULL | 2 | 1247 | 2016-05-23 09:23:16 |
| 1248 | audio_guide_desk | NULL | 2 | 1248 | 2016-05-23 09:34:21 |
| 1249 | online | NULL | NULL | 1249 | 2016-05-23 11:31:01 |
| 1250 | online | NULL | NULL | 1250 | 2016-05-24 21:17:15 |
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;