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,601–2,625 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2601 | online | NULL | NULL | 2601 | 2017-10-02 17:06:54 |
| 2602 | online | NULL | NULL | 2602 | 2017-10-03 17:11:36 |
| 2603 | online | NULL | NULL | 2603 | 2017-10-04 07:44:08 |
| 2604 | online | NULL | NULL | 2604 | 2017-10-05 09:38:40 |
| 2605 | online | NULL | NULL | 2605 | 2017-10-05 16:34:11 |
| 2606 | ticket_desk | 5 | NULL | 2606 | 2017-10-07 10:21:13 |
| 2607 | online | NULL | NULL | 2607 | 2017-10-07 21:03:43 |
| 2608 | ticket_desk | 1 | NULL | 2608 | 2017-10-09 16:15:41 |
| 2609 | online | NULL | NULL | 2609 | 2017-10-09 23:13:38 |
| 2610 | ticket_desk | 4 | NULL | 2610 | 2017-10-10 08:37:32 |
| 2611 | ticket_desk | 1 | NULL | 2611 | 2017-10-10 10:13:08 |
| 2612 | audio_guide_desk | NULL | 2 | 2612 | 2017-10-10 16:00:23 |
| 2613 | ticket_desk | 1 | NULL | 2613 | 2017-10-11 10:58:46 |
| 2614 | app_store | NULL | NULL | 2614 | 2017-10-12 07:26:46 |
| 2615 | ticket_desk | 2 | NULL | 2615 | 2017-10-12 09:53:05 |
| 2616 | online | NULL | NULL | 2616 | 2017-10-13 12:51:50 |
| 2617 | app_store | NULL | NULL | 2617 | 2017-10-13 22:16:58 |
| 2618 | ticket_desk | 1 | NULL | 2618 | 2017-10-14 14:22:36 |
| 2619 | app_store | NULL | NULL | 2619 | 2017-10-15 06:02:43 |
| 2620 | ticket_desk | 1 | NULL | 2620 | 2017-10-15 12:48:26 |
| 2621 | audio_guide_desk | NULL | 2 | 2621 | 2017-10-15 13:16:41 |
| 2622 | ticket_desk | 1 | NULL | 2622 | 2017-10-15 13:51:44 |
| 2623 | online | NULL | NULL | 2623 | 2017-10-15 14:39:51 |
| 2624 | ticket_desk | 5 | NULL | 2624 | 2017-10-17 16:03:24 |
| 2625 | online | NULL | NULL | 2625 | 2017-10-17 17:10:07 |
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;