| Tables | SQL 2005 Adventure Works OLTP |
Customer reviews of products they have purchased.
Columns
Name Data type Nullable Description ProductReviewID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ProductReview records.ProductID int No Product identification number. Foreign key to Product.ProductID. ReviewerName Name No Name of the reviewer. ReviewDate datetime No Default value: GETDATE()
Date review was submitted.EmailAddress nvarchar(50) No Reviewer's e-mail address. Rating int No Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. Comments nvarchar(3850) Yes Reviewer's comments ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_ProductReview_ReviewDate DEFAULT ReviewDate Value: GETDATE()
Default constraint value of GETDATE()DF_ProductReview_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()CK_ProductReview_Rating CHECK N/A Value: ([Rating] BETWEEN 1 AND 5)
Check constraint [Rating] BETWEEN (1) AND (5)PK_ProductReview_ProductReviewID PRIMARY KEY ProductReviewID Clustered index created by a primary key constraint. FK_ProductReview_Product_ProductID FOREIGN KEY ProductID Reference table: Production.Product
Foreign key constraint referencing Product.ProductID.
Indices
Name Description IX_ProductReview_ProductID_Name Nonclustered index.
Triggers
Name Description Production.uProductReview AFTER UPDATE trigger setting the ModifiedDate column in the ProductReview table to the current date.
Modified by
Name Description Production.uProductReview AFTER UPDATE trigger setting the ModifiedDate column in the ProductReview table to the current date.
Applies to
Tables | User