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,026–3,050 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3026 | online | NULL | NULL | 3026 | 2018-03-23 16:27:41 |
| 3027 | online | NULL | NULL | 3027 | 2018-03-24 10:06:56 |
| 3028 | ticket_desk | 1 | NULL | 3028 | 2018-03-24 10:25:55 |
| 3029 | audio_guide_desk | NULL | 1 | 3029 | 2018-03-24 11:12:54 |
| 3030 | app_store | NULL | NULL | 3030 | 2018-03-24 21:27:00 |
| 3031 | app_store | NULL | NULL | 3031 | 2018-03-25 00:25:18 |
| 3032 | app_store | NULL | NULL | 3032 | 2018-03-25 06:06:55 |
| 3033 | online | NULL | NULL | 3033 | 2018-03-25 15:29:38 |
| 3034 | ticket_desk | 1 | NULL | 3034 | 2018-03-26 10:37:30 |
| 3035 | ticket_desk | 3 | NULL | 3035 | 2018-03-26 12:06:58 |
| 3036 | audio_guide_desk | NULL | 3 | 3036 | 2018-03-26 12:31:20 |
| 3037 | app_store | NULL | NULL | 3037 | 2018-03-26 14:55:44 |
| 3038 | online | NULL | NULL | 3038 | 2018-03-26 20:07:38 |
| 3039 | online | NULL | NULL | 3039 | 2018-03-27 18:17:44 |
| 3040 | online | NULL | NULL | 3040 | 2018-03-28 09:05:11 |
| 3041 | online | NULL | NULL | 3041 | 2018-03-28 09:44:24 |
| 3042 | online | NULL | NULL | 3042 | 2018-03-28 12:39:17 |
| 3043 | ticket_desk | 1 | NULL | 3043 | 2018-03-29 09:21:59 |
| 3044 | ticket_desk | 1 | NULL | 3044 | 2018-03-29 09:37:54 |
| 3045 | audio_guide_desk | NULL | 2 | 3045 | 2018-03-29 10:01:54 |
| 3046 | audio_guide_desk | NULL | 3 | 3046 | 2018-03-29 10:22:00 |
| 3047 | ticket_desk | 4 | NULL | 3047 | 2018-03-30 11:11:46 |
| 3048 | online | NULL | NULL | 3048 | 2018-03-30 15:23:24 |
| 3049 | online | NULL | NULL | 3049 | 2018-03-30 22:08:08 |
| 3050 | ticket_desk | 2 | NULL | 3050 | 2018-03-31 08:50: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;