Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,176–4,200 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4176 | online | NULL | NULL | 4176 | 2019-03-06 15:24:52 |
| 4177 | app_store | NULL | NULL | 4177 | 2019-03-07 01:02:37 |
| 4178 | online | NULL | NULL | 4178 | 2019-03-07 21:39:41 |
| 4179 | online | NULL | NULL | 4179 | 2019-03-08 07:43:14 |
| 4180 | ticket_desk | 2 | NULL | 4180 | 2019-03-08 09:24:52 |
| 4181 | online | NULL | NULL | 4181 | 2019-03-09 11:23:49 |
| 4182 | audio_guide_desk | NULL | 2 | 4182 | 2019-03-09 12:07:34 |
| 4183 | app_store | NULL | NULL | 4183 | 2019-03-09 19:38:26 |
| 4184 | audio_guide_desk | NULL | 2 | 4184 | 2019-03-10 12:45:43 |
| 4185 | audio_guide_desk | NULL | 2 | 4185 | 2019-03-10 12:54:35 |
| 4186 | online | NULL | NULL | 4186 | 2019-03-11 07:21:29 |
| 4187 | ticket_desk | 1 | NULL | 4187 | 2019-03-11 09:43:55 |
| 4188 | app_store | NULL | NULL | 4188 | 2019-03-12 02:28:53 |
| 4189 | online | NULL | NULL | 4189 | 2019-03-12 08:06:54 |
| 4190 | online | NULL | NULL | 4190 | 2019-03-12 08:31:20 |
| 4191 | ticket_desk | 1 | NULL | 4191 | 2019-03-12 11:53:57 |
| 4192 | app_store | NULL | NULL | 4192 | 2019-03-12 19:46:52 |
| 4193 | online | NULL | NULL | 4193 | 2019-03-12 20:21:52 |
| 4194 | app_store | NULL | NULL | 4194 | 2019-03-12 21:13:13 |
| 4195 | app_store | NULL | NULL | 4195 | 2019-03-12 21:28:16 |
| 4196 | online | NULL | NULL | 4196 | 2019-03-13 09:15:53 |
| 4197 | app_store | NULL | NULL | 4197 | 2019-03-13 14:43:28 |
| 4198 | online | NULL | NULL | 4198 | 2019-03-13 16:49:31 |
| 4199 | ticket_desk | 2 | NULL | 4199 | 2019-03-14 11:38:52 |
| 4200 | audio_guide_desk | NULL | 2 | 4200 | 2019-03-14 12:14:43 |
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;