Production.ProductReview

Table: 'Production.ProductReview'

8 fields. 7944 bytes.

Customer reviews of products they have purchased.

Field Name Data Type Size Original Type Default Nullable Description Check

ProductReviewID int identity int Not null Primary key for ProductReview records.

ProductID int Not null Product identification number. Foreign key to Product.ProductID.

ReviewerName Name nvarchar(50) Not null Name of the reviewer.

ReviewDate datetime getdate() Not null 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. ([Rating]>=(1) AND [Rating]<=(5))

Comments nvarchar 3850 Null Reviewer's comments

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductReviewID	int identity		int		Not null	Primary key for ProductReview records.
ProductID	int				Not null	Product identification number. Foreign key to Product.ProductID.
ReviewerName	Name		nvarchar(50)		Not null	Name of the reviewer.
ReviewDate	datetime			getdate()	Not null	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.	([Rating]>=(1) AND [Rating]<=(5))
Comments	nvarchar	3850			Null	Reviewer's comments
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductReview'

Primary Key Name Field Name

PK_ProductReview_ProductReviewID ProductReviewID

Primary Key Name	Field Name
PK_ProductReview_ProductReviewID	ProductReviewID

Foreign keys for table 'Production.ProductReview', 1 item

Foreign Primary Key Name

ProductReview.ProductID Product.ProductID FK_ProductReview_Product_ProductID

Foreign	Primary	Key Name
ProductReview.ProductID	Product.ProductID	FK_ProductReview_Product_ProductID

Indexes for table 'Production.ProductReview', 2 items

Index Name Description Clustered Unique Fields

PK_ProductReview_ProductReviewID Clustered index created by a primary key constraint. Yes Yes ProductReviewID

IX_ProductReview_ProductID_Name Nonclustered index. No No ProductID, ReviewerName

Index Name	Description	Clustered	Unique	Fields
PK_ProductReview_ProductReviewID	Clustered index created by a primary key constraint.	Yes	Yes	ProductReviewID
IX_ProductReview_ProductID_Name	Nonclustered index.	No	No	ProductID, ReviewerName

Triggers for table 'Production.ProductReview', 1 item

Name Description Type Enabled

uProductReview AFTER UPDATE trigger setting the ModifiedDate column in the ProductReview table to the current date. after Update Yes

Name	Description	Type	Enabled
uProductReview	AFTER UPDATE trigger setting the ModifiedDate column in the ProductReview table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductReview', 2 items

Object Name Type Field Name

Production.CK_ProductReview_Rating check cns N/A

Production.uProductReview trigger N/A

Object Name	Type	Field Name
Production.CK_ProductReview_Rating	check cns	N/A
Production.uProductReview	trigger	N/A