Re: Refining query statement - Mailing list pgsql-general

From David G. Johnston
Subject Re: Refining query statement
Date
Msg-id CAKFQuwZ+hMNOrmQq2=pauj3P1v1YX29OEM_pvC0CUK5eX3pe6A@mail.gmail.com
Whole thread Raw
In response to Re: Refining query statement  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Refining query statement
List pgsql-general
On Thu, Jan 17, 2019 at 3:44 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
> FROM People AS p
>       JOIN Organizations AS o ON p.org_id = o.org_id
>       JOIN Contacts AS c ON c.person_id = p.person_id

I would advise changing Contacts to "Activities" as the former can
readily be interpreted (and is in the wild) as both "an instance of
contacting a person" and "the person at the organization who is being
contacted" (i.e., your People class).

David J.


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Refining query statement
Next
From: Rich Shepard
Date:
Subject: Re: Refining query statement