dbo.DimProductCategory
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | DimProductCategory |
| Module | Dimensions |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ProductCategoryKey | int | Identity | |||||
| Identity |
||||||||
| 2 | ProductCategoryAlternateKey | int | ||||||
| 3 | EnglishProductCategoryName | nvarchar(50) | ||||||
| 4 | SpanishProductCategoryName | nvarchar(50) | ||||||
| 5 | FrenchProductCategoryName | nvarchar(50) | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.DimProductSubcategory | dbo.DimProductCategory | dbo.DimProductSubcategory.ProductCategoryKey = dbo.DimProductCategory.ProductCategoryKey | FK_DimProductSubcategory_DimProductCategory | |
|
dbo.DimProductSubcategory.ProductCategoryKey = dbo.DimProductCategory.ProductCategoryKey Name: FK_DimProductSubcategory_DimProductCategory |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_DimProductCategory_ProductCategoryKey | ProductCategoryKey | ||
| AK_DimProductCategory_ProductCategoryAlternateKey | ProductCategoryAlternateKey |
Used by
| Name |
|---|
|
dbo.DimProductCategory
|
|
dbo.vDMPrep
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58