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,901–1,925 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1901 | ticket_desk | 2 | NULL | 1901 | 2017-01-31 10:42:45 |
| 1902 | audio_guide_desk | NULL | 2 | 1902 | 2017-01-31 11:31:28 |
| 1903 | online | NULL | NULL | 1903 | 2017-01-31 21:51:39 |
| 1904 | app_store | NULL | NULL | 1904 | 2017-02-01 10:21:26 |
| 1905 | online | NULL | NULL | 1905 | 2017-02-02 13:45:47 |
| 1906 | online | NULL | NULL | 1906 | 2017-02-02 23:42:39 |
| 1907 | audio_guide_desk | NULL | 2 | 1907 | 2017-02-03 15:11:47 |
| 1908 | app_store | NULL | NULL | 1908 | 2017-02-04 07:48:29 |
| 1909 | online | NULL | NULL | 1909 | 2017-02-04 10:38:41 |
| 1910 | online | NULL | NULL | 1910 | 2017-02-04 13:15:25 |
| 1911 | ticket_desk | 2 | NULL | 1911 | 2017-02-05 10:50:37 |
| 1912 | ticket_desk | 2 | NULL | 1912 | 2017-02-05 11:06:22 |
| 1913 | audio_guide_desk | NULL | 1 | 1913 | 2017-02-05 11:27:29 |
| 1914 | online | NULL | NULL | 1914 | 2017-02-05 11:33:21 |
| 1915 | online | NULL | NULL | 1915 | 2017-02-05 23:16:30 |
| 1916 | ticket_desk | 1 | NULL | 1916 | 2017-02-06 08:54:31 |
| 1917 | audio_guide_desk | NULL | 3 | 1917 | 2017-02-06 09:29:30 |
| 1918 | online | NULL | NULL | 1918 | 2017-02-06 16:16:36 |
| 1919 | audio_guide_desk | NULL | 2 | 1919 | 2017-02-07 10:40:32 |
| 1920 | online | NULL | NULL | 1920 | 2017-02-10 10:19:30 |
| 1921 | ticket_desk | 1 | NULL | 1921 | 2017-02-11 11:37:47 |
| 1922 | ticket_desk | 1 | NULL | 1922 | 2017-02-11 13:32:03 |
| 1923 | audio_guide_desk | NULL | 1 | 1923 | 2017-02-11 14:17:24 |
| 1924 | online | NULL | NULL | 1924 | 2017-02-11 14:48:33 |
| 1925 | online | NULL | NULL | 1925 | 2017-02-11 19:01:04 |
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;