Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,026–2,050 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2026 | ticket_desk | 1 | NULL | 2026 | 2017-03-28 10:38:13 |
| 2027 | ticket_desk | 4 | NULL | 2027 | 2017-03-31 12:26:38 |
| 2028 | ticket_desk | 1 | NULL | 2028 | 2017-03-31 12:41:37 |
| 2029 | app_store | NULL | NULL | 2029 | 2017-03-31 13:29:23 |
| 2030 | audio_guide_desk | NULL | 2 | 2030 | 2017-03-31 13:29:42 |
| 2031 | audio_guide_desk | NULL | 2 | 2031 | 2017-03-31 13:32:15 |
| 2032 | online | NULL | NULL | 2032 | 2017-03-31 14:32:45 |
| 2033 | ticket_desk | 2 | NULL | 2033 | 2017-03-31 15:47:30 |
| 2034 | ticket_desk | 2 | NULL | 2034 | 2017-04-01 12:57:38 |
| 2035 | online | NULL | NULL | 2035 | 2017-04-01 18:38:59 |
| 2036 | online | NULL | NULL | 2036 | 2017-04-01 21:31:44 |
| 2037 | online | NULL | NULL | 2037 | 2017-04-02 11:27:16 |
| 2038 | online | NULL | NULL | 2038 | 2017-04-02 14:28:18 |
| 2039 | app_store | NULL | NULL | 2039 | 2017-04-02 17:32:24 |
| 2040 | online | NULL | NULL | 2040 | 2017-04-02 18:17:17 |
| 2041 | app_store | NULL | NULL | 2041 | 2017-04-03 15:07:25 |
| 2042 | audio_guide_desk | NULL | 1 | 2042 | 2017-04-05 14:04:11 |
| 2043 | ticket_desk | 1 | NULL | 2043 | 2017-04-06 12:50:01 |
| 2044 | online | NULL | NULL | 2044 | 2017-04-06 16:20:37 |
| 2045 | ticket_desk | 2 | NULL | 2045 | 2017-04-07 14:34:36 |
| 2046 | online | NULL | NULL | 2046 | 2017-04-07 16:46:59 |
| 2047 | app_store | NULL | NULL | 2047 | 2017-04-08 01:45:50 |
| 2048 | ticket_desk | 2 | NULL | 2048 | 2017-04-08 10:17:23 |
| 2049 | online | NULL | NULL | 2049 | 2017-04-09 20:08:01 |
| 2050 | app_store | NULL | NULL | 2050 | 2017-04-10 01:08:53 |
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;