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,701–3,725 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3701 | ticket_desk | 2 | NULL | 3701 | 2018-09-25 12:25:22 |
| 3702 | ticket_desk | 2 | NULL | 3702 | 2018-09-25 14:30:57 |
| 3703 | online | NULL | NULL | 3703 | 2018-09-25 22:18:29 |
| 3704 | online | NULL | NULL | 3704 | 2018-09-26 07:03:11 |
| 3705 | ticket_desk | 4 | NULL | 3705 | 2018-09-26 08:28:04 |
| 3706 | audio_guide_desk | NULL | 2 | 3706 | 2018-09-26 09:08:41 |
| 3707 | audio_guide_desk | NULL | 3 | 3707 | 2018-09-26 09:57:14 |
| 3708 | audio_guide_desk | NULL | 1 | 3708 | 2018-09-26 10:50:48 |
| 3709 | ticket_desk | 2 | NULL | 3709 | 2018-09-26 11:15:43 |
| 3710 | audio_guide_desk | NULL | 2 | 3710 | 2018-09-26 11:48:51 |
| 3711 | app_store | NULL | NULL | 3711 | 2018-09-26 14:35:20 |
| 3712 | app_store | NULL | NULL | 3712 | 2018-09-26 23:49:48 |
| 3713 | online | NULL | NULL | 3713 | 2018-09-27 09:56:26 |
| 3714 | audio_guide_desk | NULL | 1 | 3714 | 2018-09-27 11:01:52 |
| 3715 | online | NULL | NULL | 3715 | 2018-09-27 20:08:48 |
| 3716 | ticket_desk | 5 | NULL | 3716 | 2018-09-28 13:59:01 |
| 3717 | audio_guide_desk | NULL | 3 | 3717 | 2018-09-28 14:39:46 |
| 3718 | online | NULL | NULL | 3718 | 2018-09-28 18:40:42 |
| 3719 | app_store | NULL | NULL | 3719 | 2018-09-29 03:13:57 |
| 3720 | online | NULL | NULL | 3720 | 2018-09-29 07:48:40 |
| 3721 | online | NULL | NULL | 3721 | 2018-09-29 11:57:52 |
| 3722 | online | NULL | NULL | 3722 | 2018-09-29 18:39:17 |
| 3723 | app_store | NULL | NULL | 3723 | 2018-09-29 22:59:03 |
| 3724 | online | NULL | NULL | 3724 | 2018-09-29 23:46:30 |
| 3725 | app_store | NULL | NULL | 3725 | 2018-09-30 04:01:05 |
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;