Home > Archive > PHP SQL > November 2004 > The ultimate address database ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
The ultimate address database ?
|
|
|
| I wanna make my own address database. One can store lots of information in
it (name, address, email-accounts, birthday, marriage, work, workaddress,
emails , phones, comment, .................).
If you store all in one table, there is a lot of empty fields.
Other solution : make a relational database and use different tables.
So you could take out the work-data (company name, phones, address, ...) and
store it in different table because you do not need to know where everybody
works
You could use separate table for countries and resp. international
phonecodes
You could also use different table with states of provinces for each country
etc ... etc ...
But it feels like i am reinventing the wheel. Is there a datamodel for an
address database ?
Looked on the internet but found no relevant links.
(used keywords like database address model addresses datamodel ...)
thanx,
Pugi!
| |
| Anders T. / DK! 2004-11-25, 3:56 pm |
| Hello Pugi!
The fact that you have re-discovered the relational DB seems to me as a good
solution: Depending on the information you want to store in the DB your
layout will vary - i.e. how many related tables for zip-code, country code
etc. But draw your own (maybe simple) ER-diagram before you start to
populate the DB. Then when you have the design ready create the tables with
the appropriate datatypes, constraints and references. Run a limited number
of record to test the functionality and make the nessecary adjustments
before you start to populate the DB. I think that you will find that aproach
much easier (and faster) and much more suitable for your "customized" adr.
DB than to find a standard datamodel you afterwards will have to alter until
it suits your needs.
How will you interface the DB?
Best regards
Anders T. / DK!
"Pugi!" <reply@togroup.be> wrote in message
news:41a5dd93$0$44064$5fc3050@dreader2.news.tiscali.nl...
> I wanna make my own address database. One can store lots of information in
> it (name, address, email-accounts, birthday, marriage, work, workaddress,
> emails , phones, comment, .................).
> If you store all in one table, there is a lot of empty fields.
> Other solution : make a relational database and use different tables.
> So you could take out the work-data (company name, phones, address, ...)
and
> store it in different table because you do not need to know where
everybody
> works
> You could use separate table for countries and resp. international
> phonecodes
> You could also use different table with states of provinces for each
country
> etc ... etc ...
> But it feels like i am reinventing the wheel. Is there a datamodel for an
> address database ?
> Looked on the internet but found no relevant links.
> (used keywords like database address model addresses datamodel ...)
>
> thanx,
>
> Pugi!
>
>
|
|
|
|
|