Re: Refining query statement

On Thu, 17 Jan 2019, David G. Johnston wrote:

> Yes...though now it just sounds like a flawed data model.

David,

This is what I thought.

> How stuck are you in that regard? Those "future" contacts should have their
> own records and not be derived via an optional field on an existing
> record.

My goal is to make a functioning business tracking application for my
consulting services. Almost all my prior postgres databases hold
environmental data for statistical and spatio-temporal analyses so writing a
business application is a new experience for me and I want to get it
correct.

> Put differently, how do you know which activities are completed and
> which are not?

The direct answer is that a completed activity has a row with either a
future next-activity date or a null (which is the case when the status of
that organization or contact is 'no further contact'.)

I should rename the Contacts table as People and the Activities table as
Contacts. The original names came from a sales management system I used as a
design guide, but they're probably confusing to others as well as to me. :-)

I can provide my current schema (eight tables) to the list (perhaps as an
attachment), an individual, or put in on a cloud site and pass the URL.

Thanks,

Rich