Properties

Owner: HumanResources 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 128 
Index Size KB: 32 
Rows: 13 
Description: Résumés submitted to Human Resources by job applicants. 

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    JobCandidateID  int          Primary key for JobCandidate records. 
    EmployeeID  int          Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. 
    Resume  xml  -1          Résumé in XML format. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)

Identity column

Name Seed Increment Not for replication
  JobCandidateID   

Indexes

Index Primary Unique Description
  PK_JobCandidate_JobCandidateID      Primary key (clustered) constraint 
  IX_JobCandidate_EmployeeID      Nonclustered index. 
Total: 2 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  HumanResources.Employee  FK_JobCandidate_Employee_EmployeeID  PK_Employee_EmployeeID 
Total: 1 table(s)

Objects that [HumanResources].[JobCandidate] depends on

Object Name Owner Object Type Dep Level
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  NameStyle  dbo  User Defined type 
  Phone  dbo  User Defined type 
  Contact  Person  Table 
  Employee  HumanResources  Table 
Total: 6 object(s)

Objects that depend on [HumanResources].[JobCandidate]

Object Name Owner Object Type Dep Level
  vJobCandidate  HumanResources  View 
  vJobCandidateEducation  HumanResources  View 
  vJobCandidateEmployment  HumanResources  View 
Total: 3 object(s)

SQL

CREATE TABLE [JobCandidate] (
    [JobCandidateID] [int] IDENTITY (1, 1) NOT NULL ,
    [EmployeeID] [int] NULL ,
    [Resume] [xml] NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_JobCandidate_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_JobCandidate_JobCandidateID] PRIMARY KEY  CLUSTERED
    (
        [JobCandidateID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_JobCandidate_Employee_EmployeeID] FOREIGN KEY
    (
        [EmployeeID]
    ) REFERENCES [Employee] (
        [EmployeeID]
    )
) ON [PRIMARY]
GO


See Also

List of tables