So far as I see it, these are the columns we'll require in the following tables:
NEWS:
article_id (INT, probably 7 or 8)
article_summary (text)
article_body (long text, 32K characters)
article_URL (text ... may not be necessary?)
article_submission (timestamp-ish)
article_updated_date (timestamp-ish)
article_submitted_by (foreign key to a "users" db? maybe just a text column?)
FORUM:
post_id (int, larger is better [9? 10? bigger?])
post_summary (maybe the first 32 characters? or, this might be better as post_subject)
post_body (long text)
post_submission (timestamp-ish)
post_updated (timestamp-ish)
post_hidden (for admins to turn off viewing? Boolean-ish)
post_submitted_by (same as NEWS table, above; might be a foreign key to a USERS table, or might be just a text column)
POLL:
poll_id (int, 6-7)
poll_subject (short text, 255 or smaller)
poll_options (might be better if we have a separate table for options [selectable items in the poll], and haev a foreign key in that table back to this one)
poll_submitted (timestamp-ish)
poll_updated (timestamp-ish)
poll_ends (timestamp-ish)
poll_submitted_by (as above two tables!)
Maybe I'm way off base :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
blah. It's obviously been a while since I've looked at this project :) The db table structure is already in place! I'll refrain from posting any more until I catch back up on the project's actual status :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So far as I see it, these are the columns we'll require in the following tables:
NEWS:
article_id (INT, probably 7 or 8)
article_summary (text)
article_body (long text, 32K characters)
article_URL (text ... may not be necessary?)
article_submission (timestamp-ish)
article_updated_date (timestamp-ish)
article_submitted_by (foreign key to a "users" db? maybe just a text column?)
FORUM:
post_id (int, larger is better [9? 10? bigger?])
post_summary (maybe the first 32 characters? or, this might be better as post_subject)
post_body (long text)
post_submission (timestamp-ish)
post_updated (timestamp-ish)
post_hidden (for admins to turn off viewing? Boolean-ish)
post_submitted_by (same as NEWS table, above; might be a foreign key to a USERS table, or might be just a text column)
POLL:
poll_id (int, 6-7)
poll_subject (short text, 255 or smaller)
poll_options (might be better if we have a separate table for options [selectable items in the poll], and haev a foreign key in that table back to this one)
poll_submitted (timestamp-ish)
poll_updated (timestamp-ish)
poll_ends (timestamp-ish)
poll_submitted_by (as above two tables!)
Maybe I'm way off base :)
blah. It's obviously been a while since I've looked at this project :) The db table structure is already in place! I'll refrain from posting any more until I catch back up on the project's actual status :)