Project Management table

Interviewer - Server > Administration and maintenance > Databases > Project Management table

The Project Management (ProjectMgmt) table is part of the mrInterviewData database and has the following structure:

CREATE TABLE ProjectMgmt (
  Id      integer        IDENTITY (1,1) NOT NULL,
  Name    nvarchar(128) NOT NULL,
  Value   image          NULL DEFAULT (null),
  Parent integer        NULL
)

Columns

Stores the unique identifier of each record in the table.

Name

The project name or the name of a property variable.

Value

The property value stored in binary format.

Parent

The identifier of the record to which the current record belongs. All property records show the identifier of the project name record to which they belong. For example, all properties for the Holidays project show the identifier of the HOLS project record in this column.