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,401–2,425 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2401 | online | NULL | NULL | 2401 | 2017-07-30 18:04:26 |
| 2402 | ticket_desk | 5 | NULL | 2402 | 2017-07-31 08:55:05 |
| 2403 | online | NULL | NULL | 2403 | 2017-07-31 10:35:19 |
| 2404 | ticket_desk | 4 | NULL | 2404 | 2017-07-31 10:51:09 |
| 2405 | audio_guide_desk | NULL | 1 | 2405 | 2017-07-31 14:09:50 |
| 2406 | audio_guide_desk | NULL | 1 | 2406 | 2017-07-31 14:23:18 |
| 2407 | online | NULL | NULL | 2407 | 2017-08-01 09:08:10 |
| 2408 | online | NULL | NULL | 2408 | 2017-08-02 08:55:06 |
| 2409 | ticket_desk | 1 | NULL | 2409 | 2017-08-02 15:37:58 |
| 2410 | online | NULL | NULL | 2410 | 2017-08-02 16:05:13 |
| 2411 | audio_guide_desk | NULL | 2 | 2411 | 2017-08-02 16:06:07 |
| 2412 | app_store | NULL | NULL | 2412 | 2017-08-03 12:45:42 |
| 2413 | online | NULL | NULL | 2413 | 2017-08-03 14:25:19 |
| 2414 | online | NULL | NULL | 2414 | 2017-08-03 15:20:14 |
| 2415 | app_store | NULL | NULL | 2415 | 2017-08-03 22:16:36 |
| 2416 | online | NULL | NULL | 2416 | 2017-08-04 12:17:02 |
| 2417 | online | NULL | NULL | 2417 | 2017-08-04 18:18:14 |
| 2418 | online | NULL | NULL | 2418 | 2017-08-05 09:39:46 |
| 2419 | online | NULL | NULL | 2419 | 2017-08-05 10:48:37 |
| 2420 | ticket_desk | 1 | NULL | 2420 | 2017-08-05 14:46:32 |
| 2421 | app_store | NULL | NULL | 2421 | 2017-08-05 21:45:57 |
| 2422 | online | NULL | NULL | 2422 | 2017-08-05 22:06:59 |
| 2423 | ticket_desk | 2 | NULL | 2423 | 2017-08-06 11:00:26 |
| 2424 | app_store | NULL | NULL | 2424 | 2017-08-07 02:18:07 |
| 2425 | online | NULL | NULL | 2425 | 2017-08-07 09:15:53 |
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;