Sales.StoreContact

Table: 'Sales.StoreContact'

5 fields. 44 bytes.

Cross-reference table mapping stores and their employees.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CustomerIDint   Not nullStore identification number. Foreign key to Customer.CustomerID. 
ContactIDint   Not nullContact (store employee) identification number. Foreign key to Contact.ContactID. 
ContactTypeIDint   Not nullContact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.StoreContact'

Primary Key NameField Names
PK_StoreContact_CustomerID_ContactIDCustomerID, ContactID

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

ForeignPrimaryKey Name
StoreContact.ContactIDContact.ContactIDFK_StoreContact_Contact_ContactID
StoreContact.ContactTypeIDContactType.ContactTypeIDFK_StoreContact_ContactType_ContactTypeID
StoreContact.CustomerIDStore.CustomerIDFK_StoreContact_Store_CustomerID

Indexes for table 'Sales.StoreContact', 4 items

Index NameDescriptionClusteredUniqueFields
PK_StoreContact_CustomerID_ContactIDClustered index created by a primary key constraint.YesYesCustomerID, ContactID
AK_StoreContact_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid
IX_StoreContact_ContactIDNonclustered index.NoNoContactID
IX_StoreContact_ContactTypeIDNonclustered index.NoNoContactTypeID

Triggers for table 'Sales.StoreContact', 1 item

NameDescriptionTypeEnabled
uStoreContactAFTER 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 NameTypeField Name
dbo.ufnGetContactInformationtable functionN/A
Sales.uStoreContacttriggerN/A
Sales.vStoreWithDemographicsviewN/A