O'Reilly logo

J2EE™ and Beyond: Design, Develop, and Deploy World-Class Java™ Software by Art Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required