From dbscript Online Help
wikibot
| Table
|
Sales.SalesPersonQuotaHistory
|
| Description
|
Sales performance tracking.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| SalesPersonID
|
int
|
not null
|
|
Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
|
| QuotaDate
|
datetime
|
not null
|
|
Sales quota date.
|
| SalesQuota
|
money
|
not null
|
|
Sales quota amount.
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key
| Primary Key
|
Columns
|
| PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
|
SalesPersonID, QuotaDate
|
Indexes
| Index
|
Type
|
Columns
|
| AK_SalesPersonQuotaHistory_rowguid
|
Unique
|
rowguid
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| CK_SalesPersonQuotaHistory_SalesQuota
|
([SalesQuota]>(0.00))
|
Check constraint [SalesQuota] > (0.00)
|
Foreign Keys
References
| Dependency Type
|
Object Type
|
Referenced Object
|
| Schema
|
Schema
|
Sales
|
automatically generated
| Table
|
Sales.SalesPersonQuotaHistory
|
| Description
|
Sales performance tracking.
|
| Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
| SalesPersonID
|
int
|
not null
|
|
Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
|
| QuotaDate
|
datetime
|
not null
|
|
Sales quota date.
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
|
| SalesQuota
|
money
|
not null
|
|
Sales quota amount.
|
| rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesPersonQuotaHistory_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
| Dependency Type
|
Object Type
|
Referenced Object
|
| Schema
|
Schema
|
Sales
|
