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,801–2,825 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2801 | audio_guide_desk | NULL | 1 | 2801 | 2018-01-02 10:32:46 |
| 2802 | audio_guide_desk | NULL | 1 | 2802 | 2018-01-02 10:36:55 |
| 2803 | online | NULL | NULL | 2803 | 2018-01-02 16:46:25 |
| 2804 | online | NULL | NULL | 2804 | 2018-01-03 07:36:20 |
| 2805 | online | NULL | NULL | 2805 | 2018-01-03 21:30:02 |
| 2806 | online | NULL | NULL | 2806 | 2018-01-04 09:19:29 |
| 2807 | online | NULL | NULL | 2807 | 2018-01-04 10:34:57 |
| 2808 | online | NULL | NULL | 2808 | 2018-01-04 23:46:15 |
| 2809 | online | NULL | NULL | 2809 | 2018-01-05 11:20:42 |
| 2810 | audio_guide_desk | NULL | 2 | 2810 | 2018-01-05 12:10:45 |
| 2811 | audio_guide_desk | NULL | 2 | 2811 | 2018-01-06 11:28:35 |
| 2812 | online | NULL | NULL | 2812 | 2018-01-06 16:10:02 |
| 2813 | online | NULL | NULL | 2813 | 2018-01-06 23:06:03 |
| 2814 | online | NULL | NULL | 2814 | 2018-01-06 23:25:29 |
| 2815 | online | NULL | NULL | 2815 | 2018-01-07 08:59:06 |
| 2816 | audio_guide_desk | NULL | 2 | 2816 | 2018-01-07 13:41:15 |
| 2817 | online | NULL | NULL | 2817 | 2018-01-07 14:35:08 |
| 2818 | online | NULL | NULL | 2818 | 2018-01-09 07:58:38 |
| 2819 | ticket_desk | 2 | NULL | 2819 | 2018-01-09 11:22:43 |
| 2820 | audio_guide_desk | NULL | 2 | 2820 | 2018-01-09 11:51:41 |
| 2821 | ticket_desk | 3 | NULL | 2821 | 2018-01-10 09:33:27 |
| 2822 | audio_guide_desk | NULL | 2 | 2822 | 2018-01-10 10:29:53 |
| 2823 | app_store | NULL | NULL | 2823 | 2018-01-10 11:23:22 |
| 2824 | online | NULL | NULL | 2824 | 2018-01-10 11:38:12 |
| 2825 | app_store | NULL | NULL | 2825 | 2018-01-11 08:32: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;