Re: table design for customer rates.

Hi,
Find out the entities.
  e.g,
country(id,name)
city(country,id,id,name)fk holds belongs to which country courier(id,type,name)
customer(id,name,....)
price(country.id,city.id,courier.id,customer,id,price)optionally can assign pk too.

It is better to maintain the price table separately in case of any changes on price. Received on Fri Aug 18 2006 - 09:42:27 CDT