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.