Question Submission Forms and the DB

["Daniel E. Markle" <syntax@ashtech.net>]

In working on the question submission form, I ran into the following questions
that we will need to answer before I continue in my coding-

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

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

ArticleID         Generated by DB or script?
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".
InceptTime        Is this set automagically by the DB or does it need done by
                  the script?
ModTime           Same question as InceptTime.

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

-- 
-------------------
Daniel E. Markle
syntax@ashtech.net
-------------------