Production.ProductReview - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductReview
Module	Products

Customer reviews of products they have purchased.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductReviewID	int		Identity		Primary key for ProductReview records.
Primary key for ProductReview records. Identity
	2		ProductID	int			Production.Product	Product identification number. Foreign key to Product.ProductID.
Product identification number. Foreign key to Product.ProductID. References: Production.Product
	3		ReviewerName	nvarchar(50)				Name of the reviewer.
Name of the reviewer.
	4		ReviewDate	datetime		Default: getdate()		Date review was submitted.
Date review was submitted. Default: getdate()
	5		EmailAddress	nvarchar(50)				Reviewer's e-mail address.
Reviewer's e-mail address.
	6		Rating	int				Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
	7		Comments	nvarchar(3850)				Reviewer's comments
Reviewer's comments
	8		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductReview		Production.Product	Production.ProductReview.ProductID = Production.Product.ProductID	FK_ProductReview_Product_ProductID Foreign key constraint referencing Product.ProductID.
Production.ProductReview.ProductID = Production.Product.ProductID Name: FK_ProductReview_Product_ProductID Foreign key constraint referencing Product.ProductID.

Unique keys

	Key name	Columns	Description
	PK_ProductReview_ProductReviewID	ProductReviewID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Production.ProductReview
Production.Product

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56