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,101–5,125 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5101 | online | NULL | NULL | 5101 | 2019-11-21 22:26:40 |
| 5102 | online | NULL | NULL | 5102 | 2019-11-22 07:38:28 |
| 5103 | ticket_desk | 1 | NULL | 5103 | 2019-11-22 11:53:39 |
| 5104 | audio_guide_desk | NULL | 3 | 5104 | 2019-11-22 15:09:03 |
| 5105 | online | NULL | NULL | 5105 | 2019-11-23 09:13:25 |
| 5106 | ticket_desk | 1 | NULL | 5106 | 2019-11-23 09:41:35 |
| 5107 | app_store | NULL | NULL | 5107 | 2019-11-23 11:48:44 |
| 5108 | online | NULL | NULL | 5108 | 2019-11-23 18:24:25 |
| 5109 | online | NULL | NULL | 5109 | 2019-11-24 23:59:22 |
| 5110 | audio_guide_desk | NULL | 2 | 5110 | 2019-11-25 10:20:28 |
| 5111 | online | NULL | NULL | 5111 | 2019-11-25 12:53:04 |
| 5112 | online | NULL | NULL | 5112 | 2019-11-25 19:03:55 |
| 5113 | audio_guide_desk | NULL | 1 | 5113 | 2019-11-26 10:51:43 |
| 5114 | online | NULL | NULL | 5114 | 2019-11-27 11:52:26 |
| 5115 | online | NULL | NULL | 5115 | 2019-11-27 14:45:41 |
| 5116 | ticket_desk | 1 | NULL | 5116 | 2019-11-28 09:03:37 |
| 5117 | audio_guide_desk | NULL | 2 | 5117 | 2019-11-28 09:42:43 |
| 5118 | audio_guide_desk | NULL | 2 | 5118 | 2019-11-29 12:54:46 |
| 5119 | ticket_desk | 1 | NULL | 5119 | 2019-11-30 09:52:52 |
| 5120 | app_store | NULL | NULL | 5120 | 2019-11-30 13:18:24 |
| 5121 | ticket_desk | 3 | NULL | 5121 | 2019-11-30 16:41:54 |
| 5122 | online | NULL | NULL | 5122 | 2019-11-30 17:09:11 |
| 5123 | online | NULL | NULL | 5123 | 2019-11-30 19:39:34 |
| 5124 | online | NULL | NULL | 5124 | 2019-12-01 09:36:44 |
| 5125 | online | NULL | NULL | 5125 | 2019-12-01 16:07:55 |
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;