Sales.StoreContact

Field Name Data Type Size Original Type Default Nullable Description Check

CustomerID int Not null Store identification number. Foreign key to Customer.CustomerID.

ContactID int Not null Contact (store employee) identification number. Foreign key to Contact.ContactID.

ContactTypeID int Not null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

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

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.StoreContact'

Primary Key Name Field Names

PK_StoreContact_CustomerID_ContactID CustomerID, ContactID

Primary Key Name	Field Names
PK_StoreContact_CustomerID_ContactID	CustomerID, ContactID

Foreign keys for table 'Sales.StoreContact', 3 items

Foreign Primary Key Name

StoreContact.ContactID Contact.ContactID FK_StoreContact_Contact_ContactID

StoreContact.ContactTypeID ContactType.ContactTypeID FK_StoreContact_ContactType_ContactTypeID

StoreContact.CustomerID Store.CustomerID FK_StoreContact_Store_CustomerID

Foreign	Primary	Key Name
StoreContact.ContactID	Contact.ContactID	FK_StoreContact_Contact_ContactID
StoreContact.ContactTypeID	ContactType.ContactTypeID	FK_StoreContact_ContactType_ContactTypeID
StoreContact.CustomerID	Store.CustomerID	FK_StoreContact_Store_CustomerID

Indexes for table 'Sales.StoreContact', 4 items

Index Name Description Clustered Unique Fields

PK_StoreContact_CustomerID_ContactID Clustered index created by a primary key constraint. Yes Yes CustomerID, ContactID

AK_StoreContact_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

IX_StoreContact_ContactID Nonclustered index. No No ContactID

IX_StoreContact_ContactTypeID Nonclustered index. No No ContactTypeID

Index Name	Description	Clustered	Unique	Fields
PK_StoreContact_CustomerID_ContactID	Clustered index created by a primary key constraint.	Yes	Yes	CustomerID, ContactID
AK_StoreContact_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
IX_StoreContact_ContactID	Nonclustered index.	No	No	ContactID
IX_StoreContact_ContactTypeID	Nonclustered index.	No	No	ContactTypeID

Triggers for table 'Sales.StoreContact', 1 item

Name Description Type Enabled

uStoreContact AFTER UPDATE trigger setting the ModifiedDate column in the StoreContact table to the current date. after Update Yes

Name	Description	Type	Enabled
uStoreContact	AFTER UPDATE trigger setting the ModifiedDate column in the StoreContact table to the current date.	after Update	Yes

Dependencies for table 'Sales.StoreContact', 3 items

Object Name Type Field Name

dbo.ufnGetContactInformation table function N/A

Sales.uStoreContact trigger N/A

Sales.vStoreWithDemographics view N/A