Dim.BuildProject
Build Projects are a collection of Build Runs. This table contains Type 1 data for Build Project information.
Table Description
| Column Name | Description | Datatype |
|---|---|---|
| BuildProjectKey | Datamart unique identifier for the Build Project | int |
| BuildProjectOid | VersionOne identifier for this Build Project | int |
| BuildProjectName | Build Project Name | nvarchar |
| BuildProjectReference | Name of the Build Project as it's known in the CI Server | nvarchar |
| BuildProjectCreateDateUTC | UTC Date the Build Project was created | datetime |
| BuildProjectLastModifiedDateUTC | UTC Date the Build Project was last modified | datetime |
| BuildProjectCreateByKey | Foreign Key to Dim.Member for the person who created this build project | int |
| BuildProjectLastModifiedByKey | Foreign Key to Dim.Member for the person who last modified this build project | int |
| BuildProjectCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| BuildProjectLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |