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,201–4,225 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4201 | online | NULL | NULL | 4201 | 2019-03-14 12:59:59 |
| 4202 | app_store | NULL | NULL | 4202 | 2019-03-14 18:02:09 |
| 4203 | online | NULL | NULL | 4203 | 2019-03-14 23:56:42 |
| 4204 | audio_guide_desk | NULL | 3 | 4204 | 2019-03-15 09:23:11 |
| 4205 | app_store | NULL | NULL | 4205 | 2019-03-15 13:02:50 |
| 4206 | audio_guide_desk | NULL | 2 | 4206 | 2019-03-15 17:20:15 |
| 4207 | online | NULL | NULL | 4207 | 2019-03-15 17:25:32 |
| 4208 | app_store | NULL | NULL | 4208 | 2019-03-15 19:12:49 |
| 4209 | online | NULL | NULL | 4209 | 2019-03-15 22:50:23 |
| 4210 | app_store | NULL | NULL | 4210 | 2019-03-16 02:12:14 |
| 4211 | online | NULL | NULL | 4211 | 2019-03-16 08:16:23 |
| 4212 | online | NULL | NULL | 4212 | 2019-03-16 09:11:26 |
| 4213 | app_store | NULL | NULL | 4213 | 2019-03-16 11:17:47 |
| 4214 | online | NULL | NULL | 4214 | 2019-03-17 18:52:10 |
| 4215 | ticket_desk | 4 | NULL | 4215 | 2019-03-18 14:42:55 |
| 4216 | app_store | NULL | NULL | 4216 | 2019-03-18 16:15:23 |
| 4217 | online | NULL | NULL | 4217 | 2019-03-18 21:17:17 |
| 4218 | app_store | NULL | NULL | 4218 | 2019-03-19 01:23:15 |
| 4219 | online | NULL | NULL | 4219 | 2019-03-19 08:52:54 |
| 4220 | online | NULL | NULL | 4220 | 2019-03-19 10:56:41 |
| 4221 | ticket_desk | 4 | NULL | 4221 | 2019-03-19 13:03:00 |
| 4222 | online | NULL | NULL | 4222 | 2019-03-19 14:35:52 |
| 4223 | audio_guide_desk | NULL | 2 | 4223 | 2019-03-19 15:06:35 |
| 4224 | app_store | NULL | NULL | 4224 | 2019-03-20 01:12:25 |
| 4225 | online | NULL | NULL | 4225 | 2019-03-20 07:35:15 |
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;