| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimProductSubcategory |
| Friendly name |
Product Subcategory |
| Table name |
dbo_DimProductSubcategory |
| Table type |
Table |
| Is loaded |
|
| Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
| FK_DimProductSubcategory_DimProductCategory |
ProductCategoryKey |
DimProductCategory |
Table |
ProductCategoryKey |
Total: 1 parent relationship(s)
| Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
| FK_DimProduct_DimProductSubcategory |
ProductSubcategoryKey |
DimProduct |
Table |
ProductSubcategoryKey |
| DimProduct-DimProductSubcategory |
ProductSubcategoryAlternateKey |
DimProduct |
Table |
ProductSubcategoryKey |
Total: 2 child relationship(s)
| Name |
Type |
Computed column expression |
| ProductSubcategoryKey |
System.Int32 |
|
| ProductSubcategoryAlternateKey |
System.Int32 |
|
| EnglishProductSubcategoryName |
System.String |
|
| SpanishProductSubcategoryName |
System.String |
|
| FrenchProductSubcategoryName |
System.String |
|
| ProductCategoryKey |
System.Int32 |
|
Total: 6 column(s)