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 null
HireDate datetime 16 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