Difference between revisions of "HumanResources.JobCandidate (table)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| HumanResources.JobCandidate
 
| HumanResources.JobCandidate
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Résumés submitted to Human Resources by job applicants.
 
| Résumés submitted to Human Resources by job applicants.
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| JobCandidateID
 
| JobCandidateID
Line 52: Line 50:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_JobCandidate_JobCandidateID
 
| PK_JobCandidate_JobCandidateID
 
| JobCandidateID
 
| JobCandidateID
Line 63: Line 61:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| IX_JobCandidate_EmployeeID
 
| IX_JobCandidate_EmployeeID
 
|  
 
|  
Line 76: Line 74:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 
| EmployeeID
 
| EmployeeID
Line 90: Line 88:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Schema
 
| Schema
| [[HumanResources_(schema)|HumanResources]]
+
| [[HumanResources_(_(schema))|HumanResources]]
  
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| XML Schema Collection
 
| XML Schema Collection
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
+
| [[HumanResources.HRResumeSchemaCollection_(_(xml_schema_collection))|HumanResources.HRResumeSchemaCollection]]
  
 
|}
 
|}
Line 109: Line 107:
 
| '''Referencing Object
 
| '''Referencing Object
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
+
| [[HumanResources.vJobCandidate_(_(view))|HumanResources.vJobCandidate]]
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
+
| [[HumanResources.vJobCandidateEducation_(_(view))|HumanResources.vJobCandidateEducation]]
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
+
| [[HumanResources.vJobCandidateEmployment_(_(view))|HumanResources.vJobCandidateEmployment]]
  
 
|}
 
|}

Revision as of 23:00, 23 June 2010

wikibot

Table HumanResources.JobCandidate
Description Résumés submitted to Human Resources by job applicants.

Columns

Column Data Type Nullable Default Description
JobCandidateID int not null Primary key for JobCandidate records.
EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
Resume xml null Résumé in XML format.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key

Primary Key Columns
PK_JobCandidate_JobCandidateID JobCandidateID

Indexes

Index Type Columns
IX_JobCandidate_EmployeeID EmployeeID

Foreign Keys

Relation Column Referenced Column
HumanResources.Employee EmployeeID EmployeeID

References

Dependency Type Object Type Referenced Object
Schema Schema HumanResources
Data Type XML Schema Collection HumanResources.HRResumeSchemaCollection

Dependencies

Reference Type Object Type Referencing Object
Select View HumanResources.vJobCandidate
Select View HumanResources.vJobCandidateEducation
Select View HumanResources.vJobCandidateEmployment


automatically generated

Table HumanResources.JobCandidate
Description Résumés submitted to Human Resources by job applicants.


Column Data Type Nullable Default Description / PK / Index
JobCandidateID int not null Primary key for JobCandidate records.
PK_JobCandidate_JobCandidateID
EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
IX_JobCandidate_EmployeeID
Resume XML null Résumé in XML format.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
HumanResources.Employee EmployeeID EmployeeID


Dependency Type Object Type Referenced Object
Schema Schema HumanResources
Data Type XML Schema Collection HumanResources.HRResumeSchemaCollection


Reference Type Object Type Referencing Object
Select View HumanResources.vJobCandidate
Select View HumanResources.vJobCandidateEducation
Select View HumanResources.vJobCandidateEmployment