Sales.SalesPerson

Columns

• //

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

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

  ${escapify(column.description)}
  SalesQuota
  [money] NULL

  //

  CONSTRAINT: Check constraint [SalesQuota] > (0.00)

  ([SalesQuota]>(0.00))
• //

  ${escapify(column.description)}
  Bonus
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [Bonus] >= (0.00)

  ([Bonus]>=(0.00))
• //

  ${escapify(column.description)}
  CommissionPct
  [smallmoney] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [CommissionPct] >= (0.00)

  ([CommissionPct]>=(0.00))
• //

  ${escapify(column.description)}
  SalesYTD
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [SalesYTD] >= (0.00)

  ([SalesYTD]>=(0.00))
• //

  ${escapify(column.description)}
  SalesLastYear
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [SalesLastYear] >= (0.00)

  ([SalesLastYear]>=(0.00))
• //

  ${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_SalesPerson_BusinessEntityID
  UNIQUE CLUSTERED
  BusinessEntityID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SalesPerson_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Foreign Keys

• //

  Foreign key constraint referencing Employee.EmployeeID.
  FK_SalesPerson_Employee_BusinessEntityID
  HumanResources.Employee
  BusinessEntityID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing SalesTerritory.TerritoryID.
  FK_SalesPerson_SalesTerritory_TerritoryID
  Sales.SalesTerritory
  TerritoryID ⥱ TerritoryID

Sample Data