Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,376–4,400 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4376 | online | NULL | NULL | 4376 | 2019-05-02 17:37:05 |
| 4377 | online | NULL | NULL | 4377 | 2019-05-02 18:03:49 |
| 4378 | audio_guide_desk | NULL | 3 | 4378 | 2019-05-03 15:30:48 |
| 4379 | online | NULL | NULL | 4379 | 2019-05-03 19:02:48 |
| 4380 | app_store | NULL | NULL | 4380 | 2019-05-04 03:08:08 |
| 4381 | online | NULL | NULL | 4381 | 2019-05-04 07:29:05 |
| 4382 | audio_guide_desk | NULL | 3 | 4382 | 2019-05-04 10:49:22 |
| 4383 | ticket_desk | 1 | NULL | 4383 | 2019-05-04 10:52:13 |
| 4384 | audio_guide_desk | NULL | 3 | 4384 | 2019-05-04 11:24:15 |
| 4385 | audio_guide_desk | NULL | 3 | 4385 | 2019-05-04 11:28:37 |
| 4386 | ticket_desk | 2 | NULL | 4386 | 2019-05-04 13:18:42 |
| 4387 | online | NULL | NULL | 4387 | 2019-05-05 10:19:14 |
| 4388 | app_store | NULL | NULL | 4388 | 2019-05-05 13:35:08 |
| 4389 | audio_guide_desk | NULL | 1 | 4389 | 2019-05-05 16:12:03 |
| 4390 | app_store | NULL | NULL | 4390 | 2019-05-06 08:36:45 |
| 4391 | online | NULL | NULL | 4391 | 2019-05-06 11:51:10 |
| 4392 | online | NULL | NULL | 4392 | 2019-05-06 17:12:43 |
| 4393 | online | NULL | NULL | 4393 | 2019-05-06 23:05:52 |
| 4394 | app_store | NULL | NULL | 4394 | 2019-05-07 11:26:16 |
| 4395 | app_store | NULL | NULL | 4395 | 2019-05-07 13:47:46 |
| 4396 | online | NULL | NULL | 4396 | 2019-05-07 14:11:18 |
| 4397 | audio_guide_desk | NULL | 2 | 4397 | 2019-05-07 15:17:23 |
| 4398 | app_store | NULL | NULL | 4398 | 2019-05-07 19:55:39 |
| 4399 | online | NULL | NULL | 4399 | 2019-05-08 11:51:39 |
| 4400 | online | NULL | NULL | 4400 | 2019-05-08 15:34:30 |
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;