Search Postgresql Archives

Re: Refining query statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jan 17, 2019 at 3:44 PM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux