Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 726–750 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 726 | audio_guide_desk | NULL | 1 | 726 | 2015-10-16 13:03:47 |
| 727 | app_store | NULL | NULL | 727 | 2015-10-16 22:22:21 |
| 728 | online | NULL | NULL | 728 | 2015-10-17 07:40:21 |
| 729 | app_store | NULL | NULL | 729 | 2015-10-18 07:22:32 |
| 730 | ticket_desk | 2 | NULL | 730 | 2015-10-18 10:43:46 |
| 731 | ticket_desk | 2 | NULL | 731 | 2015-10-18 13:21:03 |
| 732 | online | NULL | NULL | 732 | 2015-10-18 17:12:16 |
| 733 | app_store | NULL | NULL | 733 | 2015-10-18 18:13:16 |
| 734 | ticket_desk | 5 | NULL | 734 | 2015-10-19 11:56:22 |
| 735 | audio_guide_desk | NULL | 2 | 735 | 2015-10-19 17:01:17 |
| 736 | online | NULL | NULL | 736 | 2015-10-20 11:56:19 |
| 737 | ticket_desk | 1 | NULL | 737 | 2015-10-20 14:34:30 |
| 738 | app_store | NULL | NULL | 738 | 2015-10-21 03:59:45 |
| 739 | ticket_desk | 3 | NULL | 739 | 2015-10-22 10:23:24 |
| 740 | app_store | NULL | NULL | 740 | 2015-10-22 15:07:09 |
| 741 | ticket_desk | 1 | NULL | 741 | 2015-10-23 10:22:30 |
| 742 | online | NULL | NULL | 742 | 2015-10-23 16:12:04 |
| 743 | online | NULL | NULL | 743 | 2015-10-23 18:59:06 |
| 744 | online | NULL | NULL | 744 | 2015-10-24 20:37:10 |
| 745 | app_store | NULL | NULL | 745 | 2015-10-25 07:35:00 |
| 746 | ticket_desk | 1 | NULL | 746 | 2015-10-25 09:09:40 |
| 747 | audio_guide_desk | NULL | 1 | 747 | 2015-10-26 13:32:42 |
| 748 | app_store | NULL | NULL | 748 | 2015-10-27 04:13:56 |
| 749 | app_store | NULL | NULL | 749 | 2015-10-28 04:14:59 |
| 750 | online | NULL | NULL | 750 | 2015-10-28 11:59:39 |
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;