.png)
JobCandidate Table (AdventureWorks)
SQL Server 2005
Contains résumés submitted to the Human Resources department by job applicants.
The JobCandidate table is contained in the HumanResources schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
|
JobCandidateID |
int |
Not null |
Primary key for JobCandidate rows. |
|
EmployeeID |
int |
null |
Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. |
|
Resume |
xml |
null |
Résumé in XML format. For more information, see About the JobCandidate.Resume xml Column. |
|
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
