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,026–5,050 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5026 | online | NULL | NULL | 5026 | 2019-11-03 23:03:21 |
| 5027 | app_store | NULL | NULL | 5027 | 2019-11-04 00:24:09 |
| 5028 | ticket_desk | 1 | NULL | 5028 | 2019-11-04 11:26:24 |
| 5029 | online | NULL | NULL | 5029 | 2019-11-04 22:46:36 |
| 5030 | online | NULL | NULL | 5030 | 2019-11-05 10:03:15 |
| 5031 | app_store | NULL | NULL | 5031 | 2019-11-05 11:22:04 |
| 5032 | app_store | NULL | NULL | 5032 | 2019-11-05 17:30:03 |
| 5033 | online | NULL | NULL | 5033 | 2019-11-05 17:52:48 |
| 5034 | online | NULL | NULL | 5034 | 2019-11-05 22:33:26 |
| 5035 | app_store | NULL | NULL | 5035 | 2019-11-05 22:58:25 |
| 5036 | ticket_desk | 2 | NULL | 5036 | 2019-11-06 08:55:36 |
| 5037 | ticket_desk | 3 | NULL | 5037 | 2019-11-07 08:43:41 |
| 5038 | online | NULL | NULL | 5038 | 2019-11-07 10:25:58 |
| 5039 | audio_guide_desk | NULL | 2 | 5039 | 2019-11-07 13:09:08 |
| 5040 | online | NULL | NULL | 5040 | 2019-11-07 19:26:54 |
| 5041 | ticket_desk | 5 | NULL | 5041 | 2019-11-08 09:49:00 |
| 5042 | online | NULL | NULL | 5042 | 2019-11-08 11:00:14 |
| 5043 | online | NULL | NULL | 5043 | 2019-11-08 11:50:45 |
| 5044 | ticket_desk | 2 | NULL | 5044 | 2019-11-08 12:12:21 |
| 5045 | online | NULL | NULL | 5045 | 2019-11-08 12:39:22 |
| 5046 | audio_guide_desk | NULL | 1 | 5046 | 2019-11-08 12:53:48 |
| 5047 | audio_guide_desk | NULL | 3 | 5047 | 2019-11-08 13:54:49 |
| 5048 | online | NULL | NULL | 5048 | 2019-11-08 17:48:42 |
| 5049 | online | NULL | NULL | 5049 | 2019-11-09 17:24:44 |
| 5050 | online | NULL | NULL | 5050 | 2019-11-10 10:12:16 |
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;