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,951–4,975 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4951 | online | NULL | NULL | 4951 | 2019-10-13 12:27:01 |
| 4952 | online | NULL | NULL | 4952 | 2019-10-13 15:27:15 |
| 4953 | online | NULL | NULL | 4953 | 2019-10-13 23:24:11 |
| 4954 | audio_guide_desk | NULL | 3 | 4954 | 2019-10-14 10:59:14 |
| 4955 | online | NULL | NULL | 4955 | 2019-10-14 20:38:42 |
| 4956 | app_store | NULL | NULL | 4956 | 2019-10-15 06:09:43 |
| 4957 | online | NULL | NULL | 4957 | 2019-10-15 08:00:29 |
| 4958 | online | NULL | NULL | 4958 | 2019-10-15 10:54:19 |
| 4959 | online | NULL | NULL | 4959 | 2019-10-15 17:32:06 |
| 4960 | app_store | NULL | NULL | 4960 | 2019-10-16 01:23:30 |
| 4961 | app_store | NULL | NULL | 4961 | 2019-10-16 02:16:02 |
| 4962 | online | NULL | NULL | 4962 | 2019-10-16 10:30:59 |
| 4963 | audio_guide_desk | NULL | 1 | 4963 | 2019-10-16 11:08:42 |
| 4964 | online | NULL | NULL | 4964 | 2019-10-16 11:09:45 |
| 4965 | audio_guide_desk | NULL | 2 | 4965 | 2019-10-17 11:08:12 |
| 4966 | audio_guide_desk | NULL | 3 | 4966 | 2019-10-17 11:17:24 |
| 4967 | online | NULL | NULL | 4967 | 2019-10-17 12:29:12 |
| 4968 | ticket_desk | 4 | NULL | 4968 | 2019-10-17 15:02:40 |
| 4969 | online | NULL | NULL | 4969 | 2019-10-18 08:41:20 |
| 4970 | ticket_desk | 1 | NULL | 4970 | 2019-10-18 10:03:02 |
| 4971 | audio_guide_desk | NULL | 2 | 4971 | 2019-10-18 10:46:42 |
| 4972 | online | NULL | NULL | 4972 | 2019-10-18 21:24:06 |
| 4973 | online | NULL | NULL | 4973 | 2019-10-19 08:58:14 |
| 4974 | online | NULL | NULL | 4974 | 2019-10-19 17:07:10 |
| 4975 | app_store | NULL | NULL | 4975 | 2019-10-19 21:28:18 |
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;