Bridge Tables

Bridge tables are used when a multi-multi relationship exists. An example of such a relationship is the Task Owner field. In Digital.ai Agility, a Task can be owned by several owners (Members) and any one Member can own several Tasks. In the VersionOne datamart, all Bridge tables are in a database namespace (schema) known as "Bridge".

Multi-Multi Relationship Bridge Tables

Bridge.EpicOwner

Members can own multiple Epics and any Epic can be owned by multiple members. This relationship changes over time.

Table Description

Column Name	Description	Datatype	Foreign Key To
DateKey	Identifies the date this record is valid	int	Dim.Date
EpicKey	Identifies the Epic owned by a member	int	Dim.Epic
MemberKey	Identifies the Member owning the Epic	int	Dim.Member

Bridge.EpicStrategicTheme

Portfolio Item (Epics) can be related to multiple Strategic Themes.

Table Description

Column Name	Description	Datatype	Foreign Key To
EpicKey	Identifies the Epic	int	Dim.Epic
StrategicThemeKey	Identifies a Strategic Theme associated with the Epic	int	Dim.StrategicTheme

Bridge.MemberGroup

Members can be a part of many Member Groups.

Table Description

Column Name	Description	Data Type	Foreign Key To
MemberKey	Identifies the Member in a Member Group	int	Dim.Member
MemberGroupKey	Identifies the Member Group	int	Dim.MemberGroup

Bridge.PrimaryWorkitemRequest

Stories and Defects (PrimaryWorkitems) can be related to many Request.

Table Description

Column Name	Description	Datatype	Foreign Key To
PrimaryWorkitemKey	Identifies the Primary Workitem	int	Dim.PrimaryWorkitem
RequestKey	Identifies the Request	int	Dim.Request

Bridge.ProjectMember

Members are allowed to view many projects.

Table Description

Column Name	Description	Datatype	Foreign Key To
MemberKey	Identifies the Member that can observe this project	int	Dim.Member
ProjectKey	Identifies this project	int	Dim.Project

Bridge.ProjectProgram

Programs contain many projects.

Table Description

Column Name	Description	Datatype	Foreign Key To
ProjectKey	Identifies the Project assigned to the Program	int	Dim.Project
ProgramKey	Identifies the program	int	Dim.Program

Bridge.StoryDependsOnStory

Stories can depend on other Stories. As of the Fall 2014 release (14.3.x), this table has been deprecated and will be removed from a future release of the product. To create reports on dependencies, use the Bridge.PrimaryWorkitemDependencies table.

Table Description

Column Name	Description	Datatype	Foreign Key To
UpstreamStoryKey	Identifies the Story that must be completed first in a dependency relationship	int	Dim.PrimaryWorkitem
DownstreamStoryKey	Identifies the Story that is waiting for something else to complete	int	Dim.PrimaryWorkitem

Bridge.PrimaryWorkitemDependencies

This table contains 1 row for each Primary Workitem Dependencies defined in your core instance. This table was not available before the Fall 2014 release (14.3.x). For reporting on dependencies in Summer 2014 (14.2.x) and prior, you will need to use the Bridge.StoryDependsOnStory table.

Table Description

Column Name	Description	Datatype	Foreign Key To
UpstreamPrimaryWorkitemKey	Identifies the Primary Workitem that must be completed first in a dependency relationship	int	Dim.PrimaryWorkitem
DownstreamPrimaryWorkitemKey	Identifies the Primary Workitem that is waiting for something else to complete	int	Dim.PrimaryWorkitem

Bridge.Tags

Tagging is a lightweight, flexible way for different groups to organize data according to their needs. To create reports on Tags, or to use Tags in filters, use the Bridge.Tags table.

Table Description

Column Name	Description	Datatype
AssetKey	Identifies the Tagged Asset.	int
Value	Identifies the tag value	nvarchar(1000)

Technical Details

This table contain 1 row for each tag-able asset and each tag. Therefore, if a Story contains 3 tags, there are 3 rows in this table for that story, each row has one of the tag values.

