The following diagram depicts the relationships between the Descartes Route Planner Database tables.
The main relationships that must be taken into consideration are:
Order Creation
The affected tables are:
FWOrder
FWOrderLine (1..n)
FWLocation (1..n)
FWLocationWindow (1..n)
FWActivityWindow (1..n)
Every Order created, will generate the following records:
FWActivity
One record for every leg of the order (i.e. double-ended jobs will have two activity records, one for the Pick-up and one for the Delivery).
FWStop
One record for every FWActivity created.
Ü Note - FWStop.ScheduleKey field will be null if assigned to a Route.
Resource creation
The affected Tables are:
FWResource
FWLocation (1..n. Initial and Final stations)
Every resource will generate the following records:
FWRoute
FWStop (1..n. One record for the initial and one for the final station)
