Northwind
| Table Name: | Employees |
| Primary Keys: | EmployeeID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| EmployeeID | int | None | No |
| LastName | nvarchar (20) | None | No |
| FirstName | nvarchar (10) | None | No |
| Title | nvarchar (30) | None | Yes |
| TitleOfCourtesy | nvarchar (25) | None | Yes |
| BirthDate | datetime | None | Yes |
| HireDate | datetime | None | Yes |
| Address | nvarchar (60) | None | Yes |
| City | nvarchar (15) | None | Yes |
| Region | nvarchar (15) | None | Yes |
| PostalCode | nvarchar (10) | None | Yes |
| Country | nvarchar (15) | None | Yes |
| HomePhone | nvarchar (24) | None | Yes |
| Extension | nvarchar (4) | None | Yes |
| Photo | image | None | Yes |
| Notes | ntext | None | Yes |
| ReportsTo | int | None | Yes |
| PhotoPath | nvarchar (255) | None | Yes |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Employees | Yes | Yes | EmployeeID |
| LastName | No | No | LastName |
| PostalCode | No | No | PostalCode |
| Check Constraint | Text |
|---|---|
| CK_Birthdate | ([BirthDate] < getdate()) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_Employees_Employees | ReportsTo | Employees |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Employees_Employees | Employees | ReportsTo |
| FK_EmployeeTerritories_Employees | EmployeeTerritories | EmployeeID |
| FK_Orders_Employees | Orders | EmployeeID |