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,051–3,075 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3051 | audio_guide_desk | NULL | 2 | 3051 | 2018-03-31 09:29:58 |
| 3052 | ticket_desk | 5 | NULL | 3052 | 2018-03-31 13:14:02 |
| 3053 | online | NULL | NULL | 3053 | 2018-03-31 22:20:07 |
| 3054 | online | NULL | NULL | 3054 | 2018-04-01 07:03:57 |
| 3055 | app_store | NULL | NULL | 3055 | 2018-04-01 07:35:19 |
| 3056 | online | NULL | NULL | 3056 | 2018-04-01 07:41:04 |
| 3057 | app_store | NULL | NULL | 3057 | 2018-04-01 13:51:54 |
| 3058 | online | NULL | NULL | 3058 | 2018-04-01 15:18:18 |
| 3059 | app_store | NULL | NULL | 3059 | 2018-04-01 18:31:58 |
| 3060 | ticket_desk | 1 | NULL | 3060 | 2018-04-02 09:00:44 |
| 3061 | online | NULL | NULL | 3061 | 2018-04-02 12:16:12 |
| 3062 | online | NULL | NULL | 3062 | 2018-04-02 12:33:34 |
| 3063 | ticket_desk | 2 | NULL | 3063 | 2018-04-02 14:13:56 |
| 3064 | app_store | NULL | NULL | 3064 | 2018-04-02 15:37:41 |
| 3065 | online | NULL | NULL | 3065 | 2018-04-02 17:01:21 |
| 3066 | app_store | NULL | NULL | 3066 | 2018-04-02 18:10:54 |
| 3067 | app_store | NULL | NULL | 3067 | 2018-04-02 22:02:29 |
| 3068 | app_store | NULL | NULL | 3068 | 2018-04-03 03:06:00 |
| 3069 | online | NULL | NULL | 3069 | 2018-04-03 14:32:35 |
| 3070 | online | NULL | NULL | 3070 | 2018-04-03 20:11:52 |
| 3071 | ticket_desk | 5 | NULL | 3071 | 2018-04-04 08:57:00 |
| 3072 | audio_guide_desk | NULL | 2 | 3072 | 2018-04-04 09:19:39 |
| 3073 | online | NULL | NULL | 3073 | 2018-04-04 23:35:04 |
| 3074 | ticket_desk | 5 | NULL | 3074 | 2018-04-05 11:21:56 |
| 3075 | audio_guide_desk | NULL | 2 | 3075 | 2018-04-05 11:37: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;