Chapter 7: (Web hosting rating) Intranet System 205 Figure 7-1: Intranet
Chapter 7: Intranet System 205 Figure 7-1: Intranet system ER diagram. The users table is shown in the ER diagram to clarify the relationship. It actually does not belong in the INTRANET database but in the central user- authentication database called auth discussed in Chapter 5. Users who appear in the authdatabase in the users table have access to the intranet. Table 7-1 describes the details of each table in details. TABLE 7-1 INTRANET DATABASE TABLES Table Description MESSAGE Holds the message title (MSG_TITLE), message number (MSG_ID), message contents (MSG_CONTENTS), message date (MSG_DATE), message type (MSG_TYPE), flag (FLAG), and ID of the author who created the message (AUTHOR_ID). The message number (MSG_ID) is automatically generated by the database. MSG_TRACK Contains the message tracking information. It holds the user ID (USER_ID) of the user who received the message, the message number (MSG_ID), and the time stamp when the message is read by the viewer user (READ_TS). Continued