Message System Database Design

The message system uses a number of relational tables to store pertinent information for the system, including information about the system users, information concerning the messages that have been posted, the text of the messages, any keywords applied to the messages, security information for the system, and message categories and message types. The design of the database is a relatively normalized relational structure with tables and descriptions, as detailed in Table 36-1.

These tables and their contents are explained in more detail in the following sections.

Table 36-1. Message System Database Tables
TableDescription
message_userContains information on the users of the system, including the user name and their ...

Get J2EE™ and Beyond: Design, Develop, and Deploy World-Class Java™ Software now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.