Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 5,076–5,100 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5076 | audio_guide_desk | NULL | 1 | 5076 | 2019-11-16 09:42:59 |
| 5077 | audio_guide_desk | NULL | 2 | 5077 | 2019-11-16 09:54:13 |
| 5078 | app_store | NULL | NULL | 5078 | 2019-11-16 12:47:33 |
| 5079 | ticket_desk | 4 | NULL | 5079 | 2019-11-16 13:37:58 |
| 5080 | online | NULL | NULL | 5080 | 2019-11-16 18:54:33 |
| 5081 | ticket_desk | 4 | NULL | 5081 | 2019-11-17 09:33:56 |
| 5082 | audio_guide_desk | NULL | 2 | 5082 | 2019-11-17 14:25:08 |
| 5083 | audio_guide_desk | NULL | 2 | 5083 | 2019-11-17 14:26:30 |
| 5084 | online | NULL | NULL | 5084 | 2019-11-17 19:21:49 |
| 5085 | online | NULL | NULL | 5085 | 2019-11-18 13:36:40 |
| 5086 | audio_guide_desk | NULL | 1 | 5086 | 2019-11-18 13:51:24 |
| 5087 | app_store | NULL | NULL | 5087 | 2019-11-19 02:51:23 |
| 5088 | online | NULL | NULL | 5088 | 2019-11-19 08:42:38 |
| 5089 | audio_guide_desk | NULL | 3 | 5089 | 2019-11-19 10:17:42 |
| 5090 | online | NULL | NULL | 5090 | 2019-11-19 15:51:55 |
| 5091 | online | NULL | NULL | 5091 | 2019-11-20 09:22:43 |
| 5092 | ticket_desk | 1 | NULL | 5092 | 2019-11-20 11:35:17 |
| 5093 | online | NULL | NULL | 5093 | 2019-11-20 12:27:42 |
| 5094 | online | NULL | NULL | 5094 | 2019-11-20 19:17:57 |
| 5095 | online | NULL | NULL | 5095 | 2019-11-20 20:42:54 |
| 5096 | online | NULL | NULL | 5096 | 2019-11-20 23:45:42 |
| 5097 | online | NULL | NULL | 5097 | 2019-11-21 13:06:44 |
| 5098 | app_store | NULL | NULL | 5098 | 2019-11-21 17:11:48 |
| 5099 | app_store | NULL | NULL | 5099 | 2019-11-21 19:34:33 |
| 5100 | online | NULL | NULL | 5100 | 2019-11-21 22:05:03 |
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;