Analyzing freight price based on the route, container type and mode of inland transport Table sea_freight contain sea route, related price, vendor that arranged particular transportation Table inland_freigh contains inland route, related price , vendor that arranged particular transportation Table customer_order contains orders which apply to both sea_freight and inland_freight routes, but only these ones which contains inland transportation
POL - port of loading POD - port of discharge