← All tables and views
AdventureWorks OLTP table
Sales.SalesReason
Lookup table of customer purchase reasons.
10rows
4 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
SalesReasonID | INTEGER | no | PK | — |
Name | TEXT | no | — | — |
ReasonType | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
No unique SQLite indexes were found.
Data preview
Sample records
| SalesReasonID | Name | ReasonType | ModifiedDate |
|---|---|---|---|
| 1 | Price | Other | 2019-04-30 00:00:00.000 |
| 2 | On Promotion | Promotion | 2019-04-30 00:00:00.000 |
| 3 | Magazine Advertisement | Marketing | 2019-04-30 00:00:00.000 |
| 4 | Television Advertisement | Marketing | 2019-04-30 00:00:00.000 |
| 5 | Manufacturer | Other | 2019-04-30 00:00:00.000 |
| 6 | Review | Other | 2019-04-30 00:00:00.000 |
| 7 | Demo Event | Marketing | 2019-04-30 00:00:00.000 |
| 8 | Sponsorship | Marketing | 2019-04-30 00:00:00.000 |
Interactive explorer