AdventureWorks
| Table Name: | Sales.SalesPerson |
| Description: | Sales representative current information. |
| Primary Keys: | SalesPersonID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SalesPersonID | int | None | No | Primary key for SalesPerson records. |
| TerritoryID | int | None | Yes | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. |
| SalesQuota | money | None | Yes | Projected yearly sales. |
| Bonus | money | ((0.00)) | No | Bonus due if quota is met. |
| CommissionPct | smallmoney | ((0.00)) | No | Commision percent received per sale. |
| SalesYTD | money | ((0.00)) | No | Sales total year to date. |
| SalesLastYear | money | ((0.00)) | No | Sales total of previous year. |
| 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_SalesPerson_SalesPersonID | Yes | Yes | SalesPersonID |
| AK_SalesPerson_rowguid | No | Yes | rowguid |
| Check Constraint | Text |
|---|---|
| CK_SalesPerson_SalesQuota | ([SalesQuota]>(0.00)) |
| CK_SalesPerson_Bonus | ([Bonus]>=(0.00)) |
| CK_SalesPerson_CommissionPct | ([CommissionPct]>=(0.00)) |
| CK_SalesPerson_SalesYTD | ([SalesYTD]>=(0.00)) |
| CK_SalesPerson_SalesLastYear | ([SalesLastYear]>=(0.00)) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_SalesPerson_Employee_SalesPersonID | SalesPersonID | HumanResources.Employee |
| FK_SalesPerson_SalesTerritory_TerritoryID | TerritoryID | Sales.SalesTerritory |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_SalesOrderHeader_SalesPerson_SalesPersonID | Sales.SalesOrderHeader | SalesPersonID |
| FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID | Sales.SalesPersonQuotaHistory | SalesPersonID |
| FK_SalesTerritoryHistory_SalesPerson_SalesPersonID | Sales.SalesTerritoryHistory | SalesPersonID |
| FK_Store_SalesPerson_SalesPersonID | Sales.Store | SalesPersonID |