← All tables and views
AdventureWorks OLTP table
Sales.SalesOrderHeaderSalesReason
Cross-reference table mapping sales orders to sales reason codes.
27,647rows
3 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
SalesOrderID | INTEGER | no | PK 1/2 | Sales.SalesOrderHeader.SalesOrderID |
SalesReasonID | INTEGER | no | PK 2/2 | Sales.SalesReason.SalesReasonID |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_Sales.SalesOrderHeaderSalesReason_1SalesOrderID + SalesReasonIDData preview
Sample records
| SalesOrderID | SalesReasonID | ModifiedDate |
|---|---|---|
| 43697 | 5 | 2022-05-30 00:00:00.000 |
| 43697 | 9 | 2022-05-30 00:00:00.000 |
| 43702 | 5 | 2022-05-31 00:00:00.000 |
| 43702 | 9 | 2022-05-31 00:00:00.000 |
| 43703 | 5 | 2022-05-31 00:00:00.000 |
| 43703 | 9 | 2022-05-31 00:00:00.000 |
| 43706 | 5 | 2022-06-01 00:00:00.000 |
| 43706 | 9 | 2022-06-01 00:00:00.000 |
Interactive explorer