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,251–5,275 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5251 | app_store | NULL | NULL | 5251 | 2020-01-04 12:58:42 |
| 5252 | app_store | NULL | NULL | 5252 | 2020-01-05 02:47:23 |
| 5253 | ticket_desk | 2 | NULL | 5253 | 2020-01-05 13:17:22 |
| 5254 | online | NULL | NULL | 5254 | 2020-01-06 09:25:27 |
| 5255 | app_store | NULL | NULL | 5255 | 2020-01-06 12:55:01 |
| 5256 | app_store | NULL | NULL | 5256 | 2020-01-06 14:05:11 |
| 5257 | audio_guide_desk | NULL | 1 | 5257 | 2020-01-06 15:11:12 |
| 5258 | online | NULL | NULL | 5258 | 2020-01-06 21:38:55 |
| 5259 | app_store | NULL | NULL | 5259 | 2020-01-07 08:25:48 |
| 5260 | ticket_desk | 2 | NULL | 5260 | 2020-01-07 09:56:18 |
| 5261 | audio_guide_desk | NULL | 2 | 5261 | 2020-01-07 10:43:04 |
| 5262 | ticket_desk | 1 | NULL | 5262 | 2020-01-07 11:29:09 |
| 5263 | online | NULL | NULL | 5263 | 2020-01-07 18:42:18 |
| 5264 | online | NULL | NULL | 5264 | 2020-01-07 20:00:41 |
| 5265 | ticket_desk | 1 | NULL | 5265 | 2020-01-08 10:34:01 |
| 5266 | online | NULL | NULL | 5266 | 2020-01-08 16:44:30 |
| 5267 | online | NULL | NULL | 5267 | 2020-01-08 23:21:14 |
| 5268 | ticket_desk | 1 | NULL | 5268 | 2020-01-09 11:23:09 |
| 5269 | ticket_desk | 1 | NULL | 5269 | 2020-01-09 13:25:55 |
| 5270 | audio_guide_desk | NULL | 2 | 5270 | 2020-01-09 15:41:58 |
| 5271 | audio_guide_desk | NULL | 2 | 5271 | 2020-01-09 15:59:42 |
| 5272 | app_store | NULL | NULL | 5272 | 2020-01-10 15:37:54 |
| 5273 | online | NULL | NULL | 5273 | 2020-01-10 17:43:21 |
| 5274 | online | NULL | NULL | 5274 | 2020-01-10 23:24:45 |
| 5275 | online | NULL | NULL | 5275 | 2020-01-11 11:27:00 |
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;