Project History (ProjectHistory) table
The Project History (ProjectHistory) table is part of the mrInterviewData database. The table holds project history information (when the project was created, by whom, project status, and so on), and has the following structure:
CREATE TABLE [dbo].[ProjectHistory](
[Id] [int] IDENTITY(1,1) NOT NULL,
[CustomerAccountID] [uniqueidentifier] NULL,
[Name] [nvarchar](200) NOT NULL,
[Label] [nvarchar](200) NULL,
[Description] [nvarchar](4000) NULL,
[GroupName] [nvarchar](200) NULL,
[Status] [nvarchar](200) NULL,
[Owner] [nvarchar](255) NULL,
[DeletedOn] [datetime] NULL,
[DeletedBy] [nvarchar](2000) NULL,
CONSTRAINT [PK__ProjectHistory] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Columns
Id
The project's primary key in the Project Management table: see
Project Management table.
CustomerAccountId
The project's customer account ID.
Name
The project name.
Label
The project label.
Description
The project description.
GroupName
The project's group name.
Status
The project status.
Owner
The user who created the project.
DeletedOn
The DateTime when the user deleted the project.
DeletedBy
The user who deleted the project.
An error will occur when the value exceeds 2000 characters.
See also