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,901–3,925 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3901 | ticket_desk | 1 | NULL | 3901 | 2018-11-24 09:43:35 |
| 3902 | audio_guide_desk | NULL | 2 | 3902 | 2018-11-24 10:27:22 |
| 3903 | online | NULL | NULL | 3903 | 2018-11-24 15:43:21 |
| 3904 | online | NULL | NULL | 3904 | 2018-11-25 18:58:59 |
| 3905 | app_store | NULL | NULL | 3905 | 2018-11-26 01:46:00 |
| 3906 | app_store | NULL | NULL | 3906 | 2018-11-26 07:32:54 |
| 3907 | ticket_desk | 3 | NULL | 3907 | 2018-11-26 10:23:14 |
| 3908 | audio_guide_desk | NULL | 2 | 3908 | 2018-11-26 10:59:57 |
| 3909 | ticket_desk | 1 | NULL | 3909 | 2018-11-26 11:38:47 |
| 3910 | audio_guide_desk | NULL | 2 | 3910 | 2018-11-26 12:27:57 |
| 3911 | online | NULL | NULL | 3911 | 2018-11-26 13:01:17 |
| 3912 | online | NULL | NULL | 3912 | 2018-11-26 22:40:25 |
| 3913 | online | NULL | NULL | 3913 | 2018-11-27 13:13:48 |
| 3914 | online | NULL | NULL | 3914 | 2018-11-27 17:11:14 |
| 3915 | online | NULL | NULL | 3915 | 2018-11-27 17:45:33 |
| 3916 | app_store | NULL | NULL | 3916 | 2018-11-28 04:28:31 |
| 3917 | audio_guide_desk | NULL | 2 | 3917 | 2018-11-28 11:11:03 |
| 3918 | online | NULL | NULL | 3918 | 2018-11-28 14:24:19 |
| 3919 | audio_guide_desk | NULL | 3 | 3919 | 2018-11-29 10:32:11 |
| 3920 | online | NULL | NULL | 3920 | 2018-11-29 13:25:13 |
| 3921 | app_store | NULL | NULL | 3921 | 2018-11-29 14:59:21 |
| 3922 | online | NULL | NULL | 3922 | 2018-11-29 17:05:41 |
| 3923 | online | NULL | NULL | 3923 | 2018-11-29 17:11:30 |
| 3924 | audio_guide_desk | NULL | 2 | 3924 | 2018-11-30 09:26:17 |
| 3925 | ticket_desk | 5 | NULL | 3925 | 2018-11-30 12:34:12 |
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;