← All tables and views
AdventureWorks OLTP table
Sales.SalesOrderDetail
Individual products associated with a specific sales order. See SalesOrderHeader.
121,317rows
11 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
SalesOrderID | INTEGER | no | PK 1/2 | Sales.SalesOrderHeader.SalesOrderID |
SalesOrderDetailID | INTEGER | no | PK 2/2 | — |
CarrierTrackingNumber | TEXT | yes | — | — |
OrderQty | INTEGER | no | — | — |
ProductID | INTEGER | no | — | Sales.SpecialOfferProduct.ProductID |
SpecialOfferID | INTEGER | no | — | Sales.SpecialOfferProduct.SpecialOfferID |
UnitPrice | NUMERIC | no | — | — |
UnitPriceDiscount | NUMERIC | no | — | — |
LineTotal | NUMERIC | yes | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_SalesOrderDetail_AK_SalesOrderDetail_rowguidrowguid2 unique indexes inspected
Sales_SalesOrderDetail_AK_SalesOrderDetail_rowguidrowguidCREATE UNIQUE INDEX "Sales_SalesOrderDetail_AK_SalesOrderDetail_rowguid" ON "Sales.SalesOrderDetail" ("rowguid")sqlite_autoindex_Sales.SalesOrderDetail_1SalesOrderID + SalesOrderDetailIDData preview
Sample records
| SalesOrderID | SalesOrderDetailID | CarrierTrackingNumber | OrderQty | ProductID | SpecialOfferID | UnitPrice |
|---|---|---|---|---|---|---|
| 43659 | 1 | 4911-403C-98 | 1 | 776 | 1 | 2024.994 |
| 43659 | 2 | 4911-403C-98 | 3 | 777 | 1 | 2024.994 |
| 43659 | 3 | 4911-403C-98 | 1 | 778 | 1 | 2024.994 |
| 43659 | 4 | 4911-403C-98 | 1 | 771 | 1 | 2039.994 |
| 43659 | 5 | 4911-403C-98 | 1 | 772 | 1 | 2039.994 |
| 43659 | 6 | 4911-403C-98 | 2 | 773 | 1 | 2039.994 |
| 43659 | 7 | 4911-403C-98 | 1 | 774 | 1 | 2039.994 |
| 43659 | 8 | 4911-403C-98 | 3 | 714 | 1 | 28.8404 |
Interactive explorer