Project Definitions Database

Database

Microsoft Access

The project definitions database is named <project>02.def, where <project> is the name of the Vector HelpDesk project.

SQL Server  

The project definitions database is named <project>02_DEF, and consists of these files:

    <project>02_DEF.mdf

    <project>02_DEF_log.LDF

Tables

tblDtsFields

Defines the fields available in a Vector HelpDesk project. The Field Editor in HelpDesk Admin provides a user interface for editing most of the columns in this table.

In tblDtsFields, the tWhere column specifies a Where clause that controls the contents of a choice list. The HelpDesk project uses the Where clause to build the Contact, Owner, and Submitter choice lists.

For example, this Where clause removes macros (such as <User>) and contacts from the Owner list:

Where (([nID] >= 0 And [tName] <> '')Or
[tName] = '<User>') And fOriginator = 0

    The [nID] >= 0 condition removes the macros defined in tblUser:

User ID

User Name

-4

<Contact>

-3

<User>

-2

<Previous Owner>

-1

<Owner>

The user with nID = 0 is the <None> macro.

    The fOriginator = 0 condition removes contacts, so that the list contains users only.

    tName is the name of the user.

tblState

Specifies the list of choices for the State field. The State field is a read-only field that is set based on the Progress field.

tblSubState

Specifies the list of choices for the Progress field. Each possible substate corresponds to a possible State value (Open or Closed).

Choice List Tables

A choice table specifies the possible values for a choice list field. Each row in a choice table includes an nID, a tName (the choice text), and optionally, an nChoiceID (for non-alphabetical choice lists).

In the issue database, multi-choice fields store a semi-colon separated list of the tName values (the choice text strings), not the nID values.

Related Topics

Database Overview

Issue Database

Users Database

Other Project Files

Other Databases

Relocating Databases to SQL Server