Production.ProductReview (table)

wikibot

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

Columns

Column	Data Type	Nullable	Default	Description
ProductReviewID	int	not null		Primary key for ProductReview records.
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID.
ReviewerName	dbo.Name	not null		Name of the reviewer.
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
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_ProductReview_ProductReviewID	ProductReviewID

Indexes

Index	Type	Columns
IX_ProductReview_ProductID_Name		ProductID, ReviewerName, Comments

Check Constraints

Check Constraint	Expression	Description
CK_ProductReview_Rating	([Rating]>=(1) AND [Rating]<=(5))	Check constraint [Rating] BETWEEN (1) AND (5)

Foreign Keys

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID

References

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

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

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