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