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,751–4,775 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4751 | app_store | NULL | NULL | 4751 | 2019-08-09 08:15:17 |
| 4752 | app_store | NULL | NULL | 4752 | 2019-08-09 08:17:27 |
| 4753 | audio_guide_desk | NULL | 2 | 4753 | 2019-08-09 09:17:22 |
| 4754 | ticket_desk | 1 | NULL | 4754 | 2019-08-09 10:42:12 |
| 4755 | online | NULL | NULL | 4755 | 2019-08-09 10:50:47 |
| 4756 | audio_guide_desk | NULL | 1 | 4756 | 2019-08-09 10:57:53 |
| 4757 | app_store | NULL | NULL | 4757 | 2019-08-09 14:55:06 |
| 4758 | ticket_desk | 1 | NULL | 4758 | 2019-08-10 11:25:08 |
| 4759 | audio_guide_desk | NULL | 3 | 4759 | 2019-08-10 11:49:26 |
| 4760 | audio_guide_desk | NULL | 3 | 4760 | 2019-08-10 11:52:23 |
| 4761 | ticket_desk | 1 | NULL | 4761 | 2019-08-10 14:09:00 |
| 4762 | audio_guide_desk | NULL | 2 | 4762 | 2019-08-10 14:41:50 |
| 4763 | ticket_desk | 1 | NULL | 4763 | 2019-08-11 11:48:59 |
| 4764 | online | NULL | NULL | 4764 | 2019-08-12 08:37:24 |
| 4765 | online | NULL | NULL | 4765 | 2019-08-12 14:55:54 |
| 4766 | ticket_desk | 2 | NULL | 4766 | 2019-08-13 09:28:53 |
| 4767 | online | NULL | NULL | 4767 | 2019-08-13 21:41:12 |
| 4768 | online | NULL | NULL | 4768 | 2019-08-13 22:13:30 |
| 4769 | ticket_desk | 1 | NULL | 4769 | 2019-08-14 12:59:04 |
| 4770 | app_store | NULL | NULL | 4770 | 2019-08-15 02:24:31 |
| 4771 | online | NULL | NULL | 4771 | 2019-08-15 07:41:45 |
| 4772 | online | NULL | NULL | 4772 | 2019-08-15 07:58:44 |
| 4773 | online | NULL | NULL | 4773 | 2019-08-15 09:54:31 |
| 4774 | ticket_desk | 1 | NULL | 4774 | 2019-08-15 12:51:54 |
| 4775 | online | NULL | NULL | 4775 | 2019-08-15 13:19:33 |
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;