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,251–3,275 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3251 | ticket_desk | 1 | NULL | 3251 | 2018-05-23 12:00:02 |
| 3252 | ticket_desk | 2 | NULL | 3252 | 2018-05-23 14:29:27 |
| 3253 | online | NULL | NULL | 3253 | 2018-05-24 08:26:38 |
| 3254 | ticket_desk | 1 | NULL | 3254 | 2018-05-24 13:59:09 |
| 3255 | audio_guide_desk | NULL | 2 | 3255 | 2018-05-25 13:35:21 |
| 3256 | online | NULL | NULL | 3256 | 2018-05-25 14:24:37 |
| 3257 | ticket_desk | 3 | NULL | 3257 | 2018-05-25 14:33:27 |
| 3258 | app_store | NULL | NULL | 3258 | 2018-05-26 08:30:07 |
| 3259 | ticket_desk | 1 | NULL | 3259 | 2018-05-26 10:32:35 |
| 3260 | online | NULL | NULL | 3260 | 2018-05-26 10:34:17 |
| 3261 | online | NULL | NULL | 3261 | 2018-05-26 21:19:39 |
| 3262 | app_store | NULL | NULL | 3262 | 2018-05-27 04:03:20 |
| 3263 | app_store | NULL | NULL | 3263 | 2018-05-27 10:23:09 |
| 3264 | ticket_desk | 1 | NULL | 3264 | 2018-05-27 10:42:04 |
| 3265 | audio_guide_desk | NULL | 1 | 3265 | 2018-05-27 11:32:51 |
| 3266 | online | NULL | NULL | 3266 | 2018-05-27 15:03:48 |
| 3267 | ticket_desk | 4 | NULL | 3267 | 2018-05-28 10:09:39 |
| 3268 | ticket_desk | 3 | NULL | 3268 | 2018-05-28 11:36:04 |
| 3269 | app_store | NULL | NULL | 3269 | 2018-05-28 21:44:22 |
| 3270 | online | NULL | NULL | 3270 | 2018-05-28 22:08:45 |
| 3271 | online | NULL | NULL | 3271 | 2018-05-29 09:18:48 |
| 3272 | online | NULL | NULL | 3272 | 2018-05-29 21:31:31 |
| 3273 | app_store | NULL | NULL | 3273 | 2018-05-30 04:03:13 |
| 3274 | ticket_desk | 3 | NULL | 3274 | 2018-05-30 09:07:42 |
| 3275 | audio_guide_desk | NULL | 3 | 3275 | 2018-05-30 09:56:55 |
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;