Partner / Carrier Database

Ask the community
#1

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

@Bill.French fyi you legend any thoughts

#3

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.

#4

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.