Editing Sales.StoreContact (table)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table
| Sales.StoreContact
|- valign="top"
| '''Description
| Cross-reference table mapping stores and their employees.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description

|- valign="top"
| CustomerID
| int
| not null
| 
| Store identification number. Foreign key to Customer.CustomerID.
|- valign="top"
| ContactID
| int
| not null
| 
| Contact (store employee) identification number. Foreign key to Contact.ContactID.
|- valign="top"
| ContactTypeID
| int
| not null
| 
| Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
|- valign="top"
| rowguid
| uniqueidentifier
| not null
| (newid())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| Date and time the record was last updated.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key
| '''Columns
|- valign="top"
| PK_StoreContact_CustomerID_ContactID
| CustomerID, ContactID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index
| '''Type
| '''Columns

|- valign="top"
| AK_StoreContact_rowguid
| Unique
| rowguid
|- valign="top"
| IX_StoreContact_ContactID
| 
| ContactID
|- valign="top"
| IX_StoreContact_ContactTypeID
| 
| ContactTypeID
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|- valign="top"
| [[Person.Contact_(table)|Person.Contact]]
| ContactID
| ContactID
|- valign="top"
| [[Person.ContactType_(table)|Person.ContactType]]
| ContactTypeID
| ContactTypeID
|- valign="top"
| [[Sales.Store_(table)|Sales.Store]]
| CustomerID
| CustomerID
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|- valign="top"
| Schema
| Schema
| [[Sales_(schema)|Sales]]

|}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

|- valign="top"
| Select
| View
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]

|- valign="top"
| Select
| SQL table-valued-function
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]

|}


== automatically generated ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.StoreContact
|- valign="top"
| '''Description
| Cross-reference table mapping stores and their employees.
|-
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| CustomerID
| int
| not null
| 
| Store identification number. Foreign key to Customer.CustomerID.<br />PK_StoreContact_CustomerID_ContactID
|- valign="top"
| ContactID
| int
| not null
| 
| Contact (store employee) identification number. Foreign key to Contact.ContactID.<br />PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
|- valign="top"
| ContactTypeID
| int
| not null
| 
| Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.<br />IX_StoreContact_ContactTypeID
|- valign="top"
| rowguid
| uniqueidentifier
| not null
| (NEWID())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StoreContact_rowguid
|- valign="top"
| ModifiedDate
| datetime
| not null
| (GETDATE())
| Date and time the record was last updated.<br />
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column
		
|-
| [[Person.Contact_(table)|Person.Contact]]
| ContactID
| ContactID
|-
| [[Person.ContactType_(table)|Person.ContactType]]
| ContactTypeID
| ContactTypeID
|-
| [[Sales.Store_(table)|Sales.Store]]
| CustomerID
| CustomerID
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|-
| Schema
| Schema
| [[Sales_(schema)|Sales]]

|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

|-
| Select
| View
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]

|-
| Select
| SQL table-valued-function
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]

|}