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,026–4,050 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4026 | ticket_desk | 1 | NULL | 4026 | 2019-01-04 14:15:27 |
| 4027 | ticket_desk | 1 | NULL | 4027 | 2019-01-05 08:57:32 |
| 4028 | online | NULL | NULL | 4028 | 2019-01-05 11:36:44 |
| 4029 | online | NULL | NULL | 4029 | 2019-01-06 11:26:18 |
| 4030 | ticket_desk | 1 | NULL | 4030 | 2019-01-06 12:23:07 |
| 4031 | ticket_desk | 4 | NULL | 4031 | 2019-01-06 13:39:21 |
| 4032 | online | NULL | NULL | 4032 | 2019-01-06 21:18:19 |
| 4033 | audio_guide_desk | NULL | 3 | 4033 | 2019-01-08 15:31:19 |
| 4034 | ticket_desk | 2 | NULL | 4034 | 2019-01-09 10:02:13 |
| 4035 | audio_guide_desk | NULL | 1 | 4035 | 2019-01-09 10:14:13 |
| 4036 | audio_guide_desk | NULL | 2 | 4036 | 2019-01-09 13:09:17 |
| 4037 | audio_guide_desk | NULL | 2 | 4037 | 2019-01-09 13:15:52 |
| 4038 | app_store | NULL | NULL | 4038 | 2019-01-10 10:01:27 |
| 4039 | online | NULL | NULL | 4039 | 2019-01-10 13:55:47 |
| 4040 | online | NULL | NULL | 4040 | 2019-01-11 23:09:27 |
| 4041 | ticket_desk | 3 | NULL | 4041 | 2019-01-12 09:58:13 |
| 4042 | ticket_desk | 4 | NULL | 4042 | 2019-01-12 10:37:15 |
| 4043 | online | NULL | NULL | 4043 | 2019-01-13 23:22:40 |
| 4044 | online | NULL | NULL | 4044 | 2019-01-14 10:53:13 |
| 4045 | ticket_desk | 3 | NULL | 4045 | 2019-01-14 13:36:03 |
| 4046 | online | NULL | NULL | 4046 | 2019-01-15 17:31:49 |
| 4047 | app_store | NULL | NULL | 4047 | 2019-01-16 01:47:17 |
| 4048 | online | NULL | NULL | 4048 | 2019-01-16 11:41:08 |
| 4049 | app_store | NULL | NULL | 4049 | 2019-01-17 05:44:13 |
| 4050 | online | NULL | NULL | 4050 | 2019-01-18 07:03:26 |
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;