Create a project version table

ProductVersion.sql

-- Create new table for keeping track of all the versions of project files
CREATE TABLE wa.ProjectVersion(
	ProjectVersionId int IDENTITY(1,1) NOT NULL,
	ProjectId int NOT NULL,
	DateCreated datetime2(7) NOT NULL,
	ProjectFileId varchar(50) NOT NULL
PRIMARY KEY CLUSTERED 
(
	ProjectVersionId ASC
)
)
-- Create a FK on ProjectId from ProjectVersion to the Project 
ALTER TABLE wa.ProjectVersion
	WITH CHECK ADD CONSTRAINT FK_ProjectVersion_Project_ProjectId FOREIGN KEY(ProjectId)
		REFERENCES wa.Project(ProjectId)

-- Create a FK on LatestProjectVersionId from Project to the ProjectVersion
ALTER TABLE wa.Project
	ADD LatestProjectVersionId int NOT NULL

ALTER TABLE wa.Project
	WITH CHECK ADD CONSTRAINT FK_Project_LatestProjectVersionId_ProjectVersion_ProjectVersionId FOREIGN KEY(LatestProjectVersionId)
		REFERENCES wa.ProjectVersion (ProjectVersionId)