Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,501–4,525 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4501 | audio_guide_desk | NULL | 2 | 4501 | 2019-06-09 09:32:58 |
| 4502 | online | NULL | NULL | 4502 | 2019-06-09 10:07:47 |
| 4503 | online | NULL | NULL | 4503 | 2019-06-10 09:04:26 |
| 4504 | ticket_desk | 1 | NULL | 4504 | 2019-06-10 15:19:17 |
| 4505 | ticket_desk | 1 | NULL | 4505 | 2019-06-11 09:32:22 |
| 4506 | audio_guide_desk | NULL | 2 | 4506 | 2019-06-11 09:48:15 |
| 4507 | audio_guide_desk | NULL | 2 | 4507 | 2019-06-11 09:48:52 |
| 4508 | ticket_desk | 2 | NULL | 4508 | 2019-06-11 10:20:13 |
| 4509 | audio_guide_desk | NULL | 1 | 4509 | 2019-06-11 15:16:55 |
| 4510 | app_store | NULL | NULL | 4510 | 2019-06-11 20:46:15 |
| 4511 | app_store | NULL | NULL | 4511 | 2019-06-12 00:36:10 |
| 4512 | online | NULL | NULL | 4512 | 2019-06-12 20:44:36 |
| 4513 | ticket_desk | 4 | NULL | 4513 | 2019-06-13 12:25:12 |
| 4514 | audio_guide_desk | NULL | 2 | 4514 | 2019-06-13 12:59:03 |
| 4515 | online | NULL | NULL | 4515 | 2019-06-13 21:00:42 |
| 4516 | online | NULL | NULL | 4516 | 2019-06-13 21:59:27 |
| 4517 | online | NULL | NULL | 4517 | 2019-06-14 08:01:58 |
| 4518 | online | NULL | NULL | 4518 | 2019-06-14 09:18:25 |
| 4519 | app_store | NULL | NULL | 4519 | 2019-06-14 11:46:48 |
| 4520 | ticket_desk | 4 | NULL | 4520 | 2019-06-14 12:16:01 |
| 4521 | online | NULL | NULL | 4521 | 2019-06-14 12:57:08 |
| 4522 | online | NULL | NULL | 4522 | 2019-06-14 14:04:02 |
| 4523 | online | NULL | NULL | 4523 | 2019-06-14 17:43:41 |
| 4524 | online | NULL | NULL | 4524 | 2019-06-14 20:37:29 |
| 4525 | audio_guide_desk | NULL | 1 | 4525 | 2019-06-15 11:09:42 |
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;