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,576–1,600 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1576 | audio_guide_desk | NULL | 2 | 1576 | 2016-09-11 11:21:46 |
| 1577 | audio_guide_desk | NULL | 2 | 1577 | 2016-09-11 11:31:24 |
| 1578 | online | NULL | NULL | 1578 | 2016-09-11 17:12:17 |
| 1579 | ticket_desk | 1 | NULL | 1579 | 2016-09-12 11:11:58 |
| 1580 | online | NULL | NULL | 1580 | 2016-09-12 22:37:35 |
| 1581 | online | NULL | NULL | 1581 | 2016-09-12 23:14:50 |
| 1582 | online | NULL | NULL | 1582 | 2016-09-12 23:35:03 |
| 1583 | app_store | NULL | NULL | 1583 | 2016-09-13 02:06:06 |
| 1584 | ticket_desk | 1 | NULL | 1584 | 2016-09-13 09:34:33 |
| 1585 | ticket_desk | 2 | NULL | 1585 | 2016-09-13 14:25:15 |
| 1586 | app_store | NULL | NULL | 1586 | 2016-09-13 18:36:49 |
| 1587 | app_store | NULL | NULL | 1587 | 2016-09-14 02:21:14 |
| 1588 | ticket_desk | 2 | NULL | 1588 | 2016-09-15 14:25:24 |
| 1589 | app_store | NULL | NULL | 1589 | 2016-09-17 05:20:48 |
| 1590 | audio_guide_desk | NULL | 2 | 1590 | 2016-09-17 16:43:34 |
| 1591 | online | NULL | NULL | 1591 | 2016-09-17 18:00:29 |
| 1592 | online | NULL | NULL | 1592 | 2016-09-17 20:44:28 |
| 1593 | ticket_desk | 3 | NULL | 1593 | 2016-09-18 09:54:22 |
| 1594 | app_store | NULL | NULL | 1594 | 2016-09-19 03:44:22 |
| 1595 | ticket_desk | 3 | NULL | 1595 | 2016-09-19 12:20:55 |
| 1596 | online | NULL | NULL | 1596 | 2016-09-19 13:39:59 |
| 1597 | ticket_desk | 1 | NULL | 1597 | 2016-09-19 16:01:36 |
| 1598 | app_store | NULL | NULL | 1598 | 2016-09-19 21:19:59 |
| 1599 | audio_guide_desk | NULL | 3 | 1599 | 2016-09-20 09:51:40 |
| 1600 | online | NULL | NULL | 1600 | 2016-09-20 16:52:55 |
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;