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,101–3,125 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3101 | ticket_desk | 2 | NULL | 3101 | 2018-04-12 14:04:15 |
| 3102 | app_store | NULL | NULL | 3102 | 2018-04-12 16:06:36 |
| 3103 | online | NULL | NULL | 3103 | 2018-04-12 16:16:22 |
| 3104 | ticket_desk | 2 | NULL | 3104 | 2018-04-13 10:12:01 |
| 3105 | online | NULL | NULL | 3105 | 2018-04-13 15:09:39 |
| 3106 | audio_guide_desk | NULL | 2 | 3106 | 2018-04-13 16:56:10 |
| 3107 | online | NULL | NULL | 3107 | 2018-04-14 08:18:03 |
| 3108 | ticket_desk | 5 | NULL | 3108 | 2018-04-14 10:27:41 |
| 3109 | audio_guide_desk | NULL | 2 | 3109 | 2018-04-14 11:04:05 |
| 3110 | app_store | NULL | NULL | 3110 | 2018-04-14 15:50:20 |
| 3111 | online | NULL | NULL | 3111 | 2018-04-14 21:57:02 |
| 3112 | online | NULL | NULL | 3112 | 2018-04-15 07:06:32 |
| 3113 | ticket_desk | 4 | NULL | 3113 | 2018-04-15 14:30:52 |
| 3114 | online | NULL | NULL | 3114 | 2018-04-15 19:43:12 |
| 3115 | online | NULL | NULL | 3115 | 2018-04-16 09:06:43 |
| 3116 | app_store | NULL | NULL | 3116 | 2018-04-16 12:16:56 |
| 3117 | audio_guide_desk | NULL | 1 | 3117 | 2018-04-16 16:42:52 |
| 3118 | online | NULL | NULL | 3118 | 2018-04-17 09:31:04 |
| 3119 | app_store | NULL | NULL | 3119 | 2018-04-17 13:17:13 |
| 3120 | online | NULL | NULL | 3120 | 2018-04-17 18:50:00 |
| 3121 | ticket_desk | 2 | NULL | 3121 | 2018-04-18 11:44:33 |
| 3122 | audio_guide_desk | NULL | 2 | 3122 | 2018-04-18 14:39:36 |
| 3123 | online | NULL | NULL | 3123 | 2018-04-18 14:57:44 |
| 3124 | online | NULL | NULL | 3124 | 2018-04-19 16:46:43 |
| 3125 | app_store | NULL | NULL | 3125 | 2018-04-20 05:11:17 |
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;