Re: Question Submission Forms and the DB

[Micah Yoder <LYoder@cyberis.net>]

"Daniel E. Markle" wrote:

> Do we want submitors to be able to set the category, or do we want to leave
> that up to the answerers?

I'd say let them select the category.  The reviewer can edit it.

> Table: Articles; What to set on initial question submission:

From my understanding...  I suppose Jason better confirm this....

> ArticleID         Generated by DB or script?
DB handles it

> Title             User entered, verify that it isn't blank via script.
> ProblemDesc       User entered, verify that it isn't blank via script.
> StatusID          Needs to be set to "Submitted", which means it has not yet
>                   been answered.  After answering it is set to "Answered", then
>                   after editor verification it is set to "Completed".
Yep

> InceptTime        Is this set automagically by the DB or does it need done by
>                   the script?
> ModTime           Same question as InceptTime.

I *think* the DB handles these.  I read about them once, now I don't
remember for sure.

> For the rest I am assuming I should just leave them blank, however the
> following are set NOT NULL which is sure to cause hell:
> 
> ApplyYes/ApplyNo  What are these?  Didn't find a description anywhere, I'm sure
>                   I'll need to set them somewhere at some point.

Set them to zero.  They're the count of people who found them useful,
didn't find them useful.

> ApprovedBy        No way for question submission to handle this, unless we say
>                   noone or something, which really is just a waste of space.
>                   I think we should allow null here until the "Completed" stage.

You could set it to the empty string ("") but allowing NULL is probably
better.