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,676–1,700 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1676 | audio_guide_desk | NULL | 2 | 1676 | 2016-10-29 09:56:46 |
| 1677 | ticket_desk | 1 | NULL | 1677 | 2016-10-30 15:00:24 |
| 1678 | app_store | NULL | NULL | 1678 | 2016-10-30 23:42:31 |
| 1679 | app_store | NULL | NULL | 1679 | 2016-11-01 01:00:55 |
| 1680 | online | NULL | NULL | 1680 | 2016-11-01 09:11:43 |
| 1681 | app_store | NULL | NULL | 1681 | 2016-11-01 18:53:30 |
| 1682 | app_store | NULL | NULL | 1682 | 2016-11-01 21:30:11 |
| 1683 | online | NULL | NULL | 1683 | 2016-11-01 22:24:57 |
| 1684 | ticket_desk | 3 | NULL | 1684 | 2016-11-02 08:39:46 |
| 1685 | app_store | NULL | NULL | 1685 | 2016-11-02 15:10:49 |
| 1686 | online | NULL | NULL | 1686 | 2016-11-03 11:29:42 |
| 1687 | app_store | NULL | NULL | 1687 | 2016-11-03 17:57:19 |
| 1688 | online | NULL | NULL | 1688 | 2016-11-04 09:13:42 |
| 1689 | online | NULL | NULL | 1689 | 2016-11-04 23:13:38 |
| 1690 | ticket_desk | 1 | NULL | 1690 | 2016-11-05 10:29:25 |
| 1691 | online | NULL | NULL | 1691 | 2016-11-05 11:54:20 |
| 1692 | online | NULL | NULL | 1692 | 2016-11-06 12:28:33 |
| 1693 | ticket_desk | 1 | NULL | 1693 | 2016-11-07 08:52:36 |
| 1694 | online | NULL | NULL | 1694 | 2016-11-07 12:56:39 |
| 1695 | app_store | NULL | NULL | 1695 | 2016-11-08 06:41:42 |
| 1696 | ticket_desk | 4 | NULL | 1696 | 2016-11-08 11:09:53 |
| 1697 | online | NULL | NULL | 1697 | 2016-11-08 18:14:48 |
| 1698 | app_store | NULL | NULL | 1698 | 2016-11-09 08:44:34 |
| 1699 | online | NULL | NULL | 1699 | 2016-11-10 12:34:42 |
| 1700 | app_store | NULL | NULL | 1700 | 2016-11-10 19:32:30 |
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;