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,426–4,450 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4426 | online | NULL | NULL | 4426 | 2019-05-17 14:23:44 |
| 4427 | ticket_desk | 1 | NULL | 4427 | 2019-05-17 14:23:56 |
| 4428 | online | NULL | NULL | 4428 | 2019-05-18 07:51:12 |
| 4429 | online | NULL | NULL | 4429 | 2019-05-18 13:28:39 |
| 4430 | online | NULL | NULL | 4430 | 2019-05-19 09:55:57 |
| 4431 | ticket_desk | 1 | NULL | 4431 | 2019-05-19 10:52:20 |
| 4432 | audio_guide_desk | NULL | 2 | 4432 | 2019-05-19 11:10:22 |
| 4433 | ticket_desk | 1 | NULL | 4433 | 2019-05-19 12:38:17 |
| 4434 | ticket_desk | 1 | NULL | 4434 | 2019-05-20 10:06:03 |
| 4435 | online | NULL | NULL | 4435 | 2019-05-20 13:15:24 |
| 4436 | online | NULL | NULL | 4436 | 2019-05-21 15:06:12 |
| 4437 | audio_guide_desk | NULL | 3 | 4437 | 2019-05-21 16:24:26 |
| 4438 | app_store | NULL | NULL | 4438 | 2019-05-21 17:46:52 |
| 4439 | online | NULL | NULL | 4439 | 2019-05-21 18:28:06 |
| 4440 | online | NULL | NULL | 4440 | 2019-05-21 20:15:28 |
| 4441 | app_store | NULL | NULL | 4441 | 2019-05-22 11:32:07 |
| 4442 | online | NULL | NULL | 4442 | 2019-05-22 19:12:57 |
| 4443 | app_store | NULL | NULL | 4443 | 2019-05-22 23:43:30 |
| 4444 | app_store | NULL | NULL | 4444 | 2019-05-23 06:22:09 |
| 4445 | ticket_desk | 1 | NULL | 4445 | 2019-05-24 12:08:56 |
| 4446 | audio_guide_desk | NULL | 2 | 4446 | 2019-05-24 13:37:28 |
| 4447 | ticket_desk | 2 | NULL | 4447 | 2019-05-24 15:02:38 |
| 4448 | online | NULL | NULL | 4448 | 2019-05-24 21:37:59 |
| 4449 | app_store | NULL | NULL | 4449 | 2019-05-25 02:55:31 |
| 4450 | app_store | NULL | NULL | 4450 | 2019-05-25 03:28:57 |
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;