Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 251–275 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 251 | audio_guide_desk | NULL | 2 | 251 | 2015-05-21 14:20:00 |
| 252 | ticket_desk | 1 | NULL | 252 | 2015-05-22 09:59:50 |
| 253 | audio_guide_desk | NULL | 2 | 253 | 2015-05-22 10:15:37 |
| 254 | audio_guide_desk | NULL | 2 | 254 | 2015-05-22 10:59:42 |
| 255 | ticket_desk | 1 | NULL | 255 | 2015-05-22 11:08:59 |
| 256 | audio_guide_desk | NULL | 2 | 256 | 2015-05-22 14:15:40 |
| 257 | ticket_desk | 1 | NULL | 257 | 2015-05-22 15:26:45 |
| 258 | ticket_desk | 4 | NULL | 258 | 2015-05-23 10:05:54 |
| 259 | online | NULL | NULL | 259 | 2015-05-23 19:26:30 |
| 260 | ticket_desk | 2 | NULL | 260 | 2015-05-24 09:20:10 |
| 261 | online | NULL | NULL | 261 | 2015-05-24 20:08:41 |
| 262 | audio_guide_desk | NULL | 2 | 262 | 2015-05-25 11:13:52 |
| 263 | audio_guide_desk | NULL | 2 | 263 | 2015-05-25 11:19:14 |
| 264 | ticket_desk | 5 | NULL | 264 | 2015-05-25 15:11:29 |
| 265 | ticket_desk | 1 | NULL | 265 | 2015-05-25 15:20:52 |
| 266 | app_store | NULL | NULL | 266 | 2015-05-26 15:36:35 |
| 267 | online | NULL | NULL | 267 | 2015-05-28 09:38:18 |
| 268 | app_store | NULL | NULL | 268 | 2015-05-28 13:07:51 |
| 269 | app_store | NULL | NULL | 269 | 2015-05-28 18:33:26 |
| 270 | ticket_desk | 5 | NULL | 270 | 2015-05-29 10:27:59 |
| 271 | audio_guide_desk | NULL | 2 | 271 | 2015-05-29 11:05:49 |
| 272 | audio_guide_desk | NULL | 2 | 272 | 2015-05-31 16:12:36 |
| 273 | online | NULL | NULL | 273 | 2015-05-31 16:39:05 |
| 274 | ticket_desk | 1 | NULL | 274 | 2015-06-01 12:44:41 |
| 275 | online | NULL | NULL | 275 | 2015-06-02 14:17:35 |
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;