Re: Critique needed for contact-DB draft

From: "Felix E(dot) Klee" <felix(dot)klee(at)inka(dot)de>
To: "Felix E(dot) Klee" <felix(dot)klee(at)inka(dot)de>
Cc: scrawford(at)pinpointresearch(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Critique needed for contact-DB draft
Date: 2004-07-15 18:24:12
Message-ID: 20040715202412.581898cb.felix.klee@inka.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I forgot to create a relation that reflects that a person/non-person is
an organization:

On Thu, 15 Jul 2004 16:25:54 +0200 Felix E. Klee wrote:
> "Major" tables:
> ORGANIZATIONS:
> contact_id, offers, demands, description, type (person|non-person),
> type_id (a person_id or a non-person_id)

contact_id should be substituted by organization_id.

> PERSONS:
> person_id, surname, given_names, pseudonyms, prefix, suffix, sex (M|F)

The field organization is missing.

> NON-PERSONS:
> non-person_id, name, type (company|non-profit|...)

The field organization is missing.

Felix

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2004-07-15 18:28:08 Re: Extended query: prepared statements list?
Previous Message Yves 2004-07-15 17:57:44 postgres account default password