Sales.SalesPersonQuotaHistory Table

Information

NameSalesPersonQuotaHistory
SchemaSales
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:55

Extended Properties

NameTypeProperty NameValue
SalesPersonQuotaHistoryTABLEMS_DescriptionSales performance tracking.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   SalesPersonIDint  Sales.SalesPerson.SalesPersonID
 
 
 
   QuotaDatedatetime   
 
 
 
   SalesQuotamoney   
 
 
 
   rowguiduniqueidentifier   
(newid())
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDateClustered  SalesPersonID, QuotaDate
AK_SalesPersonQuotaHistory_rowguidNonClustered  rowguid

Check Constraints

NameColumnEnabledTrustedExpression
CK_SalesPersonQuotaHistory_SalesQuotaSalesQuota  ([SalesQuota]>(0.00))

Foreign Key Constraints

NameTypeReferenced Table
FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonIDForeign keySales.SalesPerson

SQL Script

CREATE TABLE [Sales].[SalesPersonQuotaHistory] (
    [SalesPersonID] int NOT NULL,
    [QuotaDate] datetime NOT NULL,
    [SalesQuota] money NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SalesPersonQuotaHistory_rowguid] on [Sales].[SalesPersonQuotaHistory]([rowguid]);