Re: table design for customer rates.

From: <artmt_at_hotmail.com>
Date: 18 Aug 2006 13:06:40 -0700
Message-ID: <1155931600.270938.313330@i42g2000cwa.googlegroups.com>

Table: LOCATION

---

LOCATION_ID PK
COUNTRY
REGION_TYPE
REGION_NAME
LOCATION_RATE_CATEGORY_ID Example:

1	USA	STATE	LA	1
2	SPAIN	PROV	ALL	2
3	USA	STATE	MA	3
4	USA	STATE	CA	3

Table: LOCATION_RATE_CATEGORY

---

LOCATION_RATE_CATEGORY_ID PK
LOCATION_RATE_CATEGORY_DESC Example:

1	USA LA
2	All of Spain
3	USA Other

Table: RATE

---

LOCATION_RATE_CATEGORY_ID PK1

SHIP_TYPE PK2
RATE_FIRST_500
RATE_ADDN_500

Example:
1	DOC	30	15
1	PARCEL	40	18
2	DOC	27	17
2	PARCEL	33	17

Received on Fri Aug 18 2006 - 15:06:40 CDT