AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.SalesPersonQuotaHistory
Description:Sales performance tracking.
Primary Keys:SalesPersonID
QuotaDate
FieldTypeDefaultsNulls?Comments
SalesPersonIDintNoneNoSales person identification number. Foreign key to SalesPerson.SalesPersonID.
QuotaDatedatetimeNoneNoSales quota date.
SalesQuotamoneyNoneNoSales quota amount.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDateYesYesSalesPersonID
QuotaDate
AK_SalesPersonQuotaHistory_rowguidNoYesrowguid

Check ConstraintText
CK_SalesPersonQuotaHistory_SalesQuota([SalesQuota]>(0.00))

Internal Foreign Key ConstraintAffected FieldSource Table
FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonIDSalesPersonIDSales.SalesPerson

No primary keys as foreign key constraints
No triggers