HumanResources.JobCandidate

Columns

• //

  ${escapify(column.description)}
  JobCandidateID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NULL
• //

  ${escapify(column.description)}
  Resume
  [xml] NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_JobCandidate_JobCandidateID
  UNIQUE CLUSTERED
  JobCandidateID
• //

  Nonclustered index.
  IX_JobCandidate_BusinessEntityID
  NONCLUSTERED
  BusinessEntityID

Foreign Keys

• //

  Foreign key constraint referencing Employee.EmployeeID.
  FK_JobCandidate_Employee_BusinessEntityID
  HumanResources.Employee
  BusinessEntityID ⥱ BusinessEntityID

Sample Data