Partner / Carrier Database

[Aaron_Marc_Geor]

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

[Aaron_Marc_Geor]

@Bill.French fyi you legend any thoughts

[Bill_French]

Aaron_Marc_Georgiou:

We need to allow partners to sign up, and select the postcodes that they operate in

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.

Aaron_Marc_Georgiou:

define their prices for 3 services in these areas.

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.

Aaron_Marc_Georgiou:

to lookup a postcode and service and see who offers the lowest price service for that area

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