Re: Partner / Carrier Database

753 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, we are entering a new phase of business. We operate an uber like business.

We have a list of outer UK postcodes, with sub regions etc. We have around 400 companies / partners.

We need to allow partners to sign up, and select the postcodes that they operate in, as well as define their prices for 3 services in these areas.

Then I want to be able:

a) to lookup a postcode and service and see who offers the lowest price service for that area
b) to see all the carriers that operate in that area, this would be to distribute

2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

@Bill.French fyi you legend any thoughts

Yep, this suggests a link relationship from the partner record to the postcode database, a table that must be complete and support the sub-code areas too.

Since there’s a fixed number of service fees (3) there’s no reason to further abstract this data as a separate table unless each service has varient rates. Just create the three service tier fields for the pricing.

Given a specific postcode, it should be easy to reverse the relationship - i.e., list all partners where postcode matches and the three fees.