Hi,
I'm designing a schema to store church records and have hit a snag trying to figure out the kind of relationship between a church member and their spouse if the spouse is also a church member.
Here's my scenario:
A church member can have only one spouse, the spouse can also be a church member. It seems like both records must exist in the member table. But how do I relate them? If I store spouses in another table my schema would support polygamy. Any ideas?
Thanks in advance.
Jump to Poststore all the members in a single table with a spouse column in it.
store all the members in a single table with a spouse column in it.
Should the spouse column be a key relating to the same table?
Yes
the "spouse" column should store the "member_id" of the spouse.
Yes
the "spouse" column should store the "member_id" of the spouse.
Goody, thanks let me try that :-)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.