AdventureWorks
| Table Name: | Sales.SalesReason |
| Description: | Lookup table of customer purchase reasons. |
| Primary Keys: | SalesReasonID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SalesReasonID | int - Identity | None | No | Primary key for SalesReason records. |
| Name | nvarchar (50) | None | No | Sales reason description. |
| ReasonType | nvarchar (50) | None | No | Category the sales reason belongs to. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_SalesReason_SalesReasonID | Yes | Yes | SalesReasonID |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID | Sales.SalesOrderHeaderSalesReason | SalesReasonID |