AdventureWorks
| Table Name: | Sales.SalesOrderHeaderSalesReason |
| Description: | Cross-reference table mapping sales orders to sales reason codes. |
| Primary Keys: | SalesOrderID SalesReasonID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SalesOrderID | int | None | No | Primary key. Foreign key to SalesOrderHeader.SalesOrderID. |
| SalesReasonID | int | None | No | Primary key. Foreign key to SalesReason.SalesReasonID. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID | Yes | Yes | SalesOrderID SalesReasonID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID | SalesOrderID | Sales.SalesOrderHeader |
| FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID | SalesReasonID | Sales.SalesReason |