[thesite] Voting Application - initial DB ideas

[isaac]

> add questiontype
> values: "vote", "appeal", "revote"

good idea.

> the announced flag most likely isn't necessary unless you're planning on
> running the announcement by some cron job or something.

actually, i figure that actually putting together the question/options will
often be a gradual process (i.e., stemming from discussion on
thesite/theforum for the most part). consider the "announced" flag to be the
equivalent of "taken" for the admin email thingy. i.e., stops someone else
coming in to announce it again.

> >id, optionid, userid, timestamp
> optionid nullable for abstaining?

yeh, probably. saves having an extra default "abstain" option for every
question.

> >i.e., once a question has been proposed, you Announce it (hence announced
> >flag). Then maybe 36 hours later, as a courtesy (not required,
> just if you
> >remember, or if people are forgetting to vote), you Notify,
> which privately
> >emails all registered voters who are yet to vote on the issue, with a
> >reminder of closing time, etc.
>
> you can do this with a cf script and the fields above.

yes, exactly.


i

(as for the user/member role-based crap, rudy? ditto with all the
numeric/varchar/text/memo/type stuff. are their direct equiv's between
access and mysql?)