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,701–4,725 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4701 | online | NULL | NULL | 4701 | 2019-07-29 15:54:01 |
| 4702 | app_store | NULL | NULL | 4702 | 2019-07-30 01:02:56 |
| 4703 | online | NULL | NULL | 4703 | 2019-07-30 10:40:28 |
| 4704 | ticket_desk | 4 | NULL | 4704 | 2019-07-30 10:56:49 |
| 4705 | audio_guide_desk | NULL | 2 | 4705 | 2019-07-30 13:32:08 |
| 4706 | online | NULL | NULL | 4706 | 2019-07-30 14:55:56 |
| 4707 | online | NULL | NULL | 4707 | 2019-07-31 13:30:13 |
| 4708 | online | NULL | NULL | 4708 | 2019-07-31 14:29:22 |
| 4709 | online | NULL | NULL | 4709 | 2019-07-31 22:38:42 |
| 4710 | app_store | NULL | NULL | 4710 | 2019-08-01 20:28:16 |
| 4711 | ticket_desk | 5 | NULL | 4711 | 2019-08-02 08:45:21 |
| 4712 | ticket_desk | 1 | NULL | 4712 | 2019-08-02 08:57:41 |
| 4713 | ticket_desk | 1 | NULL | 4713 | 2019-08-02 13:28:17 |
| 4714 | audio_guide_desk | NULL | 3 | 4714 | 2019-08-02 14:11:31 |
| 4715 | ticket_desk | 1 | NULL | 4715 | 2019-08-02 16:23:37 |
| 4716 | online | NULL | NULL | 4716 | 2019-08-02 23:16:24 |
| 4717 | online | NULL | NULL | 4717 | 2019-08-03 07:00:34 |
| 4718 | online | NULL | NULL | 4718 | 2019-08-03 09:25:44 |
| 4719 | online | NULL | NULL | 4719 | 2019-08-03 09:27:27 |
| 4720 | app_store | NULL | NULL | 4720 | 2019-08-03 10:13:43 |
| 4721 | online | NULL | NULL | 4721 | 2019-08-03 17:12:19 |
| 4722 | online | NULL | NULL | 4722 | 2019-08-03 22:28:52 |
| 4723 | app_store | NULL | NULL | 4723 | 2019-08-04 03:08:32 |
| 4724 | ticket_desk | 1 | NULL | 4724 | 2019-08-04 10:56:17 |
| 4725 | audio_guide_desk | NULL | 3 | 4725 | 2019-08-04 11:35:18 |
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;