Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,301–2,325 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2301 | audio_guide_desk | NULL | 2 | 2301 | 2017-06-28 14:44:29 |
| 2302 | online | NULL | NULL | 2302 | 2017-06-28 15:13:55 |
| 2303 | online | NULL | NULL | 2303 | 2017-06-28 15:15:12 |
| 2304 | online | NULL | NULL | 2304 | 2017-06-29 09:27:47 |
| 2305 | online | NULL | NULL | 2305 | 2017-06-29 13:21:45 |
| 2306 | online | NULL | NULL | 2306 | 2017-06-30 14:35:38 |
| 2307 | online | NULL | NULL | 2307 | 2017-06-30 14:46:23 |
| 2308 | ticket_desk | 1 | NULL | 2308 | 2017-07-01 09:17:42 |
| 2309 | ticket_desk | 5 | NULL | 2309 | 2017-07-01 12:30:53 |
| 2310 | audio_guide_desk | NULL | 2 | 2310 | 2017-07-01 13:05:44 |
| 2311 | ticket_desk | 1 | NULL | 2311 | 2017-07-01 15:03:27 |
| 2312 | audio_guide_desk | NULL | 1 | 2312 | 2017-07-01 15:43:10 |
| 2313 | online | NULL | NULL | 2313 | 2017-07-02 13:07:55 |
| 2314 | online | NULL | NULL | 2314 | 2017-07-03 09:50:04 |
| 2315 | app_store | NULL | NULL | 2315 | 2017-07-03 13:51:20 |
| 2316 | ticket_desk | 4 | NULL | 2316 | 2017-07-04 11:28:35 |
| 2317 | ticket_desk | 1 | NULL | 2317 | 2017-07-04 13:54:54 |
| 2318 | online | NULL | NULL | 2318 | 2017-07-04 19:07:50 |
| 2319 | online | NULL | NULL | 2319 | 2017-07-04 19:40:44 |
| 2320 | app_store | NULL | NULL | 2320 | 2017-07-05 05:16:03 |
| 2321 | online | NULL | NULL | 2321 | 2017-07-05 09:54:51 |
| 2322 | ticket_desk | 2 | NULL | 2322 | 2017-07-05 10:51:30 |
| 2323 | audio_guide_desk | NULL | 2 | 2323 | 2017-07-05 10:55:02 |
| 2324 | ticket_desk | 3 | NULL | 2324 | 2017-07-05 13:33:24 |
| 2325 | audio_guide_desk | NULL | 2 | 2325 | 2017-07-05 14:06:04 |
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;