Person.ContactType Table

Description

Lookup table containing the types of contacts stored in Contact.

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	20
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ContactTypeID	Primary key for ContactType records.	int	4
Name	Contact type description.	dbo.Name	50
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_ContactType_Name	Unique nonclustered index.
PK_ContactType_ContactTypeID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_StoreContact_ContactType_ContactTypeID	Foreign key constraint referencing ContactType.ContactTypeID.
FK_VendorContact_ContactType_ContactTypeID	Foreign key constraint referencing ContactType.ContactTypeID.

Objects that depend on Person.ContactType

Database Object	Object Type	Description	Dep Level
Sales.StoreContact	Table	Cross-reference table mapping stores and their employees.	1
dbo.ufnGetContactInformation	User Defined Function	Table value function returning the first name, last name, job title and contact type for a given contact.	1
Purchasing.VendorContact	Table	Cross-reference table mapping vendors and their employees.	1
Sales.vStoreWithDemographics	View	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.	1
Purchasing.vVendor	View	Vendor (company) names and addresses and the names of vendor employees to contact.	1

Objects that Person.ContactType depends on

	Database Object	Object Type	Description	Dep Level
	dbo.Name	User Defined Data Type		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Person].[ContactType](
	[ContactTypeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ContactType_ContactTypeID] PRIMARY KEY CLUSTERED 
(
	[ContactTypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Person].[ContactType] ADD  CONSTRAINT [DF_ContactType_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Person Schema
AdventureWorks Database