Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales StoreContact (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:49


wikibot

TableSales.StoreContact
DescriptionCross-reference table mapping stores and their employees.

ColumnData TypeNullableDefaultDescription / PK / Index
CustomerIDintnot null Store identification number. Foreign key to Customer.CustomerID.
PK_StoreContact_CustomerID_ContactID
ContactIDintnot null Contact (store employee) identification number. Foreign key to Contact.ContactID.
PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
ContactTypeIDintnot null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
IX_StoreContact_ContactTypeID
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_StoreContact_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Person.ContactContactIDContactID
Person.ContactTypeContactTypeIDContactTypeID
Sales.StoreCustomerIDCustomerID

Reference TypeObject TypeReferencing Object
SelectViewSales.vStoreWithDemographics
SelectSQL table-valued-functiondbo.ufnGetContactInformation

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.