Re: Critique needed for contact-DB draft - Mailing list 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