Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 24648 
Index Size KB: 56 
Rows: 18484 
Description: Demographic data about customers that purchase Adventure Works products online. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    CustomerID  int          Unique customer identification number. Foreign key to Customer.CustomerID. 
    ContactID  int          Identifies the customer in the Contact table. Foreign key to Contact.ContactID. 
    Demographics  xml  -1          Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)


Index Primary Unique Description
  PK_Individual_CustomerID      Primary key (clustered) constraint 
  PXML_Individual_Demographics      Primary XML index. 
  XMLPATH_Individual_Demographics      Secondary XML index for path. 
  XMLPROPERTY_Individual_Demographics      Secondary XML index for property. 
  XMLVALUE_Individual_Demographics      Secondary XML index for value. 
Total: 5 index(es)


Name Owner Instead Of Disabled Table/View Description
  iuIndividual  Sales      Sales.Individual  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. 
Total: 1 trigger(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.Contact  FK_Individual_Contact_ContactID  PK_Contact_ContactID 
  Sales.Customer  FK_Individual_Customer_CustomerID  PK_Customer_CustomerID 
Total: 2 table(s)

Objects that [Sales].[Individual] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
  NameStyle  dbo  User Defined type 
  Phone  dbo  User Defined type 
  ufnLeadingZeros  dbo  Function 
  Contact  Person  Table 
  SalesTerritory  Sales  Table 
  Customer  Sales  Table 
Total: 7 object(s)

Objects that depend on [Sales].[Individual]

Object Name Owner Object Type Dep Level
  ufnGetContactInformation  dbo  Function 
  vIndividualCustomer  Sales  View 
  vIndividualDemographics  Sales  View 
  iduSalesOrderDetail  Sales  Trigger 
  iStore  Sales  Trigger 
  iuIndividual  Sales  Trigger 
Total: 6 object(s)


CREATE TABLE [Individual] (
    [CustomerID] [int] NOT NULL ,
    [ContactID] [int] NOT NULL ,
    [Demographics] [xml] NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Individual_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_Individual_Contact_ContactID] FOREIGN KEY
    ) REFERENCES [Contact] (
    CONSTRAINT [FK_Individual_Customer_CustomerID] FOREIGN KEY
    ) REFERENCES [Customer] (

See Also

List of tables