Sales.Individual (table)
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 |
automatically generated
Table | Sales.Individual |
Description | Demographic data about customers that purchase Adventure Works products online. |
Column | Data Type | Nullable | Default | Description / PK / Index |
CustomerID | int | not null | Unique customer identification number. Foreign key to Customer.CustomerID. PK_Individual_CustomerID | |
ContactID | int | not null | Identifies the customer in the Contact table. Foreign key to Contact.ContactID. | |
Demographics | XML | null | Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics | |
ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
Relation | Column | Referenced Column |
Person.Contact | ContactID | ContactID |
Sales.Customer | CustomerID | CustomerID |
Triggers | Type |
iuIndividual | ON INSERT UPDATE |
Dependency Type | Object Type | Referenced Object | Child Type | Child Object |
Schema | Schema | Sales | ||
Data Type | XML Schema Collection | Sales.IndividualSurveySchemaCollection | ||
Update | Table | Sales.Individual | Trigger | iuIndividual |
Select | Table | Sales.Store | Trigger | iuIndividual |
Reference Type | Object Type | Referencing Object | Child Type | Child Object |
Select | View | Sales.vIndividualCustomer | ||
Select | View | Sales.vIndividualDemographics | ||
Select | SQL table-valued-function | dbo.ufnGetContactInformation | ||
Update | Table | Sales.Individual | Trigger | iuIndividual |
Update | Table | Sales.SalesOrderDetail | Trigger | iduSalesOrderDetail |
Select | Table | Sales.Store | Trigger | iStore |