Employee


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EmployeeId int 4 null
Customer.SupportRepId FK_CustomerSupportRepId R
Employee.ReportsTo FK_EmployeeReportsTo R
LastName nvarchar 40 null
FirstName nvarchar 40 null
Title nvarchar 60 √ null
ReportsTo int 4 √ null
Employee.EmployeeId FK_EmployeeReportsTo R
BirthDate datetime 16,3 √ null
HireDate datetime 16,3 √ null
Address nvarchar 140 √ null
City nvarchar 80 √ null
State nvarchar 80 √ null
Country nvarchar 80 √ null
PostalCode nvarchar 20 √ null
Phone nvarchar 48 √ null
Fax nvarchar 48 √ null
Email nvarchar 120 √ null

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
PK_Employee Primary key Asc EmployeeId
IFK_EmployeeReportsTo Performance Asc ReportsTo

Relationships

Close relationships within degrees of separation