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,501–1,525 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1501 | online | NULL | NULL | 1501 | 2016-08-15 10:16:58 |
| 1502 | audio_guide_desk | NULL | 2 | 1502 | 2016-08-15 14:12:58 |
| 1503 | audio_guide_desk | NULL | 2 | 1503 | 2016-08-15 14:13:33 |
| 1504 | ticket_desk | 1 | NULL | 1504 | 2016-08-16 11:46:26 |
| 1505 | audio_guide_desk | NULL | 1 | 1505 | 2016-08-16 12:04:58 |
| 1506 | audio_guide_desk | NULL | 1 | 1506 | 2016-08-16 12:06:42 |
| 1507 | audio_guide_desk | NULL | 2 | 1507 | 2016-08-16 12:15:44 |
| 1508 | online | NULL | NULL | 1508 | 2016-08-16 16:05:53 |
| 1509 | online | NULL | NULL | 1509 | 2016-08-16 20:04:20 |
| 1510 | online | NULL | NULL | 1510 | 2016-08-17 10:06:45 |
| 1511 | online | NULL | NULL | 1511 | 2016-08-17 17:24:39 |
| 1512 | online | NULL | NULL | 1512 | 2016-08-17 20:25:30 |
| 1513 | ticket_desk | 4 | NULL | 1513 | 2016-08-18 10:41:16 |
| 1514 | online | NULL | NULL | 1514 | 2016-08-18 12:42:36 |
| 1515 | app_store | NULL | NULL | 1515 | 2016-08-19 05:07:22 |
| 1516 | audio_guide_desk | NULL | 2 | 1516 | 2016-08-19 14:47:41 |
| 1517 | ticket_desk | 2 | NULL | 1517 | 2016-08-20 11:05:01 |
| 1518 | online | NULL | NULL | 1518 | 2016-08-20 17:21:57 |
| 1519 | ticket_desk | 1 | NULL | 1519 | 2016-08-21 10:04:44 |
| 1520 | audio_guide_desk | NULL | 3 | 1520 | 2016-08-21 10:49:00 |
| 1521 | online | NULL | NULL | 1521 | 2016-08-21 11:11:20 |
| 1522 | audio_guide_desk | NULL | 2 | 1522 | 2016-08-21 14:00:47 |
| 1523 | audio_guide_desk | NULL | 3 | 1523 | 2016-08-21 14:44:31 |
| 1524 | app_store | NULL | NULL | 1524 | 2016-08-21 15:13:20 |
| 1525 | online | NULL | NULL | 1525 | 2016-08-21 16:49:08 |
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;