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,851–1,875 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1851 | online | NULL | NULL | 1851 | 2017-01-11 10:09:03 |
| 1852 | ticket_desk | 3 | NULL | 1852 | 2017-01-12 14:44:05 |
| 1853 | audio_guide_desk | NULL | 2 | 1853 | 2017-01-12 15:07:22 |
| 1854 | online | NULL | NULL | 1854 | 2017-01-13 15:26:58 |
| 1855 | online | NULL | NULL | 1855 | 2017-01-13 18:19:45 |
| 1856 | online | NULL | NULL | 1856 | 2017-01-14 14:10:36 |
| 1857 | audio_guide_desk | NULL | 2 | 1857 | 2017-01-14 16:08:26 |
| 1858 | app_store | NULL | NULL | 1858 | 2017-01-14 20:53:26 |
| 1859 | app_store | NULL | NULL | 1859 | 2017-01-15 10:29:48 |
| 1860 | app_store | NULL | NULL | 1860 | 2017-01-15 11:58:26 |
| 1861 | online | NULL | NULL | 1861 | 2017-01-15 17:19:55 |
| 1862 | ticket_desk | 4 | NULL | 1862 | 2017-01-16 10:39:44 |
| 1863 | audio_guide_desk | NULL | 1 | 1863 | 2017-01-16 11:15:57 |
| 1864 | online | NULL | NULL | 1864 | 2017-01-16 14:29:58 |
| 1865 | ticket_desk | 2 | NULL | 1865 | 2017-01-17 13:47:24 |
| 1866 | online | NULL | NULL | 1866 | 2017-01-18 08:27:07 |
| 1867 | online | NULL | NULL | 1867 | 2017-01-18 10:53:53 |
| 1868 | app_store | NULL | NULL | 1868 | 2017-01-18 11:25:21 |
| 1869 | online | NULL | NULL | 1869 | 2017-01-19 16:41:52 |
| 1870 | app_store | NULL | NULL | 1870 | 2017-01-20 06:00:50 |
| 1871 | ticket_desk | 1 | NULL | 1871 | 2017-01-20 13:52:33 |
| 1872 | audio_guide_desk | NULL | 1 | 1872 | 2017-01-20 14:44:08 |
| 1873 | audio_guide_desk | NULL | 2 | 1873 | 2017-01-21 10:16:12 |
| 1874 | online | NULL | NULL | 1874 | 2017-01-22 07:35:10 |
| 1875 | online | NULL | NULL | 1875 | 2017-01-22 10:51:17 |
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;