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,426–1,450 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1426 | ticket_desk | 1 | NULL | 1426 | 2016-07-22 11:01:57 |
| 1427 | ticket_desk | 1 | NULL | 1427 | 2016-07-22 13:03:01 |
| 1428 | app_store | NULL | NULL | 1428 | 2016-07-22 19:05:18 |
| 1429 | online | NULL | NULL | 1429 | 2016-07-22 21:32:00 |
| 1430 | online | NULL | NULL | 1430 | 2016-07-22 21:38:58 |
| 1431 | online | NULL | NULL | 1431 | 2016-07-23 09:13:35 |
| 1432 | online | NULL | NULL | 1432 | 2016-07-23 09:19:57 |
| 1433 | ticket_desk | 3 | NULL | 1433 | 2016-07-23 14:10:14 |
| 1434 | online | NULL | NULL | 1434 | 2016-07-24 17:58:28 |
| 1435 | online | NULL | NULL | 1435 | 2016-07-24 21:16:01 |
| 1436 | audio_guide_desk | NULL | 2 | 1436 | 2016-07-25 11:04:55 |
| 1437 | online | NULL | NULL | 1437 | 2016-07-26 11:47:24 |
| 1438 | online | NULL | NULL | 1438 | 2016-07-26 12:27:17 |
| 1439 | audio_guide_desk | NULL | 1 | 1439 | 2016-07-26 14:50:28 |
| 1440 | online | NULL | NULL | 1440 | 2016-07-26 15:15:44 |
| 1441 | ticket_desk | 1 | NULL | 1441 | 2016-07-26 15:25:32 |
| 1442 | ticket_desk | 1 | NULL | 1442 | 2016-07-27 09:24:41 |
| 1443 | ticket_desk | 1 | NULL | 1443 | 2016-07-27 10:38:06 |
| 1444 | online | NULL | NULL | 1444 | 2016-07-28 09:06:48 |
| 1445 | ticket_desk | 2 | NULL | 1445 | 2016-07-28 11:17:23 |
| 1446 | online | NULL | NULL | 1446 | 2016-07-28 20:39:47 |
| 1447 | ticket_desk | 3 | NULL | 1447 | 2016-07-30 15:51:50 |
| 1448 | online | NULL | NULL | 1448 | 2016-07-30 17:50:29 |
| 1449 | audio_guide_desk | NULL | 3 | 1449 | 2016-07-31 09:51:49 |
| 1450 | ticket_desk | 2 | NULL | 1450 | 2016-07-31 10:51:59 |
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;