Are there any good resources online in terms of a good standard Address table hiearchy so that I don't reinvent the wheel? Currently we have addresses attached to a bunch of different tables, I am looking to consolidate this info into a single hierarchy.

I am thinking something along the lines of:

ADDRESS
- ADDRESS_ID
- BILLING_IND (Billing Indicator - bit)
- ACTIVE_IND (Active Indicator - bit)
- COUNTRY_ID
- PROVINCE_ID
- STATE_ID
- CITY_ID
- TIMEZONE_ID
- STREET_LINE_1
- STREET_LINE_2
- STREET_LINE_3
- POSTAL_CODE

COUNTRY
- COUNTRY_ID
- COUNTRY_NAME
- COUNTRY_ABBR

STATE
- STATE_ID
- STATE_NAME
- STATE_ABBR

PROVINCE (Combine with State data since it is one or the other?)
- PROVINCE_ID
- PROVINCE_NAME
- PROVINCE_ABBR

CITY
- CITY_ID
- CITY_NAME
- STATE_ID
- COUNTY_ID

COUNTY (Not really needed, may omit entirely)
- COUNTY_ID
- COUNTY_NAME
- STATE_ID