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,551–2,575 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2551 | audio_guide_desk | NULL | 2 | 2551 | 2017-09-13 10:34:17 |
| 2552 | ticket_desk | 2 | NULL | 2552 | 2017-09-13 16:52:09 |
| 2553 | app_store | NULL | NULL | 2553 | 2017-09-14 02:05:51 |
| 2554 | ticket_desk | 2 | NULL | 2554 | 2017-09-15 10:03:48 |
| 2555 | online | NULL | NULL | 2555 | 2017-09-15 11:15:42 |
| 2556 | app_store | NULL | NULL | 2556 | 2017-09-15 17:31:14 |
| 2557 | online | NULL | NULL | 2557 | 2017-09-15 17:48:24 |
| 2558 | app_store | NULL | NULL | 2558 | 2017-09-16 06:12:09 |
| 2559 | online | NULL | NULL | 2559 | 2017-09-16 07:08:55 |
| 2560 | audio_guide_desk | NULL | 2 | 2560 | 2017-09-16 10:18:17 |
| 2561 | audio_guide_desk | NULL | 2 | 2561 | 2017-09-16 10:28:37 |
| 2562 | audio_guide_desk | NULL | 2 | 2562 | 2017-09-16 10:28:56 |
| 2563 | app_store | NULL | NULL | 2563 | 2017-09-16 13:37:23 |
| 2564 | app_store | NULL | NULL | 2564 | 2017-09-16 13:38:15 |
| 2565 | ticket_desk | 1 | NULL | 2565 | 2017-09-17 09:34:09 |
| 2566 | audio_guide_desk | NULL | 1 | 2566 | 2017-09-17 10:24:42 |
| 2567 | ticket_desk | 3 | NULL | 2567 | 2017-09-17 11:51:12 |
| 2568 | online | NULL | NULL | 2568 | 2017-09-17 13:10:32 |
| 2569 | online | NULL | NULL | 2569 | 2017-09-19 08:03:34 |
| 2570 | online | NULL | NULL | 2570 | 2017-09-20 07:31:09 |
| 2571 | ticket_desk | 2 | NULL | 2571 | 2017-09-20 09:41:42 |
| 2572 | online | NULL | NULL | 2572 | 2017-09-20 15:18:03 |
| 2573 | app_store | NULL | NULL | 2573 | 2017-09-22 04:28:54 |
| 2574 | online | NULL | NULL | 2574 | 2017-09-22 07:44:49 |
| 2575 | ticket_desk | 1 | NULL | 2575 | 2017-09-22 10:43:09 |
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;