Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 2,476–2,500 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2476 | online | NULL | NULL | 2476 | 2017-08-20 09:37:27 |
| 2477 | ticket_desk | 3 | NULL | 2477 | 2017-08-20 12:23:44 |
| 2478 | online | NULL | NULL | 2478 | 2017-08-20 12:49:00 |
| 2479 | audio_guide_desk | NULL | 2 | 2479 | 2017-08-20 15:17:04 |
| 2480 | ticket_desk | 2 | NULL | 2480 | 2017-08-21 14:39:57 |
| 2481 | online | NULL | NULL | 2481 | 2017-08-21 20:33:22 |
| 2482 | online | NULL | NULL | 2482 | 2017-08-22 09:43:40 |
| 2483 | online | NULL | NULL | 2483 | 2017-08-22 11:27:09 |
| 2484 | ticket_desk | 1 | NULL | 2484 | 2017-08-22 11:44:09 |
| 2485 | audio_guide_desk | NULL | 2 | 2485 | 2017-08-22 12:16:43 |
| 2486 | ticket_desk | 4 | NULL | 2486 | 2017-08-22 12:22:43 |
| 2487 | ticket_desk | 1 | NULL | 2487 | 2017-08-22 15:41:29 |
| 2488 | audio_guide_desk | NULL | 3 | 2488 | 2017-08-22 16:13:09 |
| 2489 | online | NULL | NULL | 2489 | 2017-08-23 10:33:44 |
| 2490 | online | NULL | NULL | 2490 | 2017-08-23 14:10:17 |
| 2491 | online | NULL | NULL | 2491 | 2017-08-24 08:06:21 |
| 2492 | online | NULL | NULL | 2492 | 2017-08-24 08:53:10 |
| 2493 | ticket_desk | 2 | NULL | 2493 | 2017-08-24 11:47:31 |
| 2494 | ticket_desk | 3 | NULL | 2494 | 2017-08-24 11:49:14 |
| 2495 | online | NULL | NULL | 2495 | 2017-08-24 13:43:31 |
| 2496 | app_store | NULL | NULL | 2496 | 2017-08-24 23:05:05 |
| 2497 | app_store | NULL | NULL | 2497 | 2017-08-25 01:21:49 |
| 2498 | audio_guide_desk | NULL | 3 | 2498 | 2017-08-25 10:26:11 |
| 2499 | online | NULL | NULL | 2499 | 2017-08-25 11:56:49 |
| 2500 | online | NULL | NULL | 2500 | 2017-08-25 20:14:52 |
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;