RE: in need of guidance ...

Walter:

How are mail stops different from, say, a box number.

As far as I can tell, 

	123 Penguin Place, MS87 

shouldn't be any different from 

	123 Penguin Place, Apt 87.

Mike

-----Original Message-----
From: phpWalter [mailto:[email protected]] 
Sent: Wednesday, October 11, 2006 6:43 PM
To: [email protected]
Subject: RE: in need of guidance ...


On Wed, October 11, 2006 4:47 pm, Michael McBride wrote:
> Walter:
>
>
> Since you're using an OpenSource package, you should have detailed
> information on their schema for user/contact data.

I have that.


> The first thing you need to do is figure out what, if anything, is wrong
> with, or missing from, the existing schema.  Then you can start figuring
> out what changes and/or additions you need to make to this schema so that
> it meets your requirements.

It's not so much "my" needs.

The exsiting schema, and most user based system for that matter, don't
handle:
 * multiple people at the same company address
 * single person with multiple adresses
 * no one handles "Mail Stops" properly

My "need" to revamp ythis has come from a few years of working wit various
OS apps and trying to integrate them, and requests for others in help
integrating packages.

With this in mind, I thought I'd re-design (with a lot of help from those
who know more than I do) how apps handle users, contacts and companies and
their personal data.

Thus my plea for assistance.

I have a data collection of:
 * all the counties and their codes
 * all the US states and their codes
 * all state counties and their codes
 * all major cites (and some with codes)
 * timezone details

I want to have this as a base set of data that all apps can utilize in a
common format.

Example: a user enters an address, the app know knows the proper county
and state codes (assuming US) and timezone and DST data automagically.

My concept is: is contact data is stored in central DB/table, than any OS
app can utilize it, with a set of contact APIs. This also allows other OS
apps to integrate easier to a companies contact data.

I "user" then becomes just a reference to a contact, complete with contact
data and company information.

Does this help clearify what I'm trying to do?

Thx

walter




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]