Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,651–2,675 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2651 | online | NULL | NULL | 2651 | 2017-10-25 20:13:15 |
| 2652 | ticket_desk | 4 | NULL | 2652 | 2017-10-26 09:54:40 |
| 2653 | online | NULL | NULL | 2653 | 2017-10-26 22:29:50 |
| 2654 | online | NULL | NULL | 2654 | 2017-10-27 17:27:56 |
| 2655 | audio_guide_desk | NULL | 2 | 2655 | 2017-10-28 10:16:13 |
| 2656 | audio_guide_desk | NULL | 2 | 2656 | 2017-10-28 11:01:48 |
| 2657 | online | NULL | NULL | 2657 | 2017-10-28 16:41:49 |
| 2658 | online | NULL | NULL | 2658 | 2017-10-28 19:00:34 |
| 2659 | online | NULL | NULL | 2659 | 2017-10-29 17:04:29 |
| 2660 | online | NULL | NULL | 2660 | 2017-10-29 19:52:09 |
| 2661 | ticket_desk | 3 | NULL | 2661 | 2017-10-30 10:09:11 |
| 2662 | ticket_desk | 5 | NULL | 2662 | 2017-10-31 10:08:42 |
| 2663 | online | NULL | NULL | 2663 | 2017-11-01 07:24:17 |
| 2664 | audio_guide_desk | NULL | 2 | 2664 | 2017-11-02 11:13:41 |
| 2665 | app_store | NULL | NULL | 2665 | 2017-11-02 19:59:37 |
| 2666 | app_store | NULL | NULL | 2666 | 2017-11-03 10:41:15 |
| 2667 | app_store | NULL | NULL | 2667 | 2017-11-03 17:26:29 |
| 2668 | app_store | NULL | NULL | 2668 | 2017-11-04 06:12:51 |
| 2669 | audio_guide_desk | NULL | 1 | 2669 | 2017-11-04 12:10:48 |
| 2670 | app_store | NULL | NULL | 2670 | 2017-11-05 01:58:35 |
| 2671 | online | NULL | NULL | 2671 | 2017-11-05 17:15:40 |
| 2672 | online | NULL | NULL | 2672 | 2017-11-06 08:03:49 |
| 2673 | app_store | NULL | NULL | 2673 | 2017-11-06 09:14:57 |
| 2674 | app_store | NULL | NULL | 2674 | 2017-11-06 10:28:24 |
| 2675 | online | NULL | NULL | 2675 | 2017-11-06 14:28:50 |
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;