AdventureWorks
| Table Name: | Sales.SalesPersonQuotaHistory |
| Description: | Sales performance tracking. |
| Primary Keys: | SalesPersonID QuotaDate |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SalesPersonID | int | None | No | Sales person identification number. Foreign key to SalesPerson.SalesPersonID. |
| QuotaDate | datetime | None | No | Sales quota date. |
| SalesQuota | money | None | No | Sales quota amount. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate | Yes | Yes | SalesPersonID QuotaDate |
| AK_SalesPersonQuotaHistory_rowguid | No | Yes | rowguid |
| Check Constraint | Text |
|---|---|
| CK_SalesPersonQuotaHistory_SalesQuota | ([SalesQuota]>(0.00)) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID | SalesPersonID | Sales.SalesPerson |