HumanResources.JobCandidate

Table: 'HumanResources.JobCandidate'

4 fields. 24 bytes.

Resumes submitted to Human Resources by job applicants.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
JobCandidateID	int identity		int		Not null	Primary key for JobCandidate records.
EmployeeID	int				Null	Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
Resume	xml				Null	Resume in XML format.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.JobCandidate'

Primary Key Name	Field Name
PK_JobCandidate_JobCandidateID	JobCandidateID

Foreign keys for table 'HumanResources.JobCandidate', 1 item

Foreign	Primary	Key Name
JobCandidate.EmployeeID	Employee.EmployeeID	FK_JobCandidate_Employee_EmployeeID

Indexes for table 'HumanResources.JobCandidate', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_JobCandidate_JobCandidateID	Clustered index created by a primary key constraint.	Yes	Yes	JobCandidateID
IX_JobCandidate_EmployeeID	Nonclustered index.	No	No	EmployeeID

Triggers for table 'HumanResources.JobCandidate', 1 item

Name	Description	Type	Enabled
uJobCandidate	AFTER UPDATE trigger setting the ModifiedDate column in the JobCandidat table to the current date.	after Update	Yes

Dependencies for table 'HumanResources.JobCandidate', 4 items

Object Name	Type	Field Name
HumanResources.uJobCandidate	trigger	N/A
HumanResources.vJobCandidate	view	N/A
HumanResources.vJobCandidateEducation	view	N/A
HumanResources.vJobCandidateEmployment	view	N/A