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,301–3,325 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3301 | online | NULL | NULL | 3301 | 2018-06-05 07:28:10 |
| 3302 | online | NULL | NULL | 3302 | 2018-06-06 07:00:49 |
| 3303 | app_store | NULL | NULL | 3303 | 2018-06-06 11:59:42 |
| 3304 | online | NULL | NULL | 3304 | 2018-06-06 16:57:24 |
| 3305 | online | NULL | NULL | 3305 | 2018-06-06 18:04:41 |
| 3306 | online | NULL | NULL | 3306 | 2018-06-06 18:44:35 |
| 3307 | ticket_desk | 1 | NULL | 3307 | 2018-06-07 10:23:44 |
| 3308 | ticket_desk | 3 | NULL | 3308 | 2018-06-07 13:01:51 |
| 3309 | app_store | NULL | NULL | 3309 | 2018-06-07 19:17:38 |
| 3310 | online | NULL | NULL | 3310 | 2018-06-08 07:34:02 |
| 3311 | online | NULL | NULL | 3311 | 2018-06-08 11:18:39 |
| 3312 | online | NULL | NULL | 3312 | 2018-06-08 13:27:02 |
| 3313 | app_store | NULL | NULL | 3313 | 2018-06-09 01:21:00 |
| 3314 | audio_guide_desk | NULL | 3 | 3314 | 2018-06-09 13:50:03 |
| 3315 | audio_guide_desk | NULL | 2 | 3315 | 2018-06-09 13:58:52 |
| 3316 | online | NULL | NULL | 3316 | 2018-06-10 07:07:55 |
| 3317 | ticket_desk | 2 | NULL | 3317 | 2018-06-10 10:46:23 |
| 3318 | online | NULL | NULL | 3318 | 2018-06-10 10:59:34 |
| 3319 | ticket_desk | 1 | NULL | 3319 | 2018-06-10 12:26:28 |
| 3320 | audio_guide_desk | NULL | 1 | 3320 | 2018-06-10 12:58:04 |
| 3321 | online | NULL | NULL | 3321 | 2018-06-10 14:46:17 |
| 3322 | online | NULL | NULL | 3322 | 2018-06-10 22:57:47 |
| 3323 | online | NULL | NULL | 3323 | 2018-06-11 13:47:50 |
| 3324 | online | NULL | NULL | 3324 | 2018-06-11 14:11:59 |
| 3325 | ticket_desk | 2 | NULL | 3325 | 2018-06-12 14:33:31 |
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;