Issue Database
Microsoft Access
Issues are stored in the file <project>01.dat, where <project> is the name of the Vector HelpDesk project.
SQL Server
Issues are stored in the <project>01_Dat database, where <project> is the name of the Vector HelpDesk project. The database consists of:
<project>01_Dat.mdf
The master data file (MDF) of the database.
<project>01_Dat_log.LDF
Log file that holds the log information used to recover the database. There must be at least one log file for each database, although there can be more than one.
Tables
tblDts
Stores most of the information entered for an issue. This includes most of the fields on the Overview, Description, and Detail tabs, as well as the information entered on any custom tabs added to the project.
tblFixInformation
In previous releases of Vector HelpDesk, new fields added to the Resolution
tab were stored in tblFixInformation. The default fields are stored in
tblDts.
Any new fields added to the Resolution tab are stored in tblDts.
tblAttachments
Stores any files attached to an issue.
tblRevisionHistory
Stores the revision history for issues.
Related Topics