Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 626–650 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 626 | audio_guide_desk | NULL | 2 | 626 | 2015-09-11 12:28:10 |
| 627 | audio_guide_desk | NULL | 2 | 627 | 2015-09-11 12:34:59 |
| 628 | audio_guide_desk | NULL | 1 | 628 | 2015-09-11 12:45:55 |
| 629 | ticket_desk | 3 | NULL | 629 | 2015-09-12 15:33:28 |
| 630 | app_store | NULL | NULL | 630 | 2015-09-13 04:14:06 |
| 631 | ticket_desk | 1 | NULL | 631 | 2015-09-13 10:21:19 |
| 632 | audio_guide_desk | NULL | 1 | 632 | 2015-09-13 10:49:12 |
| 633 | ticket_desk | 1 | NULL | 633 | 2015-09-13 10:57:39 |
| 634 | online | NULL | NULL | 634 | 2015-09-13 12:41:04 |
| 635 | online | NULL | NULL | 635 | 2015-09-14 11:21:09 |
| 636 | online | NULL | NULL | 636 | 2015-09-14 20:27:51 |
| 637 | online | NULL | NULL | 637 | 2015-09-15 21:58:32 |
| 638 | app_store | NULL | NULL | 638 | 2015-09-16 06:57:27 |
| 639 | online | NULL | NULL | 639 | 2015-09-16 07:09:08 |
| 640 | audio_guide_desk | NULL | 1 | 640 | 2015-09-16 12:01:23 |
| 641 | app_store | NULL | NULL | 641 | 2015-09-16 21:29:53 |
| 642 | online | NULL | NULL | 642 | 2015-09-17 12:06:57 |
| 643 | ticket_desk | 2 | NULL | 643 | 2015-09-18 11:52:08 |
| 644 | online | NULL | NULL | 644 | 2015-09-18 23:01:41 |
| 645 | app_store | NULL | NULL | 645 | 2015-09-19 04:17:44 |
| 646 | online | NULL | NULL | 646 | 2015-09-19 08:19:25 |
| 647 | online | NULL | NULL | 647 | 2015-09-19 09:38:45 |
| 648 | ticket_desk | 1 | NULL | 648 | 2015-09-20 10:13:37 |
| 649 | ticket_desk | 4 | NULL | 649 | 2015-09-20 10:59:30 |
| 650 | ticket_desk | 1 | NULL | 650 | 2015-09-20 12:11:02 |
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;