| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimSalesTerritory |
| Friendly name |
Sales Territory |
| Table name |
dbo_DimSalesTerritory |
| Table type |
Table |
| Is loaded |
|
| Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
| FK_FactResellerSales_DimSalesTerritory |
SalesTerritoryKey |
FactResellerSales |
Table |
SalesTerritoryKey |
| FK_FactInternetSales_DimSalesTerritory |
SalesTerritoryKey |
FactInternetSales |
Table |
SalesTerritoryKey |
| FK_DimGeography_DimSalesTerritory |
SalesTerritoryKey |
DimGeography |
Table |
SalesTerritoryKey |
| FK_DimEmployee_DimSalesTerritory |
SalesTerritoryKey |
DimEmployee |
Table |
SalesTerritoryKey |
| FactSalesSummary-DimSalesTerritory |
SalesTerritoryKey |
Sales Summary Facts |
View |
SalesTerritoryKey |
Total: 5 child relationship(s)
| Name |
Type |
Computed column expression |
| SalesTerritoryKey |
System.Int32 |
|
| SalesTerritoryAlternateKey |
System.Int32 |
|
| SalesTerritoryRegion |
System.String |
|
| SalesTerritoryCountry |
System.String |
|
| SalesTerritoryGroup |
System.String |
|
| SalesTerritoryImage |
System.Byte[] |
|
Total: 6 column(s)