Sales.Individual Table

Information

Name	Individual
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
Individual	TABLE	MS_Description	Demographic data about customers that purchase Adventure Works products online.

Columns

Name	Data Type	References	Default
CustomerID	int	Sales.Customer.CustomerID
ContactID	int	Person.Contact.ContactID
Demographics	xml
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_Individual_CustomerID	Clustered			CustomerID

Foreign Key Constraints

Name	Type	Referenced Table
FK_Individual_Contact_ContactID	Foreign key	Person.Contact
FK_Individual_Customer_CustomerID	Foreign key	Sales.Customer

Triggers

Name	Activates on	Instead Of	For Replication	Enabled	Created	Modified
iuIndividual	INSERT, UPDATE				29.3.2010. 21:58:56	29.3.2010. 21:58:56

SQL Script

CREATE TABLE [Sales].[Individual] (
    [CustomerID] int NOT NULL,
    [ContactID] int NOT NULL,
    [Demographics] xml NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);