# Table: JobCandidate

## Properties

Property | Value
--- | ---
Name | JobCandidate
ID | 1333579789
Owner | dbo
Schema | HumanResources
Filegroup | PRIMARY
Data Size (KB) | 128 KB
Index Size (KB) | 144 KB
Rows | 13
Unused (KB) | 128 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space | PRIMARY
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:39 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Résumés submitted to Human Resources by job applicants.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | JobCandidateID | int |  |  |
2 | BusinessEntityID | int |  |  |
3 | Resume | xml |  |  |
4 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
JobCandidateID | 1 | 1 | 13 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_JobCandidate_JobCandidateID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
JobCandidateID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_JobCandidate_Employee_BusinessEntityID | HumanResources.Employee | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_JobCandidate_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_JobCandidate_JobCandidateID | CLUSTERED |  |  |  |  |
IX_JobCandidate_BusinessEntityID | NONCLUSTERED |  |  |  |  |

## FullText Indexes

Name | Corresponding Unique Index Name | Is Enabled | Change Tracking State Description
--- | --- | --- | ---
FullText Index | PK_JobCandidate_JobCandidateID |  | Auto

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_JobCandidate_JobCandidateID | Aug 8 2010 5:22PM | 13 | 13 | 7 | 1 | 4 |  |  | 13

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.07692308 | 4 | JobCandidateID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1
7 | 1 | 1 | 1 | 1
9 | 1 | 1 | 1 | 1
11 | 1 | 1 | 1 | 1
13 | 1 | 1 | 1 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
IX_JobCandidate_BusinessEntityID | Aug 8 2010 5:23PM | 13 | 13 | 3 | 0 | 4.615385 |  |  | 13

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.3333333 | 0.6153846 | BusinessEntityID
0.07692308 | 4.615385 | BusinessEntityID, JobCandidateID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
| 0 | 11 | 0 | 1
212 | 0 | 1 | 0 | 1
274 | 0 | 1 | 0 | 1

## Objects that depend on [JobCandidate]

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

## Objects on which [JobCandidate] depends

- HumanResources.JobCandidate
  - HumanResources.Employee
    - Person.Person
      - Demographics.exist
      - Person.IndividualSurveySchemaCollection
      - dbo.Name
      - dbo.NameStyle
      - Person.AdditionalContactInfoSchemaCollection
      - Person.BusinessEntity
    - dbo.Flag
  - HumanResources.HRResumeSchemaCollection

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [HumanResources].[JobCandidate]( [JobCandidateID] [int] IDENTITY(1,1) NOT NULL, [BusinessEntityID] [int] NULL, [Resume] [xml](CONTENT [HumanResources].[HRResumeSchemaCollection]) NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for JobCandidate records.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'JobCandidate', @level2type=N'COLUMN',@level2name=N'JobCandidateID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'JobCandidate', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Résumé in XML format.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'JobCandidate', @level2type=N'COLUMN',@level2name=N'Resume' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'JobCandidate', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Résumés submitted to Human Resources by job applicants.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'JobCandidate'

#### See also

List of Tables