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

Database Overview

Project Definitions Database

Users Database

Other Project Files

Other Databases

Relocating Databases to SQL Server