| Field Name | Type and Size |
|---|---|
| EmployeeID | int NOT NULL |
| Title | nvarchar(8) NULL |
| FirstName | Name NOT NULL |
| MiddleName | Name NULL |
| LastName | Name NOT NULL |
| Suffix | nvarchar(10) NULL |
| JobTitle | nvarchar(50) NOT NULL |
| Phone | Phone NULL |
| EmailAddress | nvarchar(50) NULL |
| EmailPromotion | int NOT NULL |
| AddressLine1 | nvarchar(60) NOT NULL |
| AddressLine2 | nvarchar(60) NULL |
| City | nvarchar(30) NOT NULL |
| StateProvinceName | Name NOT NULL |
| PostalCode | nvarchar(15) NOT NULL |
| CountryRegionName | Name NOT NULL |
| AdditionalContactInfo | xml NULL |