Employee
| Field Name | Data Type | Description |
|---|---|---|
| EmployeeID | AutoNumber | Primary Key |
| FirstName | Text | First Name |
| MiddleInitial | Text | Middle Initial |
| LastName | Text | Last Name |
| SocialSecurity | Text | Social Security # |
| Address1 | Text | Address Line 1 |
| Address2 | Text | Address Line 2 |
| City | Text | City |
| State | Text | State |
| ZipCode | Text | Zip Code |
| HomePhone | Text | Home Phone # |
| WorkExtension | Text | Work Phone Extension |
| Text | Email Address | |
| DepartmentID | Number | Department Table Foreign Key |
| EmployeeClassID | Number | EmployeeClass Table FK |
Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
