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,076–3,100 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3076 | online | NULL | NULL | 3076 | 2018-04-06 09:08:12 |
| 3077 | app_store | NULL | NULL | 3077 | 2018-04-06 09:12:55 |
| 3078 | online | NULL | NULL | 3078 | 2018-04-06 11:16:58 |
| 3079 | app_store | NULL | NULL | 3079 | 2018-04-06 11:22:20 |
| 3080 | online | NULL | NULL | 3080 | 2018-04-06 12:31:40 |
| 3081 | ticket_desk | 2 | NULL | 3081 | 2018-04-07 11:19:17 |
| 3082 | audio_guide_desk | NULL | 2 | 3082 | 2018-04-07 11:52:23 |
| 3083 | ticket_desk | 1 | NULL | 3083 | 2018-04-08 09:59:03 |
| 3084 | audio_guide_desk | NULL | 1 | 3084 | 2018-04-08 12:18:17 |
| 3085 | online | NULL | NULL | 3085 | 2018-04-08 22:30:26 |
| 3086 | online | NULL | NULL | 3086 | 2018-04-09 12:14:51 |
| 3087 | ticket_desk | 1 | NULL | 3087 | 2018-04-09 14:57:02 |
| 3088 | audio_guide_desk | NULL | 2 | 3088 | 2018-04-09 15:33:54 |
| 3089 | app_store | NULL | NULL | 3089 | 2018-04-10 02:26:02 |
| 3090 | app_store | NULL | NULL | 3090 | 2018-04-10 04:14:01 |
| 3091 | ticket_desk | 1 | NULL | 3091 | 2018-04-10 11:09:12 |
| 3092 | audio_guide_desk | NULL | 3 | 3092 | 2018-04-10 11:55:35 |
| 3093 | ticket_desk | 2 | NULL | 3093 | 2018-04-10 15:01:14 |
| 3094 | online | NULL | NULL | 3094 | 2018-04-10 23:18:48 |
| 3095 | online | NULL | NULL | 3095 | 2018-04-11 08:13:48 |
| 3096 | online | NULL | NULL | 3096 | 2018-04-11 15:12:20 |
| 3097 | online | NULL | NULL | 3097 | 2018-04-11 22:27:39 |
| 3098 | ticket_desk | 1 | NULL | 3098 | 2018-04-12 10:47:07 |
| 3099 | app_store | NULL | NULL | 3099 | 2018-04-12 11:04:07 |
| 3100 | audio_guide_desk | NULL | 3 | 3100 | 2018-04-12 11:08:08 |
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;