Production.ProductReview (table)

wikibot

Table	Production.ProductReview
Description	Customer reviews of products they have purchased.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductReviewID	int	not null		Primary key for ProductReview records. PK_ProductReview_ProductReviewID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_ProductReview_ProductID_Name
ReviewerName	dbo.Name	not null		Name of the reviewer. IX_ProductReview_ProductID_Name
ReviewDate	datetime	not null	(getdate())	Date review was submitted.
EmailAddress	nvarchar(50)	not null		Reviewer's e-mail address.
Rating	int	not null		Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Comments	nvarchar(3850)	null		Reviewer's comments IX_ProductReview_ProductID_Name
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name

Table	Production.ProductReview
Description	Customer reviews of products they have purchased.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductReviewID	int	not null		Primary key for ProductReview records. PK_ProductReview_ProductReviewID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_ProductReview_ProductID_Name
ReviewerName	Name	not null		Name of the reviewer. IX_ProductReview_ProductID_Name
ReviewDate	datetime	not null	(GETDATE())	Date review was submitted.
EmailAddress	nvarchar(50)	not null		Reviewer's e-mail address.
Rating	int	not null		Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Comments	nvarchar(3850)	not null		Reviewer's comments IX_ProductReview_ProductID_Name
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID