This is for a recreational tree climbing database. When a climb is arranged,
it often begins with one or more inquiries by phone or email. Sometimes it
takes several communications to answer questions, set dates, etc.
At some point an inquiry gets definite enough to become a JobProposal, with
a specific type of climb, dates and fee set, etc. Usually JobProposals
become Climbs when the inquirer signs a contract, pays the deposit or fee,
shows up and participates in the climb. So JobProposal can be a FK in the
Climbs table.
It's actually more complicated because sometimes the tree climbing
organization initiates a climb or course, and often groups and organizations
and families are involved. But my primary problem right now is the
relationship between a JobProposal and all those earlier communications.
Tracking the communications is doable. But by the time it's clear that an
inquirer is serious about a JobProposal, several earlier communications have
often gone back and forth. How to link those after the fact, to the
JobProposal? I guess the only real link is the name of the inquirer. Earlier
I thought the specific service(s) mentioned in the earlier inquiries could
be a link, but often the first inquiries are quite vague. "Could our family
come next month to do a climb?" No climb type mentioned.
Maybe these early, vague communications (and their answers) should be
ignored? Or for any JobProposal, be able to call up a list of all the
communications back and forth (with dates and subjects and notes) linked to
the person or persons involved? (Usually there's one main contact person,
but sometimes two people communicate independently about the same job.)
Sorry if my problem seems unclear. Maybe your questions will help me clarify
the problem and get unstuck. TIA