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,951–1,975 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1951 | online | NULL | NULL | 1951 | 2017-02-22 18:50:47 |
| 1952 | app_store | NULL | NULL | 1952 | 2017-02-23 12:18:26 |
| 1953 | audio_guide_desk | NULL | 2 | 1953 | 2017-02-24 13:34:00 |
| 1954 | online | NULL | NULL | 1954 | 2017-02-24 15:50:35 |
| 1955 | online | NULL | NULL | 1955 | 2017-02-24 17:10:45 |
| 1956 | app_store | NULL | NULL | 1956 | 2017-02-24 18:40:35 |
| 1957 | app_store | NULL | NULL | 1957 | 2017-02-24 19:53:51 |
| 1958 | online | NULL | NULL | 1958 | 2017-02-25 10:43:03 |
| 1959 | online | NULL | NULL | 1959 | 2017-02-26 08:09:02 |
| 1960 | audio_guide_desk | NULL | 1 | 1960 | 2017-02-26 13:20:40 |
| 1961 | ticket_desk | 1 | NULL | 1961 | 2017-02-27 09:51:22 |
| 1962 | ticket_desk | 1 | NULL | 1962 | 2017-02-28 09:12:27 |
| 1963 | ticket_desk | 1 | NULL | 1963 | 2017-03-01 10:27:06 |
| 1964 | audio_guide_desk | NULL | 2 | 1964 | 2017-03-01 10:51:15 |
| 1965 | online | NULL | NULL | 1965 | 2017-03-01 12:55:10 |
| 1966 | app_store | NULL | NULL | 1966 | 2017-03-01 13:39:25 |
| 1967 | online | NULL | NULL | 1967 | 2017-03-02 14:03:25 |
| 1968 | ticket_desk | 1 | NULL | 1968 | 2017-03-03 10:05:54 |
| 1969 | online | NULL | NULL | 1969 | 2017-03-03 10:15:23 |
| 1970 | online | NULL | NULL | 1970 | 2017-03-03 10:22:11 |
| 1971 | audio_guide_desk | NULL | 1 | 1971 | 2017-03-03 10:52:08 |
| 1972 | online | NULL | NULL | 1972 | 2017-03-04 09:17:13 |
| 1973 | audio_guide_desk | NULL | 2 | 1973 | 2017-03-05 09:24:17 |
| 1974 | ticket_desk | 1 | NULL | 1974 | 2017-03-05 10:42:53 |
| 1975 | audio_guide_desk | NULL | 2 | 1975 | 2017-03-05 11:12:43 |
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;