HumanResources.JobCandidate - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	JobCandidate
Module	Human Resources

Résumés submitted to Human Resources by job applicants.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		JobCandidateID	int		Identity		Primary key for JobCandidate records.
Primary key for JobCandidate records. Identity
	2		BusinessEntityID	int			HumanResources.Employee	Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.
Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID. References: HumanResources.Employee
	3		Resume	xml				Résumé in XML format.
Résumé in XML format.
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
HumanResources.JobCandidate		HumanResources.Employee	HumanResources.JobCandidate.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_JobCandidate_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.JobCandidate.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_JobCandidate_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.

Unique keys

	Key name	Columns	Description
	PK_JobCandidate_JobCandidateID	JobCandidateID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
HumanResources.JobCandidate
HumanResources.Employee

Used by

Name
HumanResources.JobCandidate
HumanResources.vJobCandidate
HumanResources.vJobCandidateEducation
HumanResources.vJobCandidateEmployment
dbo.uspSearchCandidateResumes

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56