Jump to content

Spouse Relationship & Anniversary


Ocean West
 Share

This topic is 2374 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This is the database structure as I have it. 

Account ---< People 

There could be several people related to an account originally i had their anniversary date stored in each persons record however I have seen incomplete information or mismatched information, plus it required a duplicate entry on two records. 

So then I figured we only need ONE instance of this anniversary date so i could store that in the main account table, and also a flag if they wish to receive an anniversary card.

But now i need to link two individuals together so that I can derive the names to put on the card & envelope.

And also break the link when one of the individuals pass away so as not to send them an anniversary card posthumous. Or at least un-flag the record to send a card, the link and date could remain, as there are cases where I need to send documents to the surviving spouse and add the phrase "Estate of" for the deceased. 

I was thinking of just a text field in the account table that would contain a return separated list of the UUID for the people. But this could be harder to deal with if I need to do a n SQL statement with it. Or possibly a spouse_one & spouse_two field - not clean or ideal...

suggestions welcomed.

Link to comment
Share on other sites

This topic is 2374 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.