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,426–2,450 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2426 | app_store | NULL | NULL | 2426 | 2017-08-07 09:17:39 |
| 2427 | online | NULL | NULL | 2427 | 2017-08-07 09:28:14 |
| 2428 | app_store | NULL | NULL | 2428 | 2017-08-07 10:13:05 |
| 2429 | ticket_desk | 5 | NULL | 2429 | 2017-08-07 10:27:16 |
| 2430 | ticket_desk | 2 | NULL | 2430 | 2017-08-07 12:45:27 |
| 2431 | app_store | NULL | NULL | 2431 | 2017-08-07 16:46:52 |
| 2432 | online | NULL | NULL | 2432 | 2017-08-08 21:34:09 |
| 2433 | online | NULL | NULL | 2433 | 2017-08-08 23:49:51 |
| 2434 | online | NULL | NULL | 2434 | 2017-08-09 16:06:37 |
| 2435 | online | NULL | NULL | 2435 | 2017-08-09 20:51:28 |
| 2436 | app_store | NULL | NULL | 2436 | 2017-08-10 14:31:56 |
| 2437 | audio_guide_desk | NULL | 1 | 2437 | 2017-08-10 15:14:15 |
| 2438 | audio_guide_desk | NULL | 1 | 2438 | 2017-08-10 15:17:16 |
| 2439 | online | NULL | NULL | 2439 | 2017-08-11 18:15:32 |
| 2440 | online | NULL | NULL | 2440 | 2017-08-11 20:59:55 |
| 2441 | online | NULL | NULL | 2441 | 2017-08-12 08:02:26 |
| 2442 | ticket_desk | 2 | NULL | 2442 | 2017-08-12 10:46:08 |
| 2443 | audio_guide_desk | NULL | 2 | 2443 | 2017-08-12 11:58:27 |
| 2444 | online | NULL | NULL | 2444 | 2017-08-12 16:04:47 |
| 2445 | audio_guide_desk | NULL | 2 | 2445 | 2017-08-13 10:54:21 |
| 2446 | online | NULL | NULL | 2446 | 2017-08-13 13:53:04 |
| 2447 | audio_guide_desk | NULL | 2 | 2447 | 2017-08-13 14:03:00 |
| 2448 | ticket_desk | 1 | NULL | 2448 | 2017-08-13 16:32:43 |
| 2449 | audio_guide_desk | NULL | 2 | 2449 | 2017-08-13 17:02:33 |
| 2450 | online | NULL | NULL | 2450 | 2017-08-14 08:36:13 |
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;