Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,801–4,825 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4801 | app_store | NULL | NULL | 4801 | 2019-08-24 01:59:32 |
| 4802 | online | NULL | NULL | 4802 | 2019-08-24 07:55:31 |
| 4803 | ticket_desk | 1 | NULL | 4803 | 2019-08-24 09:31:57 |
| 4804 | online | NULL | NULL | 4804 | 2019-08-24 23:10:30 |
| 4805 | online | NULL | NULL | 4805 | 2019-08-24 23:10:53 |
| 4806 | online | NULL | NULL | 4806 | 2019-08-25 07:48:01 |
| 4807 | online | NULL | NULL | 4807 | 2019-08-25 13:03:29 |
| 4808 | ticket_desk | 1 | NULL | 4808 | 2019-08-25 14:01:46 |
| 4809 | audio_guide_desk | NULL | 3 | 4809 | 2019-08-25 14:33:59 |
| 4810 | online | NULL | NULL | 4810 | 2019-08-25 14:40:26 |
| 4811 | app_store | NULL | NULL | 4811 | 2019-08-25 15:52:58 |
| 4812 | online | NULL | NULL | 4812 | 2019-08-25 18:02:11 |
| 4813 | online | NULL | NULL | 4813 | 2019-08-26 12:23:33 |
| 4814 | ticket_desk | 1 | NULL | 4814 | 2019-08-26 13:30:05 |
| 4815 | app_store | NULL | NULL | 4815 | 2019-08-26 14:31:33 |
| 4816 | online | NULL | NULL | 4816 | 2019-08-26 22:57:02 |
| 4817 | online | NULL | NULL | 4817 | 2019-08-27 07:35:27 |
| 4818 | online | NULL | NULL | 4818 | 2019-08-27 07:58:46 |
| 4819 | app_store | NULL | NULL | 4819 | 2019-08-27 09:05:17 |
| 4820 | ticket_desk | 1 | NULL | 4820 | 2019-08-27 09:50:14 |
| 4821 | audio_guide_desk | NULL | 1 | 4821 | 2019-08-27 10:36:27 |
| 4822 | audio_guide_desk | NULL | 1 | 4822 | 2019-08-28 09:37:26 |
| 4823 | ticket_desk | 2 | NULL | 4823 | 2019-08-28 10:17:44 |
| 4824 | ticket_desk | 4 | NULL | 4824 | 2019-08-28 10:53:43 |
| 4825 | audio_guide_desk | NULL | 3 | 4825 | 2019-08-28 11:13:48 |
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;