Sales.StoreContact (table)

wikibot

Table

Sales.StoreContact

Column	Data Type	Nullable	Default	PK	Index
CustomerID	int	not null		PK_StoreContact_CustomerID_ContactID
ContactID	int	not null		PK_StoreContact_CustomerID_ContactID	IX_StoreContact_ContactID
ContactTypeID	int	not null			IX_StoreContact_ContactTypeID
rowguid	uniqueidentifier	not null	(newid())		AK_StoreContact_rowguid
ModifiedDate	datetime	not null	(getdate())

Table	Sales.StoreContact
Description	Cross-reference table mapping stores and their employees.

Column	Data Type	Nullable	Default	Description	PK / Index
CustomerID	int	not null		Store identification number. Foreign key to Customer.CustomerID.	PK_StoreContact_CustomerID_ContactID
ContactID	int	not null		Contact (store employee) identification number. Foreign key to Contact.ContactID.	PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
ContactTypeID	int	not null		Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.	IX_StoreContact_ContactTypeID
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	AK_StoreContact_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.