dbo.DimDepartmentGroup
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | DimDepartmentGroup |
| Module | Dimensions |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | DepartmentGroupKey | int | Identity | |||||
| Identity |
||||||||
| 2 | ParentDepartmentGroupKey | int | dbo.DimDepartmentGroup | |||||
| References: dbo.DimDepartmentGroup | ||||||||
| 3 | DepartmentGroupName | nvarchar(50) | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.DimDepartmentGroup | dbo.DimDepartmentGroup | dbo.DimDepartmentGroup.ParentDepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey | FK_DimDepartmentGroup_DimDepartmentGroup | |
|
dbo.DimDepartmentGroup.ParentDepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey Name: FK_DimDepartmentGroup_DimDepartmentGroup |
||||
| dbo.DimDepartmentGroup | dbo.DimDepartmentGroup | dbo.DimDepartmentGroup.ParentDepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey | FK_DimDepartmentGroup_DimDepartmentGroup | |
|
dbo.DimDepartmentGroup.ParentDepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey Name: FK_DimDepartmentGroup_DimDepartmentGroup |
||||
| dbo.FactFinance | dbo.DimDepartmentGroup | dbo.FactFinance.DepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey | FK_FactFinance_DimDepartmentGroup | |
|
dbo.FactFinance.DepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey Name: FK_FactFinance_DimDepartmentGroup |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_DimDepartmentGroup | DepartmentGroupKey |
Uses
| Name |
|---|
|
dbo.DimDepartmentGroup
|
|
dbo.DimDepartmentGroup
|
Used by
| Name |
|---|
|
dbo.DimDepartmentGroup
|
|
dbo.DimDepartmentGroup
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58