Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 1,351–1,375 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1351 | ticket_desk | 2 | NULL | 1351 | 2016-06-30 13:38:38 |
| 1352 | audio_guide_desk | NULL | 1 | 1352 | 2016-06-30 14:02:39 |
| 1353 | ticket_desk | 1 | NULL | 1353 | 2016-07-01 11:56:23 |
| 1354 | audio_guide_desk | NULL | 2 | 1354 | 2016-07-01 12:25:33 |
| 1355 | ticket_desk | 1 | NULL | 1355 | 2016-07-01 13:41:45 |
| 1356 | ticket_desk | 1 | NULL | 1356 | 2016-07-01 14:41:51 |
| 1357 | ticket_desk | 4 | NULL | 1357 | 2016-07-02 09:59:47 |
| 1358 | audio_guide_desk | NULL | 2 | 1358 | 2016-07-02 10:17:07 |
| 1359 | ticket_desk | 5 | NULL | 1359 | 2016-07-02 10:35:47 |
| 1360 | audio_guide_desk | NULL | 3 | 1360 | 2016-07-02 11:03:38 |
| 1361 | online | NULL | NULL | 1361 | 2016-07-02 13:24:50 |
| 1362 | online | NULL | NULL | 1362 | 2016-07-02 18:48:23 |
| 1363 | online | NULL | NULL | 1363 | 2016-07-04 09:11:58 |
| 1364 | online | NULL | NULL | 1364 | 2016-07-04 13:57:07 |
| 1365 | app_store | NULL | NULL | 1365 | 2016-07-05 07:25:00 |
| 1366 | online | NULL | NULL | 1366 | 2016-07-05 13:06:44 |
| 1367 | online | NULL | NULL | 1367 | 2016-07-05 13:07:54 |
| 1368 | online | NULL | NULL | 1368 | 2016-07-06 07:44:23 |
| 1369 | online | NULL | NULL | 1369 | 2016-07-06 08:56:30 |
| 1370 | audio_guide_desk | NULL | 1 | 1370 | 2016-07-06 10:29:36 |
| 1371 | online | NULL | NULL | 1371 | 2016-07-06 11:32:52 |
| 1372 | app_store | NULL | NULL | 1372 | 2016-07-06 13:26:06 |
| 1373 | app_store | NULL | NULL | 1373 | 2016-07-07 02:13:13 |
| 1374 | online | NULL | NULL | 1374 | 2016-07-07 08:51:43 |
| 1375 | audio_guide_desk | NULL | 2 | 1375 | 2016-07-07 11:40:51 |
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;