ScrewTurn Wiki

Edit

wikibot

TableHumanResources.JobCandidate
DescriptionRésumés submitted to Human Resources by job applicants.

Edit

Columns

ColumnData TypeNullableDefaultDescription
JobCandidateIDintnot null Primary key for JobCandidate records.
EmployeeIDintnull Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
Resumexmlnull Résumé in XML format.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_JobCandidate_JobCandidateIDJobCandidateID

Edit

Indexes

IndexTypeColumns
IX_JobCandidate_EmployeeID EmployeeID

Edit

Foreign Keys

RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaHumanResources
Data TypeXML Schema CollectionHumanResources.HRResumeSchemaCollection

Edit

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vJobCandidate
SelectViewHumanResources.vJobCandidateEducation
SelectViewHumanResources.vJobCandidateEmployment

Edit

automatically generated

TableHumanResources.JobCandidate
DescriptionRésumés submitted to Human Resources by job applicants.

ColumnData TypeNullableDefaultDescription / PK / Index
JobCandidateIDintnot null Primary key for JobCandidate records.
PK_JobCandidate_JobCandidateID
EmployeeIDintnull Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
IX_JobCandidate_EmployeeID
ResumeXMLnull Résumé in XML format.
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

Dependency TypeObject TypeReferenced Object
SchemaSchemaHumanResources
Data TypeXML Schema CollectionHumanResources.HRResumeSchemaCollection

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vJobCandidate
SelectViewHumanResources.vJobCandidateEducation
SelectViewHumanResources.vJobCandidateEmployment

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.