Production.ProductReview (table)

wikibot

Table

Production.ProductReview

Column	Data Type	Nullable	Default	PK	Index
ProductReviewID	int	not null		PK_ProductReview_ProductReviewID
ProductID	int	not null			IX_ProductReview_ProductID_Name
ReviewerName	dbo.Name	not null			IX_ProductReview_ProductID_Name
ReviewDate	datetime	not null	(getdate())
EmailAddress	nvarchar(50)	not null
Rating	int	not null
Comments	nvarchar(3850)	null			IX_ProductReview_ProductID_Name
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID

automatically generated

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

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