Re: Schema

Robert Mibus <mibus@bigpond.com> writes:

> Just to get the ball rolling, here's a starting point for a contact
> manager:
>
> id int primary key
> fn text
> ln text
> company text
> phone_mobile_home text
> phone_mobile_work text
> phone_home text
> phone_work text
> fax_home text
> fax_work text
> email_home text
> email_work text

As Derrell picks up the ball...

create table person (
  id int4 primary key,
  first_name varchar(32),
  last_name varchar(32),
  company varchar(64),
)

create table contact_types (
  contact_type_id int4 primary key,
  contact_type_name varchar(32) -- e.g. home phone, work email, etc.
)

create table contact (
  contact_id int4 primary key,
  person_id int4 not null references person,
  contact_type_id int4 not null references contact_types
)

Something along this line allows for multiple contacts, as many as required,
but only as many as required, without limiting the type of contact to the set
specified in the original posting.

And Derrell passes the ball...
Received on Wed Feb 13 15:21:34 2002