| Column | Data Type | Nullable | Default | Description / PK / Index |
| JobCandidateID | int | not null | | Primary key for JobCandidate records.
PK_JobCandidate_JobCandidateID |
| EmployeeID | int | null | | Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
IX_JobCandidate_EmployeeID |
| Resume | xml | null | | Résumé in XML format.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|