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,526–1,550 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1526 | online | NULL | NULL | 1526 | 2016-08-21 16:49:20 |
| 1527 | app_store | NULL | NULL | 1527 | 2016-08-22 12:22:12 |
| 1528 | online | NULL | NULL | 1528 | 2016-08-22 19:47:17 |
| 1529 | online | NULL | NULL | 1529 | 2016-08-23 20:49:30 |
| 1530 | app_store | NULL | NULL | 1530 | 2016-08-24 03:29:10 |
| 1531 | ticket_desk | 1 | NULL | 1531 | 2016-08-24 09:08:51 |
| 1532 | online | NULL | NULL | 1532 | 2016-08-25 11:18:11 |
| 1533 | online | NULL | NULL | 1533 | 2016-08-25 15:48:13 |
| 1534 | online | NULL | NULL | 1534 | 2016-08-26 08:40:24 |
| 1535 | ticket_desk | 4 | NULL | 1535 | 2016-08-26 09:03:46 |
| 1536 | ticket_desk | 2 | NULL | 1536 | 2016-08-26 09:18:24 |
| 1537 | audio_guide_desk | NULL | 2 | 1537 | 2016-08-26 09:21:12 |
| 1538 | online | NULL | NULL | 1538 | 2016-08-26 11:13:56 |
| 1539 | ticket_desk | 1 | NULL | 1539 | 2016-08-26 11:32:47 |
| 1540 | audio_guide_desk | NULL | 2 | 1540 | 2016-08-26 12:12:22 |
| 1541 | audio_guide_desk | NULL | 1 | 1541 | 2016-08-26 14:55:36 |
| 1542 | audio_guide_desk | NULL | 1 | 1542 | 2016-08-26 14:56:03 |
| 1543 | ticket_desk | 2 | NULL | 1543 | 2016-08-27 09:45:32 |
| 1544 | online | NULL | NULL | 1544 | 2016-08-27 20:29:26 |
| 1545 | online | NULL | NULL | 1545 | 2016-08-28 08:26:37 |
| 1546 | ticket_desk | 4 | NULL | 1546 | 2016-08-28 10:51:37 |
| 1547 | ticket_desk | 2 | NULL | 1547 | 2016-08-29 11:15:52 |
| 1548 | audio_guide_desk | NULL | 2 | 1548 | 2016-08-29 11:50:30 |
| 1549 | online | NULL | NULL | 1549 | 2016-08-29 12:30:07 |
| 1550 | online | NULL | NULL | 1550 | 2016-08-29 21:53:49 |
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;