Production.ProductReview (table)

From dbscript Online Help
Jump to: navigation, search

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