Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 226–250 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 226 | ticket_desk | 1 | NULL | 226 | 2015-05-16 08:57:40 |
| 227 | online | NULL | NULL | 227 | 2015-05-16 09:01:36 |
| 228 | ticket_desk | 1 | NULL | 228 | 2015-05-16 09:15:21 |
| 229 | audio_guide_desk | NULL | 2 | 229 | 2015-05-16 09:58:12 |
| 230 | app_store | NULL | NULL | 230 | 2015-05-16 13:19:42 |
| 231 | ticket_desk | 1 | NULL | 231 | 2015-05-16 14:44:43 |
| 232 | ticket_desk | 3 | NULL | 232 | 2015-05-17 13:30:58 |
| 233 | online | NULL | NULL | 233 | 2015-05-17 16:01:35 |
| 234 | app_store | NULL | NULL | 234 | 2015-05-18 00:50:25 |
| 235 | app_store | NULL | NULL | 235 | 2015-05-18 03:59:45 |
| 236 | ticket_desk | 5 | NULL | 236 | 2015-05-18 09:55:47 |
| 237 | audio_guide_desk | NULL | 2 | 237 | 2015-05-18 10:35:31 |
| 238 | audio_guide_desk | NULL | 1 | 238 | 2015-05-18 10:36:49 |
| 239 | ticket_desk | 4 | NULL | 239 | 2015-05-18 10:51:24 |
| 240 | ticket_desk | 3 | NULL | 240 | 2015-05-18 13:30:12 |
| 241 | app_store | NULL | NULL | 241 | 2015-05-19 09:16:09 |
| 242 | online | NULL | NULL | 242 | 2015-05-20 14:00:12 |
| 243 | ticket_desk | 1 | NULL | 243 | 2015-05-20 14:58:41 |
| 244 | ticket_desk | 2 | NULL | 244 | 2015-05-20 15:23:04 |
| 245 | audio_guide_desk | NULL | 3 | 245 | 2015-05-20 15:56:28 |
| 246 | online | NULL | NULL | 246 | 2015-05-20 18:20:27 |
| 247 | online | NULL | NULL | 247 | 2015-05-20 21:50:16 |
| 248 | app_store | NULL | NULL | 248 | 2015-05-20 23:37:14 |
| 249 | online | NULL | NULL | 249 | 2015-05-21 10:27:50 |
| 250 | ticket_desk | 1 | NULL | 250 | 2015-05-21 13:32:29 |
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;