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,676–2,700 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2676 | ticket_desk | 1 | NULL | 2676 | 2017-11-07 11:26:02 |
| 2677 | online | NULL | NULL | 2677 | 2017-11-09 14:05:26 |
| 2678 | app_store | NULL | NULL | 2678 | 2017-11-10 03:33:24 |
| 2679 | ticket_desk | 2 | NULL | 2679 | 2017-11-10 08:50:13 |
| 2680 | online | NULL | NULL | 2680 | 2017-11-11 14:51:07 |
| 2681 | ticket_desk | 1 | NULL | 2681 | 2017-11-12 10:09:50 |
| 2682 | ticket_desk | 2 | NULL | 2682 | 2017-11-13 09:49:24 |
| 2683 | app_store | NULL | NULL | 2683 | 2017-11-14 01:25:10 |
| 2684 | online | NULL | NULL | 2684 | 2017-11-14 23:03:08 |
| 2685 | app_store | NULL | NULL | 2685 | 2017-11-15 06:58:29 |
| 2686 | ticket_desk | 2 | NULL | 2686 | 2017-11-17 11:44:47 |
| 2687 | online | NULL | NULL | 2687 | 2017-11-17 17:51:16 |
| 2688 | app_store | NULL | NULL | 2688 | 2017-11-17 22:05:19 |
| 2689 | audio_guide_desk | NULL | 2 | 2689 | 2017-11-18 10:21:46 |
| 2690 | online | NULL | NULL | 2690 | 2017-11-18 17:24:38 |
| 2691 | online | NULL | NULL | 2691 | 2017-11-18 18:45:09 |
| 2692 | online | NULL | NULL | 2692 | 2017-11-19 13:26:46 |
| 2693 | app_store | NULL | NULL | 2693 | 2017-11-20 05:23:02 |
| 2694 | online | NULL | NULL | 2694 | 2017-11-20 15:49:17 |
| 2695 | online | NULL | NULL | 2695 | 2017-11-20 15:49:26 |
| 2696 | online | NULL | NULL | 2696 | 2017-11-20 23:20:58 |
| 2697 | audio_guide_desk | NULL | 3 | 2697 | 2017-11-21 09:54:18 |
| 2698 | ticket_desk | 2 | NULL | 2698 | 2017-11-21 10:51:29 |
| 2699 | app_store | NULL | NULL | 2699 | 2017-11-21 16:12:00 |
| 2700 | ticket_desk | 4 | NULL | 2700 | 2017-11-22 09:21:13 |
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;