dbo.DimEmployee - AdventureWorksDW

Columns

		Name	Data type	Attributes	References
	1	EmployeeKey	int	Identity
Identity
	2	ParentEmployeeKey	int		dbo.DimEmployee
References: dbo.DimEmployee
	3	EmployeeNationalIDAlternateKey	nvarchar(15)
	4	ParentEmployeeNationalIDAlternateKey	nvarchar(15)
	5	SalesTerritoryKey	int		dbo.DimSalesTerritory
References: dbo.DimSalesTerritory
	6	FirstName	nvarchar(50)
	7	LastName	nvarchar(50)
	8	MiddleName	nvarchar(50)
	9	NameStyle	bit
	10	Title	nvarchar(50)
	11	HireDate	date
	12	BirthDate	date
	13	LoginID	nvarchar(256)
	14	EmailAddress	nvarchar(50)
	15	Phone	nvarchar(25)
	16	MaritalStatus	nchar(1)
	17	EmergencyContactName	nvarchar(50)
	18	EmergencyContactPhone	nvarchar(25)
	19	SalariedFlag	bit
	20	Gender	nchar(1)
	21	PayFrequency	tinyint
	22	BaseRate	money
	23	VacationHours	smallint
	24	SickLeaveHours	smallint
	25	CurrentFlag	bit
	26	SalesPersonFlag	bit
	27	DepartmentName	nvarchar(50)
	28	StartDate	date
	29	EndDate	date
	30	Status	nvarchar(50)
	31	EmployeePhoto	varbinary(MAX)

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.DimEmployee	dbo.DimEmployee	dbo.DimEmployee.ParentEmployeeKey = dbo.DimEmployee.EmployeeKey	FK_DimEmployee_DimEmployee
dbo.DimEmployee.ParentEmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_DimEmployee_DimEmployee
dbo.DimEmployee	dbo.DimSalesTerritory	dbo.DimEmployee.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_DimEmployee_DimSalesTerritory
dbo.DimEmployee.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_DimEmployee_DimSalesTerritory
dbo.DimEmployee	dbo.DimEmployee	dbo.DimEmployee.ParentEmployeeKey = dbo.DimEmployee.EmployeeKey	FK_DimEmployee_DimEmployee
dbo.DimEmployee.ParentEmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_DimEmployee_DimEmployee
dbo.FactResellerSales	dbo.DimEmployee	dbo.FactResellerSales.EmployeeKey = dbo.DimEmployee.EmployeeKey	FK_FactResellerSales_DimEmployee
dbo.FactResellerSales.EmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_FactResellerSales_DimEmployee
dbo.FactSalesQuota	dbo.DimEmployee	dbo.FactSalesQuota.EmployeeKey = dbo.DimEmployee.EmployeeKey	FK_FactSalesQuota_DimEmployee
dbo.FactSalesQuota.EmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_FactSalesQuota_DimEmployee

Unique keys

	Key name	Columns	Description
	PK_DimEmployee_EmployeeKey	EmployeeKey

Uses

Used by

Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58