Code Coverage Schema
The following diagram shows the relationships between Coverage fact table and the related measures (dimensions) in the data warehouse.
.gif)
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). |