Sales.StoreContact Table

Description

Cross-reference table mapping stores and their employees.

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	753
Data Space Used	40.00 KB
Index Space Used	120.00 KB

Columns

Column Name	Description	Datatype	Length	Default
CustomerID	Store identification number. Foreign key to Customer.CustomerID.	int	4
ContactID	Contact (store employee) identification number. Foreign key to Contact.ContactID.	int	4
ContactTypeID	Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.	int	4
rowguid	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	uniqueidentifier	16	(newid())
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_StoreContact_rowguid	Unique nonclustered index. Used to support replication samples.
IX_StoreContact_ContactID	Nonclustered index.
IX_StoreContact_ContactTypeID	Nonclustered index.
PK_StoreContact_CustomerID_ContactID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_StoreContact_Contact_ContactID	Foreign key constraint referencing Contact.ContactID.
FK_StoreContact_ContactType_ContactTypeID	Foreign key constraint referencing ContactType.ContactTypeID.
FK_StoreContact_Store_CustomerID	Foreign key constraint referencing Store.CustomerID.

Objects that depend on Sales.StoreContact

	Database Object	Object Type	Description	Dep Level
	dbo.ufnGetContactInformation	User Defined Function	Table value function returning the first name, last name, job title and contact type for a given contact.	1
	Sales.vStoreWithDemographics	View	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.	1

Objects that Sales.StoreContact depends on

Database Object	Object Type	Description	Dep Level
Person.Contact	Table	Names of each employee, customer contact, and vendor contact.	1
Person.ContactType	Table	Lookup table containing the types of contacts stored in Contact.	1
Sales.Customer	Table	Current customer information. Also see the Individual and Store tables.	2
HumanResources.Employee	Table	Employee information such as salary, department, and title.	3
dbo.ErrorLog	Table	Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.	3
dbo.Flag	User Defined Data Type		4
Sales.Individual	Table	Demographic data about customers that purchase Adventure Works products online.	2
dbo.Name	User Defined Data Type		2
dbo.NameStyle	User Defined Data Type		2
dbo.Phone	User Defined Data Type		2
Sales.SalesPerson	Table	Sales representative current information.	2
Sales.SalesTerritory	Table	Sales territory lookup table.	3
Sales.Store	Table	Customers (resellers) of Adventure Works products.	1
dbo.ufnLeadingZeros	User Defined Function	Scalar function used by the Sales.Customer table to help set the account number.	3
dbo.uspLogError	Stored Procedure	Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.	2
dbo.uspPrintError	Stored Procedure	Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.	2

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[StoreContact](
	[CustomerID] [int] NOT NULL,
	[ContactID] [int] NOT NULL,
	[ContactTypeID] [int] NOT NULL,
	[rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_StoreContact_CustomerID_ContactID] PRIMARY KEY CLUSTERED 
(
	[CustomerID] ASC,
	[ContactID] 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 [Sales].[StoreContact]  WITH CHECK ADD  CONSTRAINT [FK_StoreContact_Contact_ContactID] FOREIGN KEY([ContactID])
REFERENCES [Contact] ([ContactID])
ALTER TABLE [Sales].[StoreContact] CHECK CONSTRAINT [FK_StoreContact_Contact_ContactID]
ALTER TABLE [Sales].[StoreContact]  WITH CHECK ADD  CONSTRAINT [FK_StoreContact_ContactType_ContactTypeID] FOREIGN KEY([ContactTypeID])
REFERENCES [ContactType] ([ContactTypeID])
ALTER TABLE [Sales].[StoreContact] CHECK CONSTRAINT [FK_StoreContact_ContactType_ContactTypeID]
ALTER TABLE [Sales].[StoreContact]  WITH CHECK ADD  CONSTRAINT [FK_StoreContact_Store_CustomerID] FOREIGN KEY([CustomerID])
REFERENCES [Store] ([CustomerID])
ALTER TABLE [Sales].[StoreContact] CHECK CONSTRAINT [FK_StoreContact_Store_CustomerID]
ALTER TABLE [Sales].[StoreContact] ADD  CONSTRAINT [DF_StoreContact_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Sales].[StoreContact] ADD  CONSTRAINT [DF_StoreContact_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Sales Schema
AdventureWorks Database