Sales.SalesPerson Table

Information

Name	SalesPerson
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:55

Extended Properties

Name	Type	Property Name	Value
SalesPerson	TABLE	MS_Description	Sales representative current information.

Columns

Name	Data Type	References	Default
SalesPersonID	int	HumanResources.Employee.EmployeeID
TerritoryID	int	Sales.SalesTerritory.TerritoryID
SalesQuota	money
Bonus	money		((0.00))
CommissionPct	smallmoney		((0.00))
SalesYTD	money		((0.00))
SalesLastYear	money		((0.00))
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_SalesPerson_SalesPersonID	Clustered			SalesPersonID
AK_SalesPerson_rowguid	NonClustered			rowguid

Check Constraints

Name	Column	Expression
CK_SalesPerson_SalesQuota	SalesQuota	([SalesQuota]>(0.00))
CK_SalesPerson_Bonus	Bonus	([Bonus]>=(0.00))
CK_SalesPerson_CommissionPct	CommissionPct	([CommissionPct]>=(0.00))
CK_SalesPerson_SalesYTD	SalesYTD	([SalesYTD]>=(0.00))
CK_SalesPerson_SalesLastYear	SalesLastYear	([SalesLastYear]>=(0.00))

Foreign Key Constraints

Name	Type	Referenced Table
FK_SalesPerson_Employee_SalesPersonID	Foreign key	HumanResources.Employee
FK_SalesPerson_SalesTerritory_TerritoryID	Foreign key	Sales.SalesTerritory

SQL Script

CREATE TABLE [Sales].[SalesPerson] (
    [SalesPersonID] int NOT NULL,
    [TerritoryID] int NULL,
    [SalesQuota] money NULL,
    [Bonus] money NOT NULL DEFAULT ((0.00)),
    [CommissionPct] smallmoney NOT NULL DEFAULT ((0.00)),
    [SalesYTD] money NOT NULL DEFAULT ((0.00)),
    [SalesLastYear] money NOT NULL DEFAULT ((0.00)),
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SalesPerson_rowguid] on [Sales].[SalesPerson]([rowguid]);