[wplug-internet] Membership Database design

[Joe Prostko]

On Thu, Dec 18, 2014 at 11:59 PM, John Lewis <oflameo2 at gmail.com> wrote:
>
> I have a schema I designed in sqlite3 today. If you like it I can port
> it over to MariaDB.

Seeing as we're likely not going to be doing crazy stuff like multiple
table joins, we could probably get away with just having one table with all
of the various columns.  Also, I'm a bit rusty on SQLite, but it looks like
you're trying to use the email address as something like a primary key.  I
don't think that is the best idea ever, since email addresses change.

In MariaDB, we'd just use an autoindexing primary key, and go from there.

In any case, being a DBA is not at all my specialty (so I'm likely confused
about the details), but I'd rather keep things as simple as possible, even
if it means more columns in one table.  Then again, it's better to do
things right the first time, so it might make sense to keep separate tables
like you suggested, depending on the needs of different people.

I'm sure somebody with more knowledge will chime in to give comments.

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