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,201–5,225 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5201 | app_store | NULL | NULL | 5201 | 2019-12-21 20:34:41 |
| 5202 | audio_guide_desk | NULL | 2 | 5202 | 2019-12-22 11:13:02 |
| 5203 | online | NULL | NULL | 5203 | 2019-12-22 17:05:00 |
| 5204 | online | NULL | NULL | 5204 | 2019-12-22 17:06:50 |
| 5205 | ticket_desk | 1 | NULL | 5205 | 2019-12-23 12:34:11 |
| 5206 | audio_guide_desk | NULL | 2 | 5206 | 2019-12-23 13:10:51 |
| 5207 | online | NULL | NULL | 5207 | 2019-12-23 13:52:44 |
| 5208 | online | NULL | NULL | 5208 | 2019-12-23 14:34:56 |
| 5209 | app_store | NULL | NULL | 5209 | 2019-12-23 17:58:41 |
| 5210 | online | NULL | NULL | 5210 | 2019-12-23 19:56:51 |
| 5211 | online | NULL | NULL | 5211 | 2019-12-24 07:56:14 |
| 5212 | ticket_desk | 1 | NULL | 5212 | 2019-12-24 10:18:52 |
| 5213 | ticket_desk | 5 | NULL | 5213 | 2019-12-24 13:24:35 |
| 5214 | ticket_desk | 3 | NULL | 5214 | 2019-12-24 13:56:25 |
| 5215 | audio_guide_desk | NULL | 2 | 5215 | 2019-12-24 15:38:53 |
| 5216 | audio_guide_desk | NULL | 1 | 5216 | 2019-12-24 15:55:09 |
| 5217 | audio_guide_desk | NULL | 2 | 5217 | 2019-12-24 16:00:38 |
| 5218 | online | NULL | NULL | 5218 | 2019-12-25 10:28:28 |
| 5219 | audio_guide_desk | NULL | 2 | 5219 | 2019-12-25 11:54:34 |
| 5220 | online | NULL | NULL | 5220 | 2019-12-25 11:57:37 |
| 5221 | audio_guide_desk | NULL | 1 | 5221 | 2019-12-25 11:59:57 |
| 5222 | audio_guide_desk | NULL | 1 | 5222 | 2019-12-26 12:47:27 |
| 5223 | ticket_desk | 1 | NULL | 5223 | 2019-12-27 09:01:20 |
| 5224 | ticket_desk | 3 | NULL | 5224 | 2019-12-27 10:30:36 |
| 5225 | audio_guide_desk | NULL | 2 | 5225 | 2019-12-27 11:29:44 |
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;