[wplug-internet] Membership Database design

Joe Prostko joe.prostko at gmail.com
Fri Dec 19 12:30:20 EST 2014


On Fri, Dec 19, 2014 at 12:24 PM, Pat Barron <pat at lectroid.com> wrote:
>
>  I do agree with keeping separate tables for people, and membership
details, in case any of the contact records don't actually have a
membership associated with them.

Well, then those membership fields would just have NULLs in them, and as
part of the query, results without that information would be skipped.  For
what we're doing, I don't think it really matters which way we go (I'm fine
with separate tables, even if it seems like I'm fighting against it), since
even doing some table joins will be very inexpensive, given that we'd only
have three tables to contend with.

- joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.wplug.org/pipermail/wplug-internet/attachments/20141219/778a76ae/attachment.html>


More information about the wplug-internet mailing list