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,476–4,500 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4476 | online | NULL | NULL | 4476 | 2019-05-31 19:25:19 |
| 4477 | online | NULL | NULL | 4477 | 2019-05-31 23:31:50 |
| 4478 | online | NULL | NULL | 4478 | 2019-06-01 17:01:44 |
| 4479 | app_store | NULL | NULL | 4479 | 2019-06-01 23:59:08 |
| 4480 | online | NULL | NULL | 4480 | 2019-06-02 08:51:02 |
| 4481 | online | NULL | NULL | 4481 | 2019-06-03 11:06:13 |
| 4482 | online | NULL | NULL | 4482 | 2019-06-03 13:58:04 |
| 4483 | online | NULL | NULL | 4483 | 2019-06-03 21:28:38 |
| 4484 | online | NULL | NULL | 4484 | 2019-06-04 09:18:27 |
| 4485 | ticket_desk | 1 | NULL | 4485 | 2019-06-04 11:09:37 |
| 4486 | audio_guide_desk | NULL | 3 | 4486 | 2019-06-04 11:41:51 |
| 4487 | app_store | NULL | NULL | 4487 | 2019-06-04 13:00:24 |
| 4488 | online | NULL | NULL | 4488 | 2019-06-05 10:11:48 |
| 4489 | online | NULL | NULL | 4489 | 2019-06-06 10:19:03 |
| 4490 | audio_guide_desk | NULL | 2 | 4490 | 2019-06-06 11:22:00 |
| 4491 | app_store | NULL | NULL | 4491 | 2019-06-07 04:24:35 |
| 4492 | online | NULL | NULL | 4492 | 2019-06-07 07:01:12 |
| 4493 | online | NULL | NULL | 4493 | 2019-06-07 09:27:24 |
| 4494 | online | NULL | NULL | 4494 | 2019-06-07 12:42:05 |
| 4495 | ticket_desk | 1 | NULL | 4495 | 2019-06-08 10:12:42 |
| 4496 | ticket_desk | 1 | NULL | 4496 | 2019-06-08 10:48:17 |
| 4497 | ticket_desk | 1 | NULL | 4497 | 2019-06-08 14:12:30 |
| 4498 | audio_guide_desk | NULL | 2 | 4498 | 2019-06-08 16:00:48 |
| 4499 | audio_guide_desk | NULL | 1 | 4499 | 2019-06-08 16:23:28 |
| 4500 | app_store | NULL | NULL | 4500 | 2019-06-09 06:09:03 |
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;