This table is not historical. The Data Mart does not support reporting on historical tag values.

Tag List Views

Views exist to consolidate tag values to their asset. This can make reporting on Tags easier. The views are:

• Dim.EpicTagListView
• Dim.IssueTagListView
• Dim.PrimaryWorkitemTagListView
• Dim.RegressionTestTagListView
• Dim.RequestTagListView
• Dim.SecondaryWorkitemTagListView

Bridge.WorkitemOwner

Members can own multiple workitems and any workitem can be owned by multiple members. This relationship changes over time.

Table Description

Column Name	Description	Datatype	Foreign Key To
DateKey	Identifies the date this record is valid	int	Dim.Date
WorkitemKey	Identifies the workitem owned by a member	int	-
MemberKey	Identifies the Member owning the workitem	int	Dim.Member

Bridge.PrimaryWorkitemBrokenByDefect

This table contains 1 row for each Primary Workitem broken by a Defect in your core instance. This table was not available before the Fall 2015 release (15.3.x).

Table Description

Column Name	Description	Datatype	Foreign Key To
PrimaryWorkitemKey	Identifies the Primary Workitem that is Broken	int	Dim.PrimaryWorkitem
DefectKey	The Defect breaking the associated Primary Workitem	int	Dim.PrimaryWorkitem

Build Run Reporting Bridge Tables

Bridge.DefectFoundInBuildRun

When Defects are reported, the user can select which build contained the defect.

Table Description

Column Name	Description	Data Type	Foreign Key to
DefectKey	Identifies the Defect	int	Dim.PrimaryWorkitem
BuildRunKey	Identifies the BuildRun	int	Fact.BuildRun

Bridge.PrimaryWorkitemCompletedInBuildRun

When a PrimaryWorkitem is closed, the last associated BuildRun is the run where it was determined complete.

Table Description

Column Name	Description	Datatype	Foreign Key To
PrimaryWorkitemKey	Identifies the Primary Workitem	int	Dim.PrimaryWorkitem
DownstreamStoryKey	Identifies the Build Run	int	Fact.BuildRun

Goal Reporting Bridge Tables

Bridge.GoalTargetedByProject

When a Goal is targeting a project, the project has work that helps the organization achieve the goal.

Table Description

Column Name	Description	Datatype	Foreign Key To
GoalKey	Identifies the Goal	int	Dim.Goal
ProjectKey	Identifies this project	int	Dim.Project

Bridge.PrimaryWorkitemGoal

Primary Workitems can be related to many Goals and this relationship may change over time.

Table Description

Column Name	Description	Datatype	Foreign Key To
DateKey	Date this record is valid	int	Dim.Date
PrimaryWorkitemKey	Identifies the Primary Workitem assigned to the Goal	int	Dim.PrimaryWorkitem
GoalKey	Identifies the Goal	int	Dim.Goal

Issue Reporting Bridge Tables

Bridge.PrimaryWorkitemBlockedByIssue

Issues can block PrimaryWorkitems. This relationship changes over time.

Table Description

Column Name	Description	Datatype	Foreign Key To
DateKey	Identifies the date this record is valid	int	Dim.Date
PrimaryWorkitemKey	Identifies the blocked PrimaryWorkitem	int	Dim.PrimaryWorkitem
IssueKey	Identifies the Issue	int	Dim.Issue

Bridge.EpicBlockedByIssue

Issues can block Epics. This relationship changes over time.

Table Description

Column Name	Description	Datatype	Foreign Key To
DateKey	Identifies the date this record is valid	int	Dim.Date
EpicKey	Identifies the blocked Epic	int	Dim.Epic
IssueKey	Identifies the Issue	int	Dim.Issue

Bridge.PrimaryWorkitemResolvedIssue

PrimaryWorkitems can be created and used to resolved Issues.

Table Description

Column Name	Description	Datatype	Foreign Key To
PrimaryWorkitemKey	Identifies the blocked PrimaryWorkitem	int	Dim.PrimaryWorkitem
IssueKey	Identifies the Issue	int	Dim.Issue