Member Avatar for hghesteemed

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.

  • 2 Contributors
  • 4 Replies
  • 125 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by hghesteemed
Member Avatar for debasisdas

store all the members in a single table with a spouse column in it.

Member Avatar for hghesteemed

Should the spouse column be a key relating to the same table?

Member Avatar for debasisdas

Yes

the "spouse" column should store the "member_id" of the spouse.

Member Avatar for hghesteemed

Yes

the "spouse" column should store the "member_id" of the spouse.

Goody, thanks let me try that :-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.