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,701–1,725 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1701 | app_store | NULL | NULL | 1701 | 2016-11-11 00:18:07 |
| 1702 | online | NULL | NULL | 1702 | 2016-11-11 11:26:04 |
| 1703 | ticket_desk | 2 | NULL | 1703 | 2016-11-11 14:15:07 |
| 1704 | online | NULL | NULL | 1704 | 2016-11-11 15:18:48 |
| 1705 | ticket_desk | 4 | NULL | 1705 | 2016-11-12 09:40:45 |
| 1706 | online | NULL | NULL | 1706 | 2016-11-13 10:46:25 |
| 1707 | online | NULL | NULL | 1707 | 2016-11-14 10:24:06 |
| 1708 | audio_guide_desk | NULL | 3 | 1708 | 2016-11-14 11:02:32 |
| 1709 | ticket_desk | 4 | NULL | 1709 | 2016-11-15 15:38:25 |
| 1710 | audio_guide_desk | NULL | 1 | 1710 | 2016-11-15 16:05:19 |
| 1711 | online | NULL | NULL | 1711 | 2016-11-17 09:04:45 |
| 1712 | audio_guide_desk | NULL | 3 | 1712 | 2016-11-17 11:22:46 |
| 1713 | online | NULL | NULL | 1713 | 2016-11-18 15:22:20 |
| 1714 | ticket_desk | 1 | NULL | 1714 | 2016-11-20 09:40:22 |
| 1715 | ticket_desk | 1 | NULL | 1715 | 2016-11-20 11:15:00 |
| 1716 | audio_guide_desk | NULL | 3 | 1716 | 2016-11-20 12:04:29 |
| 1717 | ticket_desk | 1 | NULL | 1717 | 2016-11-20 12:36:28 |
| 1718 | ticket_desk | 1 | NULL | 1718 | 2016-11-20 13:35:37 |
| 1719 | ticket_desk | 1 | NULL | 1719 | 2016-11-21 14:02:20 |
| 1720 | ticket_desk | 2 | NULL | 1720 | 2016-11-21 14:26:13 |
| 1721 | app_store | NULL | NULL | 1721 | 2016-11-21 18:10:26 |
| 1722 | ticket_desk | 4 | NULL | 1722 | 2016-11-22 14:09:32 |
| 1723 | audio_guide_desk | NULL | 3 | 1723 | 2016-11-22 14:36:32 |
| 1724 | app_store | NULL | NULL | 1724 | 2016-11-23 06:26:56 |
| 1725 | ticket_desk | 4 | NULL | 1725 | 2016-11-23 09:52: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;