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,326–2,350 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 2326 | online | NULL | NULL | 2326 | 2017-07-06 10:39:29 |
| 2327 | online | NULL | NULL | 2327 | 2017-07-06 11:49:05 |
| 2328 | online | NULL | NULL | 2328 | 2017-07-06 15:32:31 |
| 2329 | online | NULL | NULL | 2329 | 2017-07-06 15:44:43 |
| 2330 | online | NULL | NULL | 2330 | 2017-07-07 08:12:24 |
| 2331 | ticket_desk | 3 | NULL | 2331 | 2017-07-07 10:13:44 |
| 2332 | online | NULL | NULL | 2332 | 2017-07-07 14:04:04 |
| 2333 | app_store | NULL | NULL | 2333 | 2017-07-08 10:35:18 |
| 2334 | ticket_desk | 1 | NULL | 2334 | 2017-07-08 11:36:32 |
| 2335 | online | NULL | NULL | 2335 | 2017-07-08 12:53:25 |
| 2336 | audio_guide_desk | NULL | 2 | 2336 | 2017-07-08 13:18:38 |
| 2337 | audio_guide_desk | NULL | 2 | 2337 | 2017-07-08 13:21:18 |
| 2338 | audio_guide_desk | NULL | 2 | 2338 | 2017-07-08 13:54:40 |
| 2339 | audio_guide_desk | NULL | 3 | 2339 | 2017-07-09 09:27:46 |
| 2340 | ticket_desk | 5 | NULL | 2340 | 2017-07-09 13:11:49 |
| 2341 | ticket_desk | 3 | NULL | 2341 | 2017-07-09 13:23:56 |
| 2342 | app_store | NULL | NULL | 2342 | 2017-07-09 23:08:09 |
| 2343 | online | NULL | NULL | 2343 | 2017-07-10 15:17:32 |
| 2344 | online | NULL | NULL | 2344 | 2017-07-10 20:22:21 |
| 2345 | online | NULL | NULL | 2345 | 2017-07-10 20:59:18 |
| 2346 | ticket_desk | 1 | NULL | 2346 | 2017-07-11 11:19:31 |
| 2347 | online | NULL | NULL | 2347 | 2017-07-11 14:13:31 |
| 2348 | app_store | NULL | NULL | 2348 | 2017-07-11 19:53:46 |
| 2349 | online | NULL | NULL | 2349 | 2017-07-11 20:28:03 |
| 2350 | online | NULL | NULL | 2350 | 2017-07-11 23:04:20 |
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;