Newsgroups

Functionality

SQL

In donut.sql newsgroup_posts

Column	Type	Comments
newsgroup_post_id	INT	PK
group_id	INT	References groups.group_id
subject	TEXT	email subject
message	TEXT	email message
post_as	VARCHAR(32)	email from: <group name> <position name> (<user's full name>)
user_id	INT	References members.user_id
time_sent	TIMESTAMP