Sales.Individual (table)

From dbscript Online Help
Revision as of 14:34, 3 January 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.Individual |- |} {| border="1" cellpadding="5" cellspacing="0" style="...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table Sales.Individual


Column Data Type Nullable Default PK Index
CustomerID int not null PK_Individual_CustomerID
ContactID int not null
Demographics xml null PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.Customer CustomerID CustomerID


Triggers Type
iuIndividual ON INSERT UPDATE