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,726–2,750 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2726 | online | NULL | NULL | 2726 | 2017-11-29 18:13:05 |
| 2727 | online | NULL | NULL | 2727 | 2017-11-29 18:31:48 |
| 2728 | app_store | NULL | NULL | 2728 | 2017-11-30 21:58:39 |
| 2729 | ticket_desk | 2 | NULL | 2729 | 2017-12-01 11:54:53 |
| 2730 | audio_guide_desk | NULL | 2 | 2730 | 2017-12-01 12:03:04 |
| 2731 | audio_guide_desk | NULL | 1 | 2731 | 2017-12-01 12:26:21 |
| 2732 | online | NULL | NULL | 2732 | 2017-12-01 23:50:44 |
| 2733 | online | NULL | NULL | 2733 | 2017-12-01 23:58:30 |
| 2734 | online | NULL | NULL | 2734 | 2017-12-02 10:14:46 |
| 2735 | app_store | NULL | NULL | 2735 | 2017-12-03 11:00:24 |
| 2736 | online | NULL | NULL | 2736 | 2017-12-04 12:21:14 |
| 2737 | app_store | NULL | NULL | 2737 | 2017-12-05 02:15:56 |
| 2738 | online | NULL | NULL | 2738 | 2017-12-05 16:31:18 |
| 2739 | app_store | NULL | NULL | 2739 | 2017-12-06 12:13:02 |
| 2740 | app_store | NULL | NULL | 2740 | 2017-12-08 09:16:13 |
| 2741 | ticket_desk | 4 | NULL | 2741 | 2017-12-08 11:39:57 |
| 2742 | online | NULL | NULL | 2742 | 2017-12-08 18:30:09 |
| 2743 | audio_guide_desk | NULL | 3 | 2743 | 2017-12-09 12:08:01 |
| 2744 | audio_guide_desk | NULL | 3 | 2744 | 2017-12-09 12:13:40 |
| 2745 | app_store | NULL | NULL | 2745 | 2017-12-09 22:36:54 |
| 2746 | app_store | NULL | NULL | 2746 | 2017-12-10 03:27:41 |
| 2747 | online | NULL | NULL | 2747 | 2017-12-10 09:44:39 |
| 2748 | audio_guide_desk | NULL | 2 | 2748 | 2017-12-10 11:07:16 |
| 2749 | online | NULL | NULL | 2749 | 2017-12-10 13:24:01 |
| 2750 | ticket_desk | 2 | NULL | 2750 | 2017-12-10 15:57:38 |
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;