Object type: Table

Sales performance tracking.

Columns 

Name	Data type	Nullable	Description
SalesPersonID	int	No	Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
QuotaDate	datetime	No	Sales quota date.
SalesQuota	money	No	Sales quota amount.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_SalesPersonQuotaHistory_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_SalesPersonQuotaHistory_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
CK_SalesPersonQuotaHistory_SalesQuota	CHECK	N/A	Value: ([SalesQuota] > 0.00) Check constraint [SalesQuota]>(0.00)
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate	PRIMARY KEY	SalesPersonID QuotaDate	Clustered index created by a primary key constraint.
FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID	FOREIGN KEY	SalesPersonID	Reference table: Sales.SalesPerson Foreign key constraint referencing SalesPerson.SalesPersonID.

Indices 

Name	Description
AK_SalesPersonQuotaHistory_rowguid	Unique nonclustered index.Used to support replication samples.

Triggers 

Name	Description
Sales.uSalesPersonQuotaHistory	AFTER UPDATE trigger setting the ModifiedDate column in the SalesPersonQuotaHistory table to the current date.

Modified by 

Name	Description
Sales.uSalesPersonQuotaHistory	AFTER UPDATE trigger setting the ModifiedDate column in the SalesPersonQuotaHistory table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation