Answer the question
In order to leave comments, you need to log in
How to organize the database structure for storing time between points (cities)?
Task: there are several delivery points (PD) from the central warehouse (CA) and the delivery time between the CA and PD. There are also transport companies (TC), whose services can also be used.
How to arrange storage delivery time?
Only the "head-on" option came to my mind:
CA - PD1 - Time1
CA - PD2 - Time2
CA - TC1 - Time3
CA - TC2 - Time4
TC1 - PD1 - Time5 TC2
- PD1 - Time6
And the second related task is to find the shortest delivery time . CS-PD or CS-TK-PD.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question