It should not be necessary to directly alter the underlying tables in jLogBook. However, for a systems administrator, it is useful to know how the tables are organized. Here is a brief description of the tables and the functions they support.
This is the main table where the logs are kept. You define
the individual columns of the table when you add or delete new
categories. Each category has a corresponding column associated
with it. Likewise, you define the format of each column whether
numeric or character in the category configuration
screen.
The diagram below shows the structure of the various configuration tables for jLog.
This is a single record table containing all the system configuration information. There is a column for each of the system parameters. For example, there are columns called APPLICATIONTITLE, etc.
This is the table that defines all the properties for each of the categories. There is a record for each category and a column for each property. For example, there are columns called CATEGORY, COLPOSITIONINTABLE, STORAGEFORMAT, DISPLAYINGRID, GRIDCOLUMNHEADING etc.
This is the table that stores all the options for each of the categories. For example, the options for the Priority category could be 1,2,3,4,5 representing the different priorities from emergency (1) to Log Only (5). The table also stores the format of the options and colors that represent these options. These options will be stored in the combo boxes in the Form on the main jLogBook screen. There is one record for every option and each option is linked back to a category in the CategoryConf table.
This is the table that stores all the information regarding the Users. There is a row for each user name. You use the User Configuration screen to set the values associated with these parameters. Each column represents a different property associated with a given user. For example, there are columns called USERNAME, PASSWORD, VIEWSCOPE, ADDABILITY, MODIFYABILITY and MODIFYRANGE etc.
This is where the Tool Tip information is held. For each parameter, there is a short tool tip message that is held in this table.