Production ProductReview (table)

wikibot

TableProduction.ProductReview
DescriptionCustomer reviews of products they have purchased.

Columns

ColumnData TypeNullableDefaultDescription
ProductReviewIDintnot null Primary key for ProductReview records.
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
ReviewerNamedbo.Namenot null Name of the reviewer.
ReviewDatedatetimenot null(getdate())Date review was submitted.
EmailAddressnvarchar(50)not null Reviewer's e-mail address.
Ratingintnot null Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Commentsnvarchar(3850)null Reviewer's comments
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductReview_ProductReviewIDProductReviewID

Indexes

IndexTypeColumns
IX_ProductReview_ProductID_Name ProductID, ReviewerName, Comments

Check Constraints

Check ConstraintExpressionDescription
CK_ProductReview_Rating(Rating>=(1) AND Rating<=(5))Check constraint Rating BETWEEN (1) AND (5)

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction