AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.SalesReason
Description:Lookup table of customer purchase reasons.
Primary Keys:SalesReasonID
FieldTypeDefaultsNulls?Comments
SalesReasonIDint - IdentityNoneNoPrimary key for SalesReason records.
Namenvarchar (50)NoneNoSales reason description.
ReasonTypenvarchar (50)NoneNoCategory the sales reason belongs to.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_SalesReason_SalesReasonIDYesYesSalesReasonID

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonIDSales.SalesOrderHeaderSalesReasonSalesReasonID

No triggers