← All tables and views
AdventureWorks OLTP table
Sales.SalesPerson
Sales representative current information.
17rows
9 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK | HumanResources.Employee.BusinessEntityID |
TerritoryID | INTEGER | yes | — | Sales.SalesTerritory.TerritoryID |
SalesQuota | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | yes | — | — |
Bonus | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
CommissionPct | DECIMAL_TEXT(10,4)Exact decimal · precision 10, scale 4 · text storage | no | — | — |
SalesYTD | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
SalesLastYear | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_SalesPerson_AK_SalesPerson_rowguidrowguid1 unique index inspected
Sales_SalesPerson_AK_SalesPerson_rowguidrowguidCREATE UNIQUE INDEX "Sales_SalesPerson_AK_SalesPerson_rowguid" ON "Sales.SalesPerson" ("rowguid")Data preview
Sample records
| BusinessEntityID | TerritoryID | SalesQuota | Bonus | CommissionPct | SalesYTD | SalesLastYear |
|---|---|---|---|---|---|---|
| 274 | NULL | NULL | .0000 | .0000 | 559697.5639 | .0000 |
| 275 | 2 | 300000.0000 | 4100.0000 | .0120 | 3763178.1787 | 1750406.4785 |
| 276 | 4 | 250000.0000 | 2000.0000 | .0150 | 4251368.5497 | 1439156.0291 |
| 277 | 3 | 250000.0000 | 2500.0000 | .0150 | 3189418.3662 | 1997186.2037 |
| 278 | 6 | 250000.0000 | 500.0000 | .0100 | 1453719.4653 | 1620276.8966 |
| 279 | 5 | 300000.0000 | 6700.0000 | .0100 | 2315185.6110 | 1849640.9418 |
| 280 | 1 | 250000.0000 | 5000.0000 | .0100 | 1352577.1325 | 1927059.1780 |
| 281 | 4 | 250000.0000 | 3550.0000 | .0100 | 2458535.6169 | 2073505.9999 |
Interactive explorer