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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HumanResources.JobCandidate |- |} {| border="1" cellpadding="5" cellspacing=...)
 
Line 45: Line 45:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
| EmployeeID
 +
| EmployeeID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| HumanResources.JobCandidate
 +
|-
 +
 +
| '''Description
 +
| Résumés submitted to Human Resources by job applicants.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table HumanResources.JobCandidate


Column Data Type Nullable Default PK Index
JobCandidateID int not null PK_JobCandidate_JobCandidateID
EmployeeID int null IX_JobCandidate_EmployeeID
Resume xml null
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
HumanResources.Employee EmployeeID EmployeeID

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
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.JobCandidate_(table)&oldid=1097"