Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 1,651–1,675 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1651 | app_store | NULL | NULL | 1651 | 2016-10-14 15:55:30 |
| 1652 | ticket_desk | 1 | NULL | 1652 | 2016-10-15 12:01:30 |
| 1653 | ticket_desk | 2 | NULL | 1653 | 2016-10-16 08:55:20 |
| 1654 | online | NULL | NULL | 1654 | 2016-10-16 09:57:43 |
| 1655 | online | NULL | NULL | 1655 | 2016-10-16 23:50:35 |
| 1656 | app_store | NULL | NULL | 1656 | 2016-10-18 07:45:14 |
| 1657 | audio_guide_desk | NULL | 1 | 1657 | 2016-10-18 13:49:31 |
| 1658 | app_store | NULL | NULL | 1658 | 2016-10-18 23:21:28 |
| 1659 | ticket_desk | 1 | NULL | 1659 | 2016-10-19 12:14:43 |
| 1660 | app_store | NULL | NULL | 1660 | 2016-10-19 15:59:50 |
| 1661 | app_store | NULL | NULL | 1661 | 2016-10-20 03:34:02 |
| 1662 | app_store | NULL | NULL | 1662 | 2016-10-21 05:34:06 |
| 1663 | online | NULL | NULL | 1663 | 2016-10-21 22:07:36 |
| 1664 | ticket_desk | 1 | NULL | 1664 | 2016-10-22 09:40:04 |
| 1665 | ticket_desk | 4 | NULL | 1665 | 2016-10-22 16:10:51 |
| 1666 | online | NULL | NULL | 1666 | 2016-10-22 22:33:16 |
| 1667 | app_store | NULL | NULL | 1667 | 2016-10-25 01:12:48 |
| 1668 | ticket_desk | 2 | NULL | 1668 | 2016-10-25 11:41:34 |
| 1669 | app_store | NULL | NULL | 1669 | 2016-10-25 12:19:09 |
| 1670 | app_store | NULL | NULL | 1670 | 2016-10-25 20:48:48 |
| 1671 | online | NULL | NULL | 1671 | 2016-10-25 22:38:03 |
| 1672 | online | NULL | NULL | 1672 | 2016-10-26 07:47:29 |
| 1673 | app_store | NULL | NULL | 1673 | 2016-10-28 07:32:11 |
| 1674 | online | NULL | NULL | 1674 | 2016-10-28 07:53:38 |
| 1675 | ticket_desk | 2 | NULL | 1675 | 2016-10-28 14:59: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;