Code Coverage Schema

The following diagram shows the relationships between Coverage fact table and the related measures (dimensions) in the data warehouse.

The Code Coverage schema references two fact tables:

• Build Coverage fact table (dbo.Build Coverage)

• Run Coverage fact table (dbo. Run Coverage).

The Code Coverage schema also references seven dimension tables:

• Assembly dimension table (dbo.Assembly)

• Run dimension table (dbo.Run) (see Test Results Schema)

• Build dimension table (dbo.Build) (see Build Schema)

• Build Flavor dimension table (dbo.Build Flavor) (see Build Schema)

• Platform dimension table (dbo.Platform) (see Build Schema).

• Date (dbo.Date) (see Shared Dimensions)

• Team Project (dbo.Team project) (see Shared Dimensions)

Build Coverage Fact Table

The following table describes the columns in the Build Coverage fact table.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Lines Covered	Lines covered for the build/assembly combination.
Lines Not Covered	Lines not covered for the build/assembly combination.
Lines Partially Covered	Lines partially covered for the build/assembly combination.
Blocks Covered	Blocks covered for the build/assembly combination.
Blocks Not Covered	Blocks not covered for the build/assembly combination.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__TrackingId	Identifying number that is used by the warehouse infrastructure to track the record.
Build	Foreign key to the Build dimension table.
Assembly	Foreign key to the Assembly dimension table.
Date	Foreign key to the Date dimension table.
Platform	Foreign key to the Platform dimension table.
Flavor	Foreign key to the Build Flavor dimension table.
Team Project	Foreign key to the Team Project dimension table.

Run Coverage Fact Table

The following table describes the columns in the Run Coverage fact table and has the following fields:

Field	Description
__ID	Identifying number for the record the table (used internally).
Lines Covered	Lines covered for the Run/Assembly combination.
Lines Not Covered	Lines not covered for the Run/Assembly combination.
Lines Partially Covered	Lines partially covered for the Run/Assembly combination.
Blocks Covered	Blocks covered for the Run/Assembly combination.
Blocks Not Covered	Date and time the record was last inserted or updated.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__TrackingID	Identifying number that is used by the warehouse infrastructure to track the record.
Build	Foreign key to the Build dimension table.
Run	Foreign key to the Run dimension table.
Assembly	Foreign key to the Assembly dimension table.
Date	Foreign key to the Date dimension table.
Platform	Foreign key to the Platform dimension table.
Flavor	Foreign key to the Build Flavor dimension table.
Team Project	Foreign key to the Team Project dimension table.

Assembly Dimension Table

The following table describes the columns in the Assembly dimension table.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Assembly	The name of the assembly tested
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

See Also

Concepts

Code Coverage Perspective

Other Resources

Relational Schemas