design

From: Jeff <jeff4e(at)rochester(dot)rr(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: design
Date: 2001-01-30 16:35:21
Message-ID: 3A76ED48.BA4A280B@rochester.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a design question. Lets say we want to keep track of users and
their respective snail mail addresses. Each user can have up to 4
different mailing address. Is it better to have all this information in
one table. Or is it better to have a user table and an address table,
and have the user id as a foreign key in the address table?

Thanks!

Jeff

Responses

  • Re: design at 2001-01-30 16:51:11 from Brett W. McCoy
  • Re: design at 2001-01-30 16:55:12 from KuroiNeko
  • Re: design at 2001-01-30 20:09:54 from Roderick A. Anderson
  • Re: design at 2001-01-30 23:31:36 from Lee Harr

Browse pgsql-general by date

  From Date Subject
Next Message Matthew 2001-01-30 16:39:56 RE: design
Previous Message os390 ibmos 2001-01-30 15:19:08 Re: LinuxWorld NYC