Skip site navigation (1) Skip section navigation (2)

Data (Table) Structure Question

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Data (Table) Structure Question
Date: 2006-11-24 10:10:48
Message-ID: 852344.93082.qm@web33315.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
i hope everyone's thanksgiving was grand.

i have contacts, customers and employees that i want
to manage in a db application.

i can think of two ways to do this.

first, have a table for each and fill each with all
the relevant data:

1. t_custoemrs
2. t_employees
3. t_contacts

second, have a contacts table that records data that
is repeated throughout each table (ie, name, address,
phone, etc...)

i could then have a t_employees table with a foreign
key to the t_contacts table id.  this table would only
have employee related information and would link back
to contacts.

t_customers would do the same - list only customer
specific information.

i think the latter way is the way to go, but i'm not
sure.  i don't particularly like t_contacts as the
name of the general table.  maybe i need to name it
persons.

anyway, i'd value the input of some more experienced
developers.

tia,

oe1


 
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Responses

pgsql-novice by date

Next:From: Duncan GarlandDate: 2006-11-24 10:57:05
Subject: Re: Data (Table) Structure Question
Previous:From: Sean DavisDate: 2006-11-24 02:03:40
Subject: Re: How to execute a system command inside a SQL statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group