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,451–2,475 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2451 | ticket_desk | 1 | NULL | 2451 | 2017-08-14 09:13:30 |
| 2452 | ticket_desk | 3 | NULL | 2452 | 2017-08-14 12:50:02 |
| 2453 | ticket_desk | 2 | NULL | 2453 | 2017-08-14 14:05:37 |
| 2454 | audio_guide_desk | NULL | 2 | 2454 | 2017-08-14 14:42:31 |
| 2455 | online | NULL | NULL | 2455 | 2017-08-14 15:33:49 |
| 2456 | online | NULL | NULL | 2456 | 2017-08-14 20:07:46 |
| 2457 | app_store | NULL | NULL | 2457 | 2017-08-15 07:29:32 |
| 2458 | app_store | NULL | NULL | 2458 | 2017-08-15 07:57:33 |
| 2459 | online | NULL | NULL | 2459 | 2017-08-15 08:31:12 |
| 2460 | ticket_desk | 2 | NULL | 2460 | 2017-08-15 09:33:11 |
| 2461 | online | NULL | NULL | 2461 | 2017-08-15 13:57:53 |
| 2462 | ticket_desk | 1 | NULL | 2462 | 2017-08-16 08:59:25 |
| 2463 | audio_guide_desk | NULL | 2 | 2463 | 2017-08-16 09:47:09 |
| 2464 | online | NULL | NULL | 2464 | 2017-08-16 21:45:50 |
| 2465 | app_store | NULL | NULL | 2465 | 2017-08-17 07:43:31 |
| 2466 | ticket_desk | 1 | NULL | 2466 | 2017-08-17 11:28:46 |
| 2467 | audio_guide_desk | NULL | 3 | 2467 | 2017-08-17 12:58:53 |
| 2468 | ticket_desk | 2 | NULL | 2468 | 2017-08-17 13:52:52 |
| 2469 | online | NULL | NULL | 2469 | 2017-08-18 09:16:40 |
| 2470 | online | NULL | NULL | 2470 | 2017-08-18 10:34:43 |
| 2471 | app_store | NULL | NULL | 2471 | 2017-08-18 12:48:56 |
| 2472 | online | NULL | NULL | 2472 | 2017-08-18 18:10:58 |
| 2473 | online | NULL | NULL | 2473 | 2017-08-18 21:50:52 |
| 2474 | ticket_desk | 4 | NULL | 2474 | 2017-08-19 13:54:16 |
| 2475 | online | NULL | NULL | 2475 | 2017-08-19 17:22:00 |
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;