Implement a message board application that stores users and messages in a databa

Question

Implement a message board application that stores users and messages in a database. Users can post messages, reply to messages, and view posted messages. Provide views that list the messages by topic, by user, and by posting date. Allow the user to view all replies to a given message.

Explanation / Answer

$ mysql mboxgroup47 mysql> describe mail_item; +--------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+-------+ | mailbox_id | int(10) unsigned | NO | PRI | | | | id | int(10) unsigned | NO | PRI | | | | type | tinyint(4) | NO | | | | | parent_id | int(10) unsigned | YES | | NULL | | | folder_id | int(10) unsigned | YES | | NULL | | | index_id | int(10) unsigned | YES | | NULL | | | imap_id | int(10) unsigned | YES | | NULL | | | date | int(10) unsigned | NO | | | | | size | int(10) unsigned | NO | | | | | volume_id | tinyint(3) unsigned | YES | MUL | NULL | | | blob_digest | varchar(28) | YES | | NULL | | | unread | int(10) unsigned | YES | | NULL | | | flags | int(11) | NO | | 0 | | | tags | bigint(20) | NO | | 0 | | | sender | varchar(128) | YES | | NULL | | | subject | text | YES | | NULL | | | name | varchar(128) | YES | | NULL | | | metadata | text | YES | | NULL | | | mod_metadata | int(10) unsigned | NO | | | | | change_date | int(10) unsigned | YES | | NULL | | | mod_content | int(10) unsigned | NO | | | | +--------------+---------------------+------+-----+---------+-------+

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.