Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 151–175 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 151 | online | NULL | NULL | 151 | 2015-04-20 15:46:43 |
| 152 | app_store | NULL | NULL | 152 | 2015-04-21 08:13:07 |
| 153 | ticket_desk | 2 | NULL | 153 | 2015-04-21 16:48:10 |
| 154 | ticket_desk | 1 | NULL | 154 | 2015-04-23 08:53:40 |
| 155 | online | NULL | NULL | 155 | 2015-04-24 09:42:20 |
| 156 | ticket_desk | 1 | NULL | 156 | 2015-04-24 12:50:39 |
| 157 | online | NULL | NULL | 157 | 2015-04-24 15:53:06 |
| 158 | ticket_desk | 1 | NULL | 158 | 2015-04-24 16:11:33 |
| 159 | online | NULL | NULL | 159 | 2015-04-24 16:12:28 |
| 160 | audio_guide_desk | NULL | 1 | 160 | 2015-04-24 16:31:56 |
| 161 | online | NULL | NULL | 161 | 2015-04-25 08:44:40 |
| 162 | app_store | NULL | NULL | 162 | 2015-04-26 00:24:16 |
| 163 | app_store | NULL | NULL | 163 | 2015-04-26 07:00:45 |
| 164 | audio_guide_desk | NULL | 1 | 164 | 2015-04-26 11:07:15 |
| 165 | ticket_desk | 1 | NULL | 165 | 2015-04-26 13:00:43 |
| 166 | audio_guide_desk | NULL | 2 | 166 | 2015-04-26 13:32:43 |
| 167 | online | NULL | NULL | 167 | 2015-04-26 19:01:42 |
| 168 | online | NULL | NULL | 168 | 2015-04-26 23:07:41 |
| 169 | app_store | NULL | NULL | 169 | 2015-04-27 13:00:08 |
| 170 | app_store | NULL | NULL | 170 | 2015-04-28 09:12:54 |
| 171 | online | NULL | NULL | 171 | 2015-04-28 16:07:52 |
| 172 | ticket_desk | 2 | NULL | 172 | 2015-04-29 10:58:20 |
| 173 | online | NULL | NULL | 173 | 2015-04-29 11:31:03 |
| 174 | ticket_desk | 1 | NULL | 174 | 2015-04-29 11:48:56 |
| 175 | audio_guide_desk | NULL | 3 | 175 | 2015-04-29 12:27:36 |
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;