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,051–5,075 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5051 | online | NULL | NULL | 5051 | 2019-11-10 22:36:40 |
| 5052 | app_store | NULL | NULL | 5052 | 2019-11-11 03:30:59 |
| 5053 | ticket_desk | 5 | NULL | 5053 | 2019-11-11 08:57:57 |
| 5054 | ticket_desk | 4 | NULL | 5054 | 2019-11-11 09:12:08 |
| 5055 | audio_guide_desk | NULL | 2 | 5055 | 2019-11-11 09:37:04 |
| 5056 | audio_guide_desk | NULL | 2 | 5056 | 2019-11-11 09:49:29 |
| 5057 | audio_guide_desk | NULL | 2 | 5057 | 2019-11-11 09:49:39 |
| 5058 | online | NULL | NULL | 5058 | 2019-11-11 14:47:19 |
| 5059 | online | NULL | NULL | 5059 | 2019-11-11 18:31:34 |
| 5060 | ticket_desk | 3 | NULL | 5060 | 2019-11-12 10:01:49 |
| 5061 | online | NULL | NULL | 5061 | 2019-11-12 20:03:03 |
| 5062 | online | NULL | NULL | 5062 | 2019-11-12 22:05:35 |
| 5063 | audio_guide_desk | NULL | 1 | 5063 | 2019-11-13 10:16:35 |
| 5064 | ticket_desk | 3 | NULL | 5064 | 2019-11-13 11:20:57 |
| 5065 | audio_guide_desk | NULL | 2 | 5065 | 2019-11-13 11:59:23 |
| 5066 | app_store | NULL | NULL | 5066 | 2019-11-13 16:04:21 |
| 5067 | online | NULL | NULL | 5067 | 2019-11-13 17:41:45 |
| 5068 | audio_guide_desk | NULL | 2 | 5068 | 2019-11-14 10:01:09 |
| 5069 | online | NULL | NULL | 5069 | 2019-11-14 13:37:43 |
| 5070 | online | NULL | NULL | 5070 | 2019-11-14 19:27:00 |
| 5071 | online | NULL | NULL | 5071 | 2019-11-15 10:27:16 |
| 5072 | online | NULL | NULL | 5072 | 2019-11-15 11:20:59 |
| 5073 | ticket_desk | 1 | NULL | 5073 | 2019-11-15 15:16:26 |
| 5074 | online | NULL | NULL | 5074 | 2019-11-15 16:48:58 |
| 5075 | app_store | NULL | NULL | 5075 | 2019-11-16 06:26:19 |
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;