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,226–5,250 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5226 | online | NULL | NULL | 5226 | 2019-12-27 16:11:02 |
| 5227 | app_store | NULL | NULL | 5227 | 2019-12-27 21:22:24 |
| 5228 | online | NULL | NULL | 5228 | 2019-12-28 08:38:06 |
| 5229 | ticket_desk | 1 | NULL | 5229 | 2019-12-28 11:31:51 |
| 5230 | audio_guide_desk | NULL | 1 | 5230 | 2019-12-28 12:08:05 |
| 5231 | online | NULL | NULL | 5231 | 2019-12-28 12:28:47 |
| 5232 | app_store | NULL | NULL | 5232 | 2019-12-28 19:25:07 |
| 5233 | ticket_desk | 2 | NULL | 5233 | 2019-12-29 09:35:56 |
| 5234 | ticket_desk | 1 | NULL | 5234 | 2019-12-29 10:47:46 |
| 5235 | audio_guide_desk | NULL | 2 | 5235 | 2019-12-29 11:30:35 |
| 5236 | ticket_desk | 1 | NULL | 5236 | 2019-12-30 08:56:21 |
| 5237 | audio_guide_desk | NULL | 1 | 5237 | 2019-12-30 09:28:34 |
| 5238 | ticket_desk | 2 | NULL | 5238 | 2019-12-30 10:49:55 |
| 5239 | ticket_desk | 1 | NULL | 5239 | 2019-12-30 11:22:25 |
| 5240 | audio_guide_desk | NULL | 2 | 5240 | 2019-12-30 11:57:23 |
| 5241 | audio_guide_desk | NULL | 3 | 5241 | 2019-12-30 12:09:24 |
| 5242 | app_store | NULL | NULL | 5242 | 2019-12-30 15:35:24 |
| 5243 | ticket_desk | 3 | NULL | 5243 | 2020-01-01 11:02:57 |
| 5244 | online | NULL | NULL | 5244 | 2020-01-02 13:44:30 |
| 5245 | online | NULL | NULL | 5245 | 2020-01-02 16:32:52 |
| 5246 | app_store | NULL | NULL | 5246 | 2020-01-02 20:11:20 |
| 5247 | online | NULL | NULL | 5247 | 2020-01-03 09:21:00 |
| 5248 | online | NULL | NULL | 5248 | 2020-01-03 21:03:13 |
| 5249 | online | NULL | NULL | 5249 | 2020-01-04 10:20:47 |
| 5250 | audio_guide_desk | NULL | 2 | 5250 | 2020-01-04 10:24:59 |
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;