AdventureWorks

Basic Index   Expanded Index

Table Name:HumanResources.JobCandidate
Description:Résumés submitted to Human Resources by job applicants.
Primary Keys:JobCandidateID
FieldTypeDefaultsNulls?Comments
JobCandidateIDint - IdentityNoneNoPrimary key for JobCandidate records.
EmployeeIDintNoneYesEmployee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
ResumexmlNoneYesRésumé in XML format.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_JobCandidate_JobCandidateIDYesYesJobCandidateID
IX_JobCandidate_EmployeeIDNoNoEmployeeID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_JobCandidate_Employee_EmployeeIDEmployeeIDHumanResources.Employee

No primary keys as foreign key constraints
No triggers