Page 1 of 1

Countries Table

Posted: Tue Mar 04, 2003 4:28 am
by wizzard
Hello,

I'm working on an e-commerce but i have a question and maybe someone in here has experience with this:

I'm working worldwide Belgium, Japan, US,... now for all the countries there are different shipping costs and also per weight.

Like for Belgium, UPS, Express Mail US Same but their are different prices how do i best fix this with different tables for prices and countries... ?

Best Regards
Kris

Posted: Tue Mar 04, 2003 9:56 am
by daven
Ideally, something like this (yes, it is kind of excessive, but I am a stickler for DB normalization)

TABLE Country

Code: Select all

country_ID  INT
country_Abbr  VARCHAR
country_Name VARCHAR
TABLE Service // UPS, FedEx, etc

Code: Select all

service_ID  INT
service_Name  VARCHAR
TABLE Weight // range of shipping weights. This table might be superfluous (not useful) if the various Services use vastly different weight tables

Code: Select all

weight_ID  INT
weight  REAL
TABLE ShipCost

Code: Select all

weight_ID  INT
country_ID  INT
service_ID  INT
cost  REAL

Posted: Tue Mar 04, 2003 10:23 am
by wizzard
Thanks Daven for the help