Database comments

[Matt]

Hello!

I noticed that Google code does have a way to leave comments on the
wiki page, but I think the mailing list might be better.

Users Table:
* Membership: it needs to be free form for us, this looks like it
is, but I wonder if there's a better way to handle the fixed
membership types. Maybe if it's text pull it from another table, if
it's a number it's free form? I think that it needs to always be in
terms of per month.
* balance: I don't think this is needed, it's just a calculation of
the transactions right?
* Maybe add another field, deactivated date

Transactions Table:
This looks good, maybe either index the type column off another
table or have the view suggest other types across all members so
that one can just click recently used or popular ones.

Another issue we have is that people pay for some months in advance.
I'd like to keep track of when it was donated, and which month the
donation is intended.

Sorry these comments were delayed,
#matt

[Joe Ferguson]

Yeah, those database fields are free form, or we could have them populated from a  default table on installation/configure. The balance column is so that people can see the running balance for that point in time, IE they have paid up for this month / they owe for this month / they show negative balance because they have paid for a month in advance. I intend to have the transaction date field editable that way you can post date transactions (ie paying for march dues in feb, etc).

--
- Joe Ferguson
http://www.midsouthmakers.org
Google Voice - (901) 451-9256