[thesite] Voting Application - initial DB ideas

[Warden, Matt]

On Jan 31, isaac had something to say about RE: [thesite] Voting...

>> 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.

ok. i rather envisioned it like the article submission process. create,
preview, edit, preview, edit, etc., approve, then notification is sent.

in this process, the very last step would be "publish" or something and
the note would be sent off. of course, just like articles, they could be
edited after approval/publication.

>(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?)

pretty much. you probably want to avoid memo tho.


thanks,

--
mattwarden
mattwarden.com