Sales.Customers

Columns

• //

  ${escapify(column.description)}
  CustomerID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[CustomerID])
• //

  ${escapify(column.description)}
  CustomerName
  [nvarchar](100) NOT NULL
• //

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

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

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

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

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

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

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

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

  ${escapify(column.description)}
  CreditLimit
  [decimal](18, 2) NULL
• //

  ${escapify(column.description)}
  AccountOpenedDate
  [date] NOT NULL
• //

  ${escapify(column.description)}
  StandardDiscountPercentage
  [decimal](18, 3) NOT NULL
• //

  ${escapify(column.description)}
  IsStatementSent
  [bit] NOT NULL
• //

  ${escapify(column.description)}
  IsOnCreditHold
  [bit] NOT NULL
• //

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

  ${escapify(column.description)}
  PhoneNumber
  [nvarchar](20) NOT NULL
• //

  ${escapify(column.description)}
  FaxNumber
  [nvarchar](20) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryRun
  [nvarchar](5) NULL
• //

  ${escapify(column.description)}
  RunPosition
  [nvarchar](5) NULL
• //

  ${escapify(column.description)}
  WebsiteURL
  [nvarchar](256) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryAddressLine1
  [nvarchar](60) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryAddressLine2
  [nvarchar](60) NULL
• //

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

  ${escapify(column.description)}
  DeliveryLocation
  [geography] NULL
• //

  ${escapify(column.description)}
  PostalAddressLine1
  [nvarchar](60) NOT NULL
• //

  ${escapify(column.description)}
  PostalAddressLine2
  [nvarchar](60) NULL
• //

  ${escapify(column.description)}
  PostalPostalCode
  [nvarchar](10) NOT NULL
• LastEditedBy
  [int] NOT NULL
• ValidFrom
  [datetime2](8) NOT NULL
• ValidTo
  [datetime2](8) NOT NULL

Indexes

• PK_Sales_Customers
  UNIQUE CLUSTERED
  CustomerID
• UQ_Sales_Customers_CustomerName
  UNIQUE NONCLUSTERED
  CustomerName
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_CustomerCategoryID
  NONCLUSTERED
  CustomerCategoryID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_BuyingGroupID
  NONCLUSTERED
  BuyingGroupID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_PrimaryContactPersonID
  NONCLUSTERED
  PrimaryContactPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_AlternateContactPersonID
  NONCLUSTERED
  AlternateContactPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_DeliveryMethodID
  NONCLUSTERED
  DeliveryMethodID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_DeliveryCityID
  NONCLUSTERED
  DeliveryCityID
• //

  Auto-created to support a foreign key
  FK_Sales_Customers_PostalCityID
  NONCLUSTERED
  PostalCityID
• //

  Improves performance of order picking and invoicing
  IX_Sales_Customers_Perf_20160301_06
  NONCLUSTERED
  IsOnCreditHold , CustomerID , BillToCustomerID , PrimaryContactPersonID

Foreign Keys

• FK_Sales_Customers_AlternateContactPersonID_Application_People
  Application.People
  AlternateContactPersonID ⥱ PersonID
• FK_Sales_Customers_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Sales_Customers_BillToCustomerID_Sales_Customers
  Sales.Customers
  BillToCustomerID ⥱ CustomerID
• FK_Sales_Customers_BuyingGroupID_Sales_BuyingGroups
  Sales.BuyingGroups
  BuyingGroupID ⥱ BuyingGroupID
• FK_Sales_Customers_CustomerCategoryID_Sales_CustomerCategories
  Sales.CustomerCategories
  CustomerCategoryID ⥱ CustomerCategoryID
• FK_Sales_Customers_DeliveryCityID_Application_Cities
  Application.Cities
  DeliveryCityID ⥱ CityID
• FK_Sales_Customers_DeliveryMethodID_Application_DeliveryMethods
  Application.DeliveryMethods
  DeliveryMethodID ⥱ DeliveryMethodID
• FK_Sales_Customers_PostalCityID_Application_Cities
  Application.Cities
  PostalCityID ⥱ CityID
• FK_Sales_Customers_PrimaryContactPersonID_Application_People
  Application.People
  PrimaryContactPersonID ⥱ PersonID

Sample Data