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

From dbscript Online Help
Jump to: navigation, search
 
(10 intermediate revisions by the same user not shown)
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
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Résumés submitted to Human Resources by job applicants.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| JobCandidateID
 
| JobCandidateID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_JobCandidate_JobCandidateID
+
| Primary key for JobCandidate records.
−
|
+
|- valign="top"
−
|-
 
 
| EmployeeID
 
| EmployeeID
 
| int
 
| int
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
−
| IX_JobCandidate_EmployeeID
+
|- valign="top"
−
|-
 
 
| Resume
 
| Resume
 
| xml
 
| xml
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Résumé in XML format.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_JobCandidate_JobCandidateID
 +
| JobCandidateID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| IX_JobCandidate_EmployeeID
 +
|
 +
| EmployeeID
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 74:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 
| EmployeeID
 
| EmployeeID
 
| EmployeeID
 
| EmployeeID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|- valign="top"
 +
| Data Type
 +
| XML Schema Collection
 +
| [[HumanResources.HRResumeSchemaCollection_(xml schema collection)|HumanResources.HRResumeSchemaCollection]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 67: Line 131:
 
| '''Table
 
| '''Table
 
| HumanResources.JobCandidate
 
| HumanResources.JobCandidate
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Résumés submitted to Human Resources by job applicants.
 
| Résumés submitted to Human Resources by job applicants.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 89: Line 151:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for JobCandidate records.PK_JobCandidate_JobCandidateID
+
| Primary key for JobCandidate records.<br />PK_JobCandidate_JobCandidateID
 
|- valign="top"
 
|- valign="top"
 
| EmployeeID
 
| EmployeeID
Line 95: Line 157:
 
| null
 
| null
 
|  
 
|  
−
| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.IX_JobCandidate_EmployeeID
+
| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.<br />IX_JobCandidate_EmployeeID
 
|- valign="top"
 
|- valign="top"
 
| Resume
 
| Resume
Line 101: Line 163:
 
| null
 
| null
 
|  
 
|  
−
| Résumé in XML format.
+
| Résumé in XML format.<br />
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 107: Line 169:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 127: Line 189:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
+
|-
−
+
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 
 
|-
 
|-
 +
| Data Type
 +
| XML Schema Collection
 
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
 
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
−
| XML Schema Collection
+
 
−
| Data Type
 
 
|}
 
|}
  
Line 140: Line 208:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
+
 
−
| '''Reference Type
 
−
 
 
|-
 
|-
 +
| Select
 +
| View
 
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 +
 +
|-
 +
| Select
 
| View
 
| View
 +
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 +
 +
|-
 
| Select
 
| Select
−
|-
 
−
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 
 
| View
 
| View
−
| Select
 
−
|-
 
 
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
−
| View
+
 
−
| Select
 
 
|}
 
|}

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
PK_JobCandidate_JobCandidateID JobCandidateID

Indexes[edit]

Index Type Columns
IX_JobCandidate_EmployeeID EmployeeID

Foreign Keys[edit]

Relation Column Referenced Column
HumanResources.Employee EmployeeID EmployeeID

References[edit]

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

Dependencies[edit]

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


automatically generated[edit]

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