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,876–1,900 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1876 | online | NULL | NULL | 1876 | 2017-01-22 17:05:54 |
| 1877 | ticket_desk | 1 | NULL | 1877 | 2017-01-23 12:01:56 |
| 1878 | online | NULL | NULL | 1878 | 2017-01-23 22:14:13 |
| 1879 | online | NULL | NULL | 1879 | 2017-01-23 22:58:55 |
| 1880 | online | NULL | NULL | 1880 | 2017-01-24 17:30:18 |
| 1881 | online | NULL | NULL | 1881 | 2017-01-24 18:04:39 |
| 1882 | online | NULL | NULL | 1882 | 2017-01-24 18:19:13 |
| 1883 | app_store | NULL | NULL | 1883 | 2017-01-24 23:47:42 |
| 1884 | audio_guide_desk | NULL | 2 | 1884 | 2017-01-26 10:53:56 |
| 1885 | audio_guide_desk | NULL | 2 | 1885 | 2017-01-26 11:12:58 |
| 1886 | audio_guide_desk | NULL | 2 | 1886 | 2017-01-26 11:15:49 |
| 1887 | ticket_desk | 5 | NULL | 1887 | 2017-01-26 13:04:44 |
| 1888 | online | NULL | NULL | 1888 | 2017-01-27 07:09:21 |
| 1889 | audio_guide_desk | NULL | 2 | 1889 | 2017-01-27 09:34:44 |
| 1890 | app_store | NULL | NULL | 1890 | 2017-01-27 09:34:50 |
| 1891 | ticket_desk | 3 | NULL | 1891 | 2017-01-27 09:55:59 |
| 1892 | audio_guide_desk | NULL | 1 | 1892 | 2017-01-27 10:28:55 |
| 1893 | ticket_desk | 5 | NULL | 1893 | 2017-01-27 10:33:37 |
| 1894 | audio_guide_desk | NULL | 2 | 1894 | 2017-01-27 13:43:41 |
| 1895 | ticket_desk | 4 | NULL | 1895 | 2017-01-27 15:10:08 |
| 1896 | audio_guide_desk | NULL | 2 | 1896 | 2017-01-27 15:37:20 |
| 1897 | app_store | NULL | NULL | 1897 | 2017-01-28 21:27:36 |
| 1898 | app_store | NULL | NULL | 1898 | 2017-01-29 08:47:58 |
| 1899 | online | NULL | NULL | 1899 | 2017-01-29 14:53:14 |
| 1900 | app_store | NULL | NULL | 1900 | 2017-01-30 20:01:23 |
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;