Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Person ContactType (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:02


wikibot

TablePerson.ContactType
DescriptionLookup table containing the types of contacts stored in Contact.

ColumnData TypeNullableDefaultDescription / PK / Index
ContactTypeIDintnot null Primary key for ContactType records.
PK_ContactType_ContactTypeID
Namedbo.Namenot null Contact type description.
AK_ContactType_Name
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.StoreContactContactTypeIDContactTypeID
Purchasing.VendorContactContactTypeIDContactTypeID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

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

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