Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 3,276–3,300 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3276 | ticket_desk | 4 | NULL | 3276 | 2018-05-30 11:29:23 |
| 3277 | audio_guide_desk | NULL | 1 | 3277 | 2018-05-30 12:00:32 |
| 3278 | online | NULL | NULL | 3278 | 2018-05-30 12:55:15 |
| 3279 | app_store | NULL | NULL | 3279 | 2018-05-30 13:42:57 |
| 3280 | app_store | NULL | NULL | 3280 | 2018-05-30 21:39:26 |
| 3281 | online | NULL | NULL | 3281 | 2018-05-31 09:52:38 |
| 3282 | ticket_desk | 1 | NULL | 3282 | 2018-05-31 10:56:35 |
| 3283 | ticket_desk | 2 | NULL | 3283 | 2018-05-31 12:12:46 |
| 3284 | online | NULL | NULL | 3284 | 2018-05-31 14:32:14 |
| 3285 | online | NULL | NULL | 3285 | 2018-05-31 15:05:42 |
| 3286 | online | NULL | NULL | 3286 | 2018-06-01 10:35:27 |
| 3287 | audio_guide_desk | NULL | 1 | 3287 | 2018-06-01 10:51:07 |
| 3288 | online | NULL | NULL | 3288 | 2018-06-01 17:14:38 |
| 3289 | online | NULL | NULL | 3289 | 2018-06-01 23:03:22 |
| 3290 | app_store | NULL | NULL | 3290 | 2018-06-02 00:38:56 |
| 3291 | audio_guide_desk | NULL | 1 | 3291 | 2018-06-02 12:03:31 |
| 3292 | audio_guide_desk | NULL | 2 | 3292 | 2018-06-02 12:43:48 |
| 3293 | ticket_desk | 1 | NULL | 3293 | 2018-06-02 13:49:33 |
| 3294 | audio_guide_desk | NULL | 3 | 3294 | 2018-06-02 14:29:21 |
| 3295 | online | NULL | NULL | 3295 | 2018-06-02 19:11:07 |
| 3296 | online | NULL | NULL | 3296 | 2018-06-02 19:24:46 |
| 3297 | online | NULL | NULL | 3297 | 2018-06-03 20:14:33 |
| 3298 | app_store | NULL | NULL | 3298 | 2018-06-04 07:13:27 |
| 3299 | ticket_desk | 1 | NULL | 3299 | 2018-06-04 10:16:05 |
| 3300 | app_store | NULL | NULL | 3300 | 2018-06-05 04:13: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;