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,776–3,800 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3776 | ticket_desk | 1 | NULL | 3776 | 2018-10-15 13:29:00 |
| 3777 | audio_guide_desk | NULL | 2 | 3777 | 2018-10-15 15:31:27 |
| 3778 | app_store | NULL | NULL | 3778 | 2018-10-15 21:32:02 |
| 3779 | online | NULL | NULL | 3779 | 2018-10-16 15:39:18 |
| 3780 | app_store | NULL | NULL | 3780 | 2018-10-16 20:21:20 |
| 3781 | online | NULL | NULL | 3781 | 2018-10-17 17:32:02 |
| 3782 | ticket_desk | 4 | NULL | 3782 | 2018-10-18 13:56:22 |
| 3783 | audio_guide_desk | NULL | 1 | 3783 | 2018-10-18 14:23:18 |
| 3784 | online | NULL | NULL | 3784 | 2018-10-18 14:56:11 |
| 3785 | online | NULL | NULL | 3785 | 2018-10-18 22:43:36 |
| 3786 | app_store | NULL | NULL | 3786 | 2018-10-18 23:51:57 |
| 3787 | app_store | NULL | NULL | 3787 | 2018-10-19 05:52:22 |
| 3788 | app_store | NULL | NULL | 3788 | 2018-10-19 10:51:43 |
| 3789 | online | NULL | NULL | 3789 | 2018-10-19 13:52:20 |
| 3790 | app_store | NULL | NULL | 3790 | 2018-10-19 14:00:47 |
| 3791 | online | NULL | NULL | 3791 | 2018-10-19 16:51:09 |
| 3792 | online | NULL | NULL | 3792 | 2018-10-19 16:54:55 |
| 3793 | app_store | NULL | NULL | 3793 | 2018-10-19 18:47:07 |
| 3794 | audio_guide_desk | NULL | 3 | 3794 | 2018-10-20 12:41:45 |
| 3795 | app_store | NULL | NULL | 3795 | 2018-10-20 18:14:37 |
| 3796 | ticket_desk | 1 | NULL | 3796 | 2018-10-21 14:42:02 |
| 3797 | online | NULL | NULL | 3797 | 2018-10-21 15:31:45 |
| 3798 | online | NULL | NULL | 3798 | 2018-10-22 08:32:01 |
| 3799 | app_store | NULL | NULL | 3799 | 2018-10-22 21:25:22 |
| 3800 | app_store | NULL | NULL | 3800 | 2018-10-23 10:38:42 |
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;