AdventureWorks
| Table Name: | HumanResources.JobCandidate |
| Description: | Résumés submitted to Human Resources by job applicants. |
| Primary Keys: | JobCandidateID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| JobCandidateID | int - Identity | None | No | Primary key for JobCandidate records. |
| EmployeeID | int | None | Yes | Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. |
| Resume | xml | None | Yes | Résumé in XML format. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_JobCandidate_JobCandidateID | Yes | Yes | JobCandidateID |
| IX_JobCandidate_EmployeeID | No | No | EmployeeID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_JobCandidate_Employee_EmployeeID | EmployeeID | HumanResources.Employee |