Sales.Customer

Columns

• //

  ${escapify(column.description)}
  CustomerID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  PersonID
  [int] NULL
• //

  ${escapify(column.description)}
  StoreID
  [int] NULL
• //

  ${escapify(column.description)}
  TerritoryID
  [int] NULL
• //

  ${escapify(column.description)}
  AccountNumber
  [varchar](10) NOT NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Customer_CustomerID
  UNIQUE CLUSTERED
  CustomerID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Customer_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Unique nonclustered index.
  AK_Customer_AccountNumber
  UNIQUE NONCLUSTERED
  AccountNumber
• //

  Nonclustered index.
  IX_Customer_TerritoryID
  NONCLUSTERED
  TerritoryID

Foreign Keys

• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_Customer_Person_PersonID
  Person.Person
  PersonID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing SalesTerritory.TerritoryID.
  FK_Customer_SalesTerritory_TerritoryID
  Sales.SalesTerritory
  TerritoryID ⥱ TerritoryID
• //

  Foreign key constraint referencing Store.BusinessEntityID.
  FK_Customer_Store_StoreID
  Sales.Store
  StoreID ⥱ BusinessEntityID

Sample Data