Table: 'Production.ProductReview'

8 fields. 7944 bytes.

Customer reviews of products they have purchased.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductReviewIDint identity int Not nullPrimary key for ProductReview records. 
ProductIDint   Not nullProduct identification number. Foreign key to Product.ProductID. 
ReviewerNameName nvarchar(50) Not nullName of the reviewer. 
ReviewDatedatetime  getdate()Not nullDate review was submitted. 
EmailAddressnvarchar50  Not nullReviewer's e-mail address. 
Ratingint   Not nullProduct rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.([Rating]>=(1) AND [Rating]<=(5))
Commentsnvarchar3850  NullReviewer's comments 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductReview'

Primary Key NameField Name

Foreign keys for table 'Production.ProductReview', 1 item

ForeignPrimaryKey Name

Indexes for table 'Production.ProductReview', 2 items

Index NameDescriptionClusteredUniqueFields
PK_ProductReview_ProductReviewIDClustered index created by a primary key constraint.YesYesProductReviewID
IX_ProductReview_ProductID_NameNonclustered index.NoNoProductID, ReviewerName

Triggers for table 'Production.ProductReview', 1 item

uProductReviewAFTER UPDATE trigger setting the ModifiedDate column in the ProductReview table to the current date.after Update Yes

Dependencies for table 'Production.ProductReview', 2 items

Object NameTypeField Name
Production.CK_ProductReview_Ratingcheck cnsN/A