Sales.Individual

Field Name Data Type Size Original Type Default Nullable Description Check

CustomerID int Not null Unique customer identification number. Foreign key to Customer.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.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Default	Nullable	Description
CustomerID	int		Not null	Unique customer identification number. Foreign key to Customer.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.
ModifiedDate	datetime	getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.Individual'

Primary Key Name Field Name

PK_Individual_CustomerID CustomerID

Primary Key Name	Field Name
PK_Individual_CustomerID	CustomerID

Foreign keys for table 'Sales.Individual', 2 items

Foreign Primary Key Name

Individual.ContactID Contact.ContactID FK_Individual_Contact_ContactID

Individual.CustomerID Customer.CustomerID FK_Individual_Customer_CustomerID

Foreign	Primary	Key Name
Individual.ContactID	Contact.ContactID	FK_Individual_Contact_ContactID
Individual.CustomerID	Customer.CustomerID	FK_Individual_Customer_CustomerID

Indexes for table 'Sales.Individual', 1 item

Index Name Description Clustered Unique Fields

PK_Individual_CustomerID Clustered index created by a primary key constraint. Yes Yes CustomerID

Index Name	Description	Clustered	Unique	Fields
PK_Individual_CustomerID	Clustered index created by a primary key constraint.	Yes	Yes	CustomerID

Triggers for table 'Sales.Individual', 1 item

Name Description Type Enabled

iuIndividual AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date. after Insert Update Yes

Name	Description	Type	Enabled
iuIndividual	AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date.	after Insert Update	Yes

Dependencies for table 'Sales.Individual', 6 items

Object Name Type Field Name

dbo.ufnGetContactInformation table function N/A

Sales.iduSalesOrderDetail trigger N/A

Sales.iStore trigger N/A

Sales.iuIndividual trigger N/A

Sales.vIndividualCustomer view N/A

Sales.vIndividualDemographics view N/A