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,926–1,950 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1926 | audio_guide_desk | NULL | 2 | 1926 | 2017-02-12 09:28:40 |
| 1927 | audio_guide_desk | NULL | 2 | 1927 | 2017-02-12 09:32:16 |
| 1928 | online | NULL | NULL | 1928 | 2017-02-12 11:17:18 |
| 1929 | audio_guide_desk | NULL | 1 | 1929 | 2017-02-12 12:17:52 |
| 1930 | ticket_desk | 2 | NULL | 1930 | 2017-02-15 16:22:20 |
| 1931 | online | NULL | NULL | 1931 | 2017-02-15 16:50:06 |
| 1932 | app_store | NULL | NULL | 1932 | 2017-02-15 19:09:46 |
| 1933 | online | NULL | NULL | 1933 | 2017-02-16 16:36:03 |
| 1934 | online | NULL | NULL | 1934 | 2017-02-18 11:14:02 |
| 1935 | audio_guide_desk | NULL | 1 | 1935 | 2017-02-18 11:46:52 |
| 1936 | online | NULL | NULL | 1936 | 2017-02-18 19:08:48 |
| 1937 | audio_guide_desk | NULL | 1 | 1937 | 2017-02-19 09:10:27 |
| 1938 | ticket_desk | 1 | NULL | 1938 | 2017-02-19 12:17:12 |
| 1939 | audio_guide_desk | NULL | 1 | 1939 | 2017-02-19 12:34:12 |
| 1940 | audio_guide_desk | NULL | 2 | 1940 | 2017-02-19 12:45:59 |
| 1941 | online | NULL | NULL | 1941 | 2017-02-20 08:54:13 |
| 1942 | ticket_desk | 3 | NULL | 1942 | 2017-02-20 09:44:00 |
| 1943 | audio_guide_desk | NULL | 2 | 1943 | 2017-02-20 10:21:14 |
| 1944 | audio_guide_desk | NULL | 1 | 1944 | 2017-02-20 11:52:13 |
| 1945 | online | NULL | NULL | 1945 | 2017-02-20 13:29:06 |
| 1946 | online | NULL | NULL | 1946 | 2017-02-20 13:30:18 |
| 1947 | online | NULL | NULL | 1947 | 2017-02-21 14:59:32 |
| 1948 | online | NULL | NULL | 1948 | 2017-02-21 17:12:09 |
| 1949 | online | NULL | NULL | 1949 | 2017-02-21 17:46:03 |
| 1950 | online | NULL | NULL | 1950 | 2017-02-21 23:04:54 |
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;