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,801–3,825 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3801 | audio_guide_desk | NULL | 2 | 3801 | 2018-10-23 12:45:49 |
| 3802 | app_store | NULL | NULL | 3802 | 2018-10-23 18:49:42 |
| 3803 | app_store | NULL | NULL | 3803 | 2018-10-24 08:43:08 |
| 3804 | online | NULL | NULL | 3804 | 2018-10-25 09:06:59 |
| 3805 | audio_guide_desk | NULL | 2 | 3805 | 2018-10-25 14:31:13 |
| 3806 | audio_guide_desk | NULL | 2 | 3806 | 2018-10-25 14:43:50 |
| 3807 | online | NULL | NULL | 3807 | 2018-10-25 16:06:51 |
| 3808 | online | NULL | NULL | 3808 | 2018-10-25 18:04:05 |
| 3809 | ticket_desk | 2 | NULL | 3809 | 2018-10-26 09:30:09 |
| 3810 | ticket_desk | 4 | NULL | 3810 | 2018-10-26 14:04:07 |
| 3811 | ticket_desk | 1 | NULL | 3811 | 2018-10-26 14:38:34 |
| 3812 | audio_guide_desk | NULL | 2 | 3812 | 2018-10-26 15:28:30 |
| 3813 | online | NULL | NULL | 3813 | 2018-10-27 07:09:29 |
| 3814 | online | NULL | NULL | 3814 | 2018-10-27 13:57:11 |
| 3815 | online | NULL | NULL | 3815 | 2018-10-27 14:42:39 |
| 3816 | online | NULL | NULL | 3816 | 2018-10-27 19:38:11 |
| 3817 | ticket_desk | 1 | NULL | 3817 | 2018-10-28 11:45:29 |
| 3818 | online | NULL | NULL | 3818 | 2018-10-28 14:02:10 |
| 3819 | online | NULL | NULL | 3819 | 2018-10-28 14:37:55 |
| 3820 | ticket_desk | 4 | NULL | 3820 | 2018-10-28 15:15:38 |
| 3821 | ticket_desk | 4 | NULL | 3821 | 2018-10-29 09:20:21 |
| 3822 | audio_guide_desk | NULL | 2 | 3822 | 2018-10-29 11:15:56 |
| 3823 | ticket_desk | 2 | NULL | 3823 | 2018-10-29 12:59:06 |
| 3824 | audio_guide_desk | NULL | 1 | 3824 | 2018-10-29 13:47:14 |
| 3825 | online | NULL | NULL | 3825 | 2018-10-30 20:04:45 |
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;