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,451–1,475 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1451 | ticket_desk | 1 | NULL | 1451 | 2016-07-31 11:04:10 |
| 1452 | audio_guide_desk | NULL | 2 | 1452 | 2016-07-31 11:17:57 |
| 1453 | audio_guide_desk | NULL | 2 | 1453 | 2016-07-31 11:22:16 |
| 1454 | audio_guide_desk | NULL | 3 | 1454 | 2016-07-31 11:51:22 |
| 1455 | audio_guide_desk | NULL | 2 | 1455 | 2016-07-31 13:19:49 |
| 1456 | app_store | NULL | NULL | 1456 | 2016-07-31 14:01:57 |
| 1457 | audio_guide_desk | NULL | 2 | 1457 | 2016-07-31 17:09:22 |
| 1458 | app_store | NULL | NULL | 1458 | 2016-08-01 02:00:07 |
| 1459 | audio_guide_desk | NULL | 1 | 1459 | 2016-08-02 10:05:39 |
| 1460 | online | NULL | NULL | 1460 | 2016-08-02 12:23:15 |
| 1461 | ticket_desk | 1 | NULL | 1461 | 2016-08-02 13:06:41 |
| 1462 | online | NULL | NULL | 1462 | 2016-08-02 15:04:23 |
| 1463 | online | NULL | NULL | 1463 | 2016-08-02 15:07:12 |
| 1464 | audio_guide_desk | NULL | 3 | 1464 | 2016-08-02 15:33:40 |
| 1465 | app_store | NULL | NULL | 1465 | 2016-08-02 22:34:38 |
| 1466 | app_store | NULL | NULL | 1466 | 2016-08-03 03:33:53 |
| 1467 | app_store | NULL | NULL | 1467 | 2016-08-03 21:49:55 |
| 1468 | online | NULL | NULL | 1468 | 2016-08-04 08:22:41 |
| 1469 | online | NULL | NULL | 1469 | 2016-08-04 18:27:02 |
| 1470 | ticket_desk | 1 | NULL | 1470 | 2016-08-05 12:06:42 |
| 1471 | online | NULL | NULL | 1471 | 2016-08-05 19:38:43 |
| 1472 | app_store | NULL | NULL | 1472 | 2016-08-06 06:17:52 |
| 1473 | app_store | NULL | NULL | 1473 | 2016-08-06 06:35:18 |
| 1474 | ticket_desk | 1 | NULL | 1474 | 2016-08-06 09:29:24 |
| 1475 | audio_guide_desk | NULL | 1 | 1475 | 2016-08-06 10:09: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;