Structure of the log files

The log files are MS Access databases. These databases contain four tables that contain both the event definitions and the event data.

Table Categories

Column Description of the
CatID Unique identifier of the category
Name Identifier of the category
TextID Numerical reference to a localizable text in the project file

Table Events

Column Description of the
Event Unique identifier of the log event within the category
CatID Reference to the CatID field in the Categories table as a reference to the category
Name Identifier of the log event
TextID Numerical reference to a localizable text in the project file

Logbook table

Column Description of the
ID Unique identifier of the data record (assigned automatically)
CatID Reference to the CatID field in the Categories table as a reference to the category
Event Reference to the Event field in the Events table as a reference to the log event definition
User Name of the user who was logged in when the event was triggered
Date Date/time of the log event
Text Text for the log event
TextID Numerical reference to a localizable text in the project file
HelpFile Optional name of a help file
HelpID Optional number of a help page (HelpContextID)
HasNotes Indication of whether notes are available for the log entry
SortBuffer

Notes table

Column Description of the
ID Unique identifier of the data record (assigned automatically)
ParentID Reference to the ID field in the LogBook table as a reference to a logged event
Date Date/time of the note
User Name of the logged in user
Grade Note information