HumanResources.JobCandidate Table

Information

NameJobCandidate
SchemaHumanResources
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
JobCandidateTABLEMS_DescriptionRésumés submitted to Human Resources by job applicants.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   JobCandidateIDint   
 
 
 
   EmployeeIDint  HumanResources.Employee.EmployeeID
 
 
 
   Resumexml   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_JobCandidate_JobCandidateIDClustered  JobCandidateID
IX_JobCandidate_EmployeeIDNonClustered  EmployeeID

Foreign Key Constraints

NameTypeReferenced Table
FK_JobCandidate_Employee_EmployeeIDForeign keyHumanResources.Employee

SQL Script

CREATE TABLE [HumanResources].[JobCandidate] (
    [JobCandidateID] int NOT NULL IDENTITY,
    [EmployeeID] int NULL,
    [Resume] xml NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_JobCandidate_EmployeeID] on [HumanResources].[JobCandidate]([EmployeeID]);