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,326–1,350 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 1326 | audio_guide_desk | NULL | 1 | 1326 | 2016-06-23 09:42:35 |
| 1327 | ticket_desk | 2 | NULL | 1327 | 2016-06-23 13:12:51 |
| 1328 | audio_guide_desk | NULL | 2 | 1328 | 2016-06-23 13:58:07 |
| 1329 | online | NULL | NULL | 1329 | 2016-06-23 18:17:39 |
| 1330 | audio_guide_desk | NULL | 2 | 1330 | 2016-06-24 09:25:18 |
| 1331 | online | NULL | NULL | 1331 | 2016-06-24 09:54:01 |
| 1332 | ticket_desk | 1 | NULL | 1332 | 2016-06-24 09:56:25 |
| 1333 | audio_guide_desk | NULL | 2 | 1333 | 2016-06-24 11:41:49 |
| 1334 | audio_guide_desk | NULL | 2 | 1334 | 2016-06-24 11:51:46 |
| 1335 | audio_guide_desk | NULL | 2 | 1335 | 2016-06-24 13:28:53 |
| 1336 | ticket_desk | 2 | NULL | 1336 | 2016-06-24 13:30:25 |
| 1337 | ticket_desk | 1 | NULL | 1337 | 2016-06-25 13:15:09 |
| 1338 | ticket_desk | 1 | NULL | 1338 | 2016-06-25 13:59:06 |
| 1339 | online | NULL | NULL | 1339 | 2016-06-25 17:37:38 |
| 1340 | ticket_desk | 2 | NULL | 1340 | 2016-06-26 11:47:22 |
| 1341 | audio_guide_desk | NULL | 1 | 1341 | 2016-06-26 12:14:04 |
| 1342 | audio_guide_desk | NULL | 1 | 1342 | 2016-06-26 12:15:51 |
| 1343 | app_store | NULL | NULL | 1343 | 2016-06-28 10:31:11 |
| 1344 | app_store | NULL | NULL | 1344 | 2016-06-28 10:47:25 |
| 1345 | online | NULL | NULL | 1345 | 2016-06-28 14:50:13 |
| 1346 | ticket_desk | 3 | NULL | 1346 | 2016-06-29 12:44:04 |
| 1347 | app_store | NULL | NULL | 1347 | 2016-06-29 18:43:00 |
| 1348 | online | NULL | NULL | 1348 | 2016-06-29 23:43:10 |
| 1349 | app_store | NULL | NULL | 1349 | 2016-06-30 04:35:53 |
| 1350 | online | NULL | NULL | 1350 | 2016-06-30 13:29:36 |
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;