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	4					Primary key for JobCandidate records.
		EmployeeID	int	4					Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
		Resume	xml	-1					Résumé in XML format.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 4 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	JobCandidateID	1	1

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	1
	Name	dbo	User Defined type	1
	NameStyle	dbo	User Defined type	1
	Phone	dbo	User Defined type	1
	Contact	Person	Table	2
	Employee	HumanResources	Table	3

Total: 6 object(s)

Objects that depend on [HumanResources].[JobCandidate]

	Object Name	Owner	Object Type	Dep Level
	vJobCandidate	HumanResources	View	1
	vJobCandidateEducation	HumanResources	View	1
	vJobCandidateEmployment	HumanResources	View	1

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