AdventureWorks Database > HumanResources Schema : HumanResources.JobCandidate Table |
Creation Date | 08/01/2010 08:40 |
File Group | PRIMARY |
Text File Group | PRIMARY |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 13 |
Data Space Used | 128.00 KB |
Index Space Used | 32.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | JobCandidateID | Primary key for JobCandidate records. | int | 4 | |||
EmployeeID | Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. | int | 4 | ![]() | |||
Resume | Résumé in XML format. | HumanResources.HRResumeSchemaCollection | 16 | ![]() | |||
ModifiedDate | Date and time the record was last updated. | datetime | 4 | (getdate()) |
Index | Description | Primary | Unique |
---|---|---|---|
IX_JobCandidate_EmployeeID | Nonclustered index. | ||
PK_JobCandidate_JobCandidateID | Primary key (clustered) constraint | ![]() | ![]() |
Relationship | Description |
---|---|
FK_JobCandidate_Employee_EmployeeID | Foreign key constraint referencing Employee.EmployeeID. |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | HumanResources.vJobCandidate | View | Job candidate names and resumes. | 1 |
![]() | HumanResources.vJobCandidateEducation | View | Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. | 1 |
![]() | HumanResources.vJobCandidateEmployment | View | Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | Person.Contact | Table | Names of each employee, customer contact, and vendor contact. | 2 |
![]() | HumanResources.Employee | Table | Employee information such as salary, department, and title. | 1 |
![]() | dbo.Flag | User Defined Data Type | 2 | |
![]() | dbo.Name | User Defined Data Type | 3 | |
![]() | dbo.NameStyle | User Defined Data Type | 3 | |
![]() | dbo.Phone | User Defined Data Type | 3 |
|