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,576–2,600 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2576 | online | NULL | NULL | 2576 | 2017-09-22 11:52:12 |
| 2577 | ticket_desk | 2 | NULL | 2577 | 2017-09-22 14:27:30 |
| 2578 | audio_guide_desk | NULL | 2 | 2578 | 2017-09-22 15:15:37 |
| 2579 | app_store | NULL | NULL | 2579 | 2017-09-23 16:33:28 |
| 2580 | online | NULL | NULL | 2580 | 2017-09-24 09:07:02 |
| 2581 | audio_guide_desk | NULL | 2 | 2581 | 2017-09-24 09:57:20 |
| 2582 | ticket_desk | 1 | NULL | 2582 | 2017-09-26 11:29:15 |
| 2583 | app_store | NULL | NULL | 2583 | 2017-09-26 22:28:39 |
| 2584 | ticket_desk | 3 | NULL | 2584 | 2017-09-27 15:27:41 |
| 2585 | ticket_desk | 2 | NULL | 2585 | 2017-09-27 15:51:15 |
| 2586 | app_store | NULL | NULL | 2586 | 2017-09-27 19:47:14 |
| 2587 | ticket_desk | 4 | NULL | 2587 | 2017-09-28 12:21:08 |
| 2588 | online | NULL | NULL | 2588 | 2017-09-28 13:49:14 |
| 2589 | online | NULL | NULL | 2589 | 2017-09-29 10:48:27 |
| 2590 | ticket_desk | 3 | NULL | 2590 | 2017-09-29 11:35:26 |
| 2591 | ticket_desk | 2 | NULL | 2591 | 2017-09-30 08:26:01 |
| 2592 | audio_guide_desk | NULL | 2 | 2592 | 2017-09-30 09:11:57 |
| 2593 | online | NULL | NULL | 2593 | 2017-09-30 11:06:48 |
| 2594 | ticket_desk | 2 | NULL | 2594 | 2017-10-01 09:15:14 |
| 2595 | audio_guide_desk | NULL | 2 | 2595 | 2017-10-01 10:49:42 |
| 2596 | online | NULL | NULL | 2596 | 2017-10-01 13:20:13 |
| 2597 | audio_guide_desk | NULL | 3 | 2597 | 2017-10-01 15:17:41 |
| 2598 | ticket_desk | 1 | NULL | 2598 | 2017-10-02 09:07:02 |
| 2599 | audio_guide_desk | NULL | 3 | 2599 | 2017-10-02 09:44:04 |
| 2600 | ticket_desk | 4 | NULL | 2600 | 2017-10-02 10:08:00 |
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;