Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 3,476–3,500 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3476 | ticket_desk | 2 | NULL | 3476 | 2018-07-27 11:46:01 |
| 3477 | online | NULL | NULL | 3477 | 2018-07-27 16:05:39 |
| 3478 | online | NULL | NULL | 3478 | 2018-07-27 19:12:38 |
| 3479 | app_store | NULL | NULL | 3479 | 2018-07-28 02:23:05 |
| 3480 | online | NULL | NULL | 3480 | 2018-07-28 12:43:49 |
| 3481 | ticket_desk | 5 | NULL | 3481 | 2018-07-28 12:45:06 |
| 3482 | online | NULL | NULL | 3482 | 2018-07-28 16:02:28 |
| 3483 | online | NULL | NULL | 3483 | 2018-07-28 21:37:49 |
| 3484 | app_store | NULL | NULL | 3484 | 2018-07-29 01:55:13 |
| 3485 | ticket_desk | 2 | NULL | 3485 | 2018-07-29 09:02:52 |
| 3486 | audio_guide_desk | NULL | 1 | 3486 | 2018-07-29 09:35:31 |
| 3487 | app_store | NULL | NULL | 3487 | 2018-07-29 09:58:57 |
| 3488 | online | NULL | NULL | 3488 | 2018-07-29 12:34:27 |
| 3489 | online | NULL | NULL | 3489 | 2018-07-30 07:42:24 |
| 3490 | audio_guide_desk | NULL | 1 | 3490 | 2018-07-30 13:37:10 |
| 3491 | ticket_desk | 1 | NULL | 3491 | 2018-07-30 15:11:07 |
| 3492 | audio_guide_desk | NULL | 1 | 3492 | 2018-07-30 15:53:30 |
| 3493 | ticket_desk | 1 | NULL | 3493 | 2018-07-31 09:32:31 |
| 3494 | ticket_desk | 5 | NULL | 3494 | 2018-07-31 12:43:06 |
| 3495 | online | NULL | NULL | 3495 | 2018-07-31 15:29:47 |
| 3496 | app_store | NULL | NULL | 3496 | 2018-08-01 05:51:30 |
| 3497 | online | NULL | NULL | 3497 | 2018-08-01 07:49:26 |
| 3498 | online | NULL | NULL | 3498 | 2018-08-01 15:34:35 |
| 3499 | app_store | NULL | NULL | 3499 | 2018-08-01 15:37:58 |
| 3500 | online | NULL | NULL | 3500 | 2018-08-02 07:37:46 |
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